Techy issue .... MySQL3 to MySQL5

[gaspode]

OK ... I need to move some databases off a server running MySQL3 to another running MySQL5 (both are FreeBSD based) ...

How do I do it (someone said i can simply copy the mysqldump from the server running V5 to the server running v3, run it and then just restore on the 5 - does this sound feasible ?)

Ta

Comments

[wimble.livejournal.com]

I know as little as I possibly can about MySQL. Certainly not this much.

But yes, it sounds plausible. Extract the data from the existing database, copy it to the new server, and then re-insert it. I'm taking your word for it that extraction and insertion tools exist ;-)

[glitterboy1.livejournal.com]

I've never tried running the mysqldump from one version against a different version's database (can't you just use mysqldump from v.3?), but if that works, then the plan sounds feasible.

Separately, you'll need to recreate the required users on the v.5 server.

[sugoll.livejournal.com]

Assuming that both systems are on the network, you shouldn't need to copy the mysqldump binary. You can do:

mysqldump -u root --password=xxx -h oldhost olddbname | \
mysql -u root --password=yyy newdbname

(You might want to be more selective over the account name, or try importing the resulting dump into a new, trial database first...)

There's a compatibility switch, e.g.:

--compatible=mysql323

which tells mysqldump to create a dump suitable for feeding into said version - handy going from a newer system to an old one, but since you're going the other way, you should be okay.