Plesk upgrade fails: ERROR while trying to backup MySQL database

Created:

2016-12-18 07:23:56 UTC

Modified:

2017-08-08 13:44:37 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk upgrade fails: ERROR while trying to backup MySQL database

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

  • Plesk upgrade fails.

  • Errors in /var/log/plesk/install/plesk_xx.x.xx_installation.log :

    ERROR while trying to backup MySQL database
  • Maximum MySQL package size is limited in /etc/my.cnf/ :

    [mysqldump]
    max_allowed_packet = 16M

Cause

PSA database size is more than max_allowed_packet value.

Resolution

  1. Comment mentioned settings in /etc/my.cnf/ :

    #[mysqldump]
    #max_allowed_packet = 16M
  2. Restart MySQL service and make sure it is started successfully:

    # service mysqld restart
    # service mysqld status
Have more questions? Submit a request
Please sign in to leave a comment.