Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers

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
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

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.