Fix mysqldump issue after MySQL/MariaDB upgrade

After I’ve upgraded my MariaDB (MySQL should behave the same) server from version 5.1 to 5.5, my next database backup went wrong (see message below)

This post simply explain how to fix it

As mentioned in the documentation, when you upgrade your database server, you have to upgrade the schema of all your databases too.
The command which do the job is

mysql_upgrade examines all tables in all databases for incompatibilities with the current version of MySQL Server. mysql_upgrade also upgrades the system tables so that you can take advantage of new privileges or capabilities that might have been added.

First of all, we need to check which database/table needs to be upgraded

If you get an access denied, provide username and password

Then restart your MySQL/MariaDB server asa mentioned in the documentation

After running mysql_upgrade, stop the server and restart it so that any changes made to the system tables take effect.

Then I’ve run my backup script
Sources
MySQL documentation (mysql_upgrade)
http://mattiasgeniar.be/ blog post

Leave a Reply

Your email address will not be published. Required fields are marked *



Back to Top