• Article for your preferred language does not exist. Below is international version of the article.

Article ID: 121164, created on Apr 18, 2014, last review on Feb 1, 2016

  • Applies to:
  • Plesk 12.5 for Linux
  • Plesk 12.0 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux

Symptoms

Migration or database export fails with the following error:

Failed to pack files backup_domain.tld_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)

Cause

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

Resolution

On the source server:

  1. Create database backups:

    # 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
    
  2. Complete the MySQL upgrade:

    # mysql_upgrade -uadmin -p` cat /etc/psa/.psa.shadow ` --debug-check --debug-info --verbose
    

    If it is not helped and you still get the error above, but mysql_upgrade show the following:

    This installation of MySQL is already upgraded to <MYSQL_VERSION>, use --force if you still need to run mysql_upgrade
    

    Run

    # mysql_upgrade -uadmin -p` cat /etc/psa/.psa.shadow ` --force
    

Please use the official MySQL guide for you reference.

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7 aea4cd7bfd353ad7a1341a257ad4724a 742559b1631652fadd74764ae8be475e 0efe2234e2ce513f2186f26c68447702

Email subscription for changes to this article
Save as PDF