Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm currently on Windows 2003 using MySQL 5.0.54a and I'm moving to Linux which has MySQL 5.5.24.

Is this a simple exercise of using mysqldump to export the data from 5.0.54a and then import it into 5.5.24?

Or should I go through the upgrade steps, to bring in my data into a 5.1 instance before bringing it to 5.5.24?

share|improve this question
up vote 6 down vote accepted

Mysql says it's better to dump, then import into 5.1, then dump again, and finally import into 5.5.

share|improve this answer
I don't have 5.1 to upgrade to (and I don't think it was part of our plans either). If I was upgrading our current databases on Windows 2003, this would be the plan. However, as I mentionned, we're migrating to another standalone environment (in Linux) that already has 5.5 running. – TekiusFanatikus Jun 4 '12 at 17:19
I would not recommend doing an in place upgrade of Mysql. Simply spin up a Linux VM on which to install Mysql 5.1 for the import from 5.0 and to create a dump for your 5.5 server. – kashani Jun 4 '12 at 18:32

After restoring using the mysqldump method do remember to run the mysql_upgrade script to fix the privileges table.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.