dan1088352
09-23-2005, 01:18 AM
I need to transfer my database to a MySQL 4.0.24 server, that is an older version that the one here, how do I do that?
kyzen
09-23-2005, 05:39 AM
You have multiple options open to you, mostly though it depends on the size and content of your database.
Obviously the first thing you should try doing is exporting your database and importing it into the other system - sometimes it works, sometimes it doesn't, but since it's the easiest, it's obviously worth trying.
If that doesn't work, you can look around the web for tools to do it for you. I don't know of any for MySQL off the top of my head, but I'm sure they exist.
Lastly, the most tedious, but surefire option you have would be to set up the tables on your new DB exactly as they are on your old one, then run a query to copy everything over one record at a time.
I've had to do the last option before with several databases (though usually when I was going from one type of DBMS to a completely different one, like Access to MySQL), it works, but it's annoying.