thoughts of a doug

I just installed MySQL 5.0.27 today. I used to use MySQL 4.1.x, but I decided that I’d move to 5.0.x since it is now the GA release. I had all my previous databases backed up in their binary format, and since I didn’t have MySQL 4.1 installed when I installed 5.0.x, it did not update my tables. The interesting note about that is that on Windows, the process to do this manually is not as easy as it should be. Here are the steps:

1. Stop the MySQL service (net stop mysql).
2. Move the binary files into the new /data/ directory.
3. Delete ib_logfile0 and ib_logfile1 if they exist.
4. Start the MySQL service (net start mysql).
5. mysqlcheck --check-upgrade --all-databases --auto-repair --user=root --password
6. mysql --database=mysql --user=root --password
7. mysql> source c:\mysql\scripts\mysql_fix_priviledge_tables.sql

And now you’re all done!