Migration fails with "Failed to pack files", "Cannot load from mysql.proc"

[sajugovind]

Migration fails with the following error:

Code: [Select]

Failed to pack files backup_schnell_1_1309020900 in /var/cache/20130902085729642/...

mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'db_name'': Cannot load from mysql.proc. The table is probably corrupted (1548)

There is an incomplete upgrade of MySQL on the source server. The databases still has an old version.

To fix the issue,

On the source server:

Create database backups:

Code: [Select]

# mkdir /root/__sqlbackups
# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > /root/__sqlbackups/psa.`date +%F_%H.%M`.sql
# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` mysql> /root/__sqlbackups/mysql.`date +%F_%H.%M`.sql
# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` --all-databases > /root/__sqlbackups/all.`date +%F_%H.%M`.sql
Complete the MySQL upgrade:

Code: [Select]

# mysql_upgrade -uadmin -p` cat /etc/psa/.psa.shadow `
Thank you,