BACKWPUP plugin warning-cannot-load-from-mysqlproc-the-table-is-probably-corrupt

BACKWPUP plugin warning-cannot-load-from-mysqlproc-the-table-is-probably-corrupt

WAARSCHUWING: Databasefout Cannot load from mysql.proc.

How serious is this warning?What can be done to fix it?

This is due to schema changes required by different MySQL server versions.An easy way to fix this is to run the mysql_upgrade command from the command line.

About mysql_upgrade

mysql_upgrade checks all tables in all databases for incompatibility with the current version of MySQL server. mysql_upgrade also upgrades system tables so that new privileges or features that may have been added can be utilized.

mysql_upgrade should be executed every time MySQL is upgraded.It replaces the older mysql_fix_privilege_tables script, which should no longer be used.

mysql_upgrade executes the following commands to check and repair tables and upgrade system tables:

mysqlcheck --all-databases --check-upgrade --auto-repair

mysql fix_priv_tables

Run mysql_upgrade from the command line

To use mysql_upgrade, make sure the MySQL server is running, then invoke mysql_upgrade from the command line tool:

mysql_upgrade -uroot -p --force

You should then be prompted for a password for MySQL root, and mysql_upgrade will check all databases and tables and repair them where appropriate.

You may need to specify the full path to the above command if it is not in the shell's search path.

On Debian 6, it should be in:

/usr/bin/mysql_upgrade -uroot -p --force

On MAMP for Mac, the default path is:

/Applications/MAMP/Library/bin/mysql_upgrade -uroot -p --force

On Windows, MySQL will be installed and included in the bin subdirectory.By default it should be located at:

"C:\Program Files\MySQL\MySQL Server\[*CHANGE TO MySQL SERVER*]\bin\mysqladmin" -u root shutdown

Completed!

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

All checked and repaired tables are marked with the current MySQL version number.This ensures that the next time mysql_upgrade is run on the same version of the server, it can tell if the table needs to be checked or repaired again.