I was reading this document: http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html

It says when upgrading from mysql 5.1 to do a mysqldump and then a reload. Is there anyway around this?

  • 1
    Skipping a major version is not supported. It might work. The backups are to be made ​​in any case, even if you don't plan to upgrade. There are too many things that can go wrong. Here a recent blog post of mysql employee about upgrade tocker.ca/2015/03/12/…
    – Giovanni
    Commented Mar 25, 2015 at 22:23
  • Thanks for the article. It sounds like going from one major version to the next is supported. Follow up: if I create a dump file from 5.1 and then test in 5.6; and it works; is this safe to do? Commented Mar 25, 2015 at 22:38
  • That's not quite the same. Can you load the dump into a 5.1 on another system, then upgrade to 5.6 on there?
    – Rick James
    Commented Mar 25, 2015 at 23:43
  • In any case, be sure to run mysql_upgrade.
    – Rick James
    Commented Mar 25, 2015 at 23:44

1 Answer 1


I have addressed something like this already

Leaping two versions is risky if you do not want to run mysql_upgrade twice. My Oct 17, 2014 post mentions running mysql_upgrade twice, the right way.

In your case, you should do this:

SQL="set group_concat_max_len = 1048576;"
SQL="${SQL} select group_concat(schema_name) from information_schema.schemata"
SQL="${SQL} where schema_name not in"
SQL="${SQL} ('information_schema','mysql','performance_schema')"
DBLIST=`mysql -ANe"${SQL}" | sed 's/,/ /g'`
mysqldump --databases ${DBLIST} > MySQLData.sql
SQL="${SQL} QUOTE(user),'@',QUOTE(host),';') "
SQL="${SQL} FROM mysql.user WHERE user<>''"
mysql ${MYSQL_CONN} -ANe"${SQL}" > GetGrants.sql
echo "SET sql_log_bin = 0;" > MySQLGrants.sql
mysql ${MYSQL_CONN} -AN < GetGrants.sql | sed 's/$/;/g' >> MySQLGrants.sql
rm -f GetGrants.sql

Now just load MySQLGrants.sql and MySQLData.sql into the MySQL 5.6 instance.


  • Can you point me to a document from mysql team that says you can do a dump from 5.1 --> 5.6x and not have issues? A lot of the upgrade docs don't talk about versions that are this far apart. Commented Apr 30, 2015 at 19:06
  • If I knew where such documentation were, I would not have written all these posts. Commented Apr 30, 2015 at 20:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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