MySQL Backup

Upgrading MySQL databases after a software update (and possibly repairing structure and tables if problems occurs)

 

Sometimes MySQL changes its internal database structures between versions. When that is the case, you might get these kind of errors after updating it (probably via yum) and trying to start it:
[ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
...
[ERROR] Native table 'sometable'.'something' has the wrong structure

 

Additionally, trying to perform certain operations on the databases (like dumps) may throw out this error:
Cannot load from mysql.proc. The table is probably corrupted

The solution is rather simple and involves running the mysql_upgrade program:

# mysql_upgrade -u root -p

and enter your root password at the next prompt. If all goes well, the errors should go away.

If something failes, try running it one more time with

# mysql_upgrade -u root -p --force

 

If you still having problem with other tables, no matter what (InnoDB or MyISAM) you can refer here to repair MyISAM table or InnoDB.

 

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.