How to migrate a MySql 4.x database to MySQL 5.0?

Question

I have a zip file for a Windows MySQL 4.x installation database which includes the MySQL files and the databases files (.myi, .myd, frm). I have a Windows MySQL 5.0 running installation.

I need to bring one of the databases from the zip file to life in the current active MySQL 5.0. How can this be done?

Answer 1

With your first database running in your mysql 4 database, run a mysql dump

mysqldump dbname > dbname.sql

Then load that file up in your mysql 5 database...

mysql -e "create database dbname"
mysql dbname < dbname.sql

Of course you'll have to set up your users manually.