what is the right way to change a database to a new server which runs also a newer version of MySQL?

[Christian Schrattenthaler]

Hi!

I have a very old (3.x) database which should be moved to a MySQL server 5.5x installation.

I found out that I have to do this over mysqldump, and that I have to do more than one steps.

The database was copyied a long time ago via a normal copy statement from windows to a version 4.0.x. From there I made a adump file, repaired some wron keys, changed the parameter type to engine, and imported it into a Version 4.1.x. From there I mad again a dump file and importiet it on the new MySQL 5.5.x. Directly from 4.0.x to 5.5.x didn't work.

Now I am not sure if I need any additional steps? Was my way ok? Is there any mistake? Can I check if the old data is similar with the data on the new server?

Any hints are welcome.

Thanks,
Christian.