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

[sugoll.livejournal.com]

That shouldn't be the case. Admittedly, I was going in the other direction, but I managed to use v5 versions of both mysqldump and mysql when dumping data from my v5 db to waveney's v3 server. The --compatible=mysql323 switch was needed when dumping so that things like views got converted into tables, and various other bits of syntax was commented appropriately (MySQL's dump format is just SQL, but it'll include comments around stuff with versions embedded, and clients of a suitable rev or above will look inside the comments and treat them as actual SQL).