Upgrading 4.0.20 to something a little more recent..

[Nimlhûg]

Howdy folks,

Got myself in a bit of a pickle. I haven't upgraded my MySQL in absolutely years, and I need some of the newer features. What's the easiest way of upgrading without losing any data? Is it to just make a huge SQL dump of all the databases and restoring them like that afterwards, or is there a way I can simply compile a new version, dump it on top of the old one and keep the data files?

Thanks

[guelphdad]

read the docs on the mysql site. they recommend upgrading to 4.1 and then on to mysql 5.

there are certain things you need to do to update your passwords etc.

I think you could do a mysqldump of your databases and restore from there after upgrading.