upgrading mysql, prepare database?

[redbox]

We plan to upgrade our vB from 3.6 to 3.7.x. We currently run mysql 4.1.22 and php 4.3.3.

We want to upgrade because vB says PHP 5.2.6 and MySQL 5.0.51 are recommended for better performance.

Is there anything I need to do to prepare my databases for the upgrade? Naturally I'll make backups of all of my databases before the upgrade. Usually when I make a backup copy of a db, I do it through shell and it's quick and easy. When browsing the export function of phpmyadmin, it offers the option to export or import per sql compatibility mode. Is this something I need to take into consideration? I'm thinking not only of my vB database, but also of the other mysql databases I have on my server that will go along for the ride.

Thanks :)

[Steve Machol]

I upgraded PHP and MySQL like this with no problems at all. Backing up the databases should be sufficient.

[eva2000]

for major mysql version updates i.e. 4.1.x to 5.0.x i always dump databases to sql backup and upgrade mysql and reimport sql into newly created mysql 5.0.x databases - see http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html