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]

It's not that much of a problem; the dump format is just SQL to re-create the data (hardly space-efficient, but who cares?).

[wimble.livejournal.com]

Well, if the mysqldump fails to understand the format of the database it's extracting from (I've no idea whether it reads the database directly, or invokes some sort of connector to perform the access), then it'll generate perfectly valid SQL, but the constants in the generated SQL won't represent the values correctly.