Backup/migration is completed with warning: Cannot load from mysql.proc. The table is probably corrupted (1548)

Refers to:

  • Plesk 12.5 for Linux
  • Plesk Onyx for Linux
  • Plesk 12.0 for Linux
  • Plesk 10.x and below for Linux

Created:

2016-11-16 12:43:15 UTC

Modified:

2017-01-22 10:44:35 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Backup/migration is completed with warning: Cannot load from mysql.proc. The table is probably corrupted (1548)

Symptoms

Backup is completed with warning:

Warning: mysql "Database"

Not all the data was backed up into /var/lib/psa/dumps/..../databases/Database successfully. mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'Database'': Cannot load from mysql.proc. The table is probably corrupted (1548)

OR Migration completed with warning:

[Migration] Failed to copy content of database 'DB_NAME'
Migration tools tried to perform operation in 3 attempts: Command execution failed on the source server 'source' (203.0.113.2) with non-zero exit code.
command: MYSQL_PWD="$(cat)" mysqldump -h localhost -P 3306 -uadmin --quick --quote-names --add-drop-table --default-character-set=utf8 --set-charset --routines hardcore > /tmp/db-dumps/DB_NAME.sql
exit code: 2
stdout:
stderr: mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'DB_NAME'': Cannot load from mysql.proc. The table is probably corrupted (1548)

Cause

The mysql.proc table is broken or the structure of a column in the table is incorrect.

Resolution

Repair mysql.proc table:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow`  mysql -uadmin mysql -Ne"REPAIR TABLE mysql.proc"
+------------+--------+--------+------+
| mysql.proc | repair | status | OK |
+------------+--------+--------+------+

If the previous solution did not help:

  1. Create a backup of MySQL database:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin mysql > /root/mysql_dump.sql
  2. Upgrade the database:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` /usr/bin/mysql_upgrade -f -uadmin
Have more questions? Submit a request
Please sign in to leave a comment.