Plesk cannot be updated: ERROR while trying to backup MySQL database

Created:

2016-11-16 12:52:34 UTC

Modified:

2017-05-24 04:44:43 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Plesk cannot be updated: ERROR while trying to backup MySQL database

Applicable to:

  • Plesk for Linux

Symptoms

Plesk upgrade or update fails with following message:

Trying to backup MySQL database...
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.0.9_installation.log), fix and try again

Upgrade log file /tmp/plesk_11.0.9_installation.log contains:

=== Preparing upgrade
chown: changing ownership of `/storage/mysql.preupgrade.11.0.9-11.0.9.20130616-153540.dump.gz': Operation not permitted

Cause

Incorrect value of DUMP_D variable in /etc/psa/psa.conf file.

Resolution

Check value of @@datadir variable in MySQL:

MariaDB [psa]> SELECT @@datadir;
+-----------------+
| @@datadir      |
+-----------------+
| /var/lib/mysql/ |
+-----------------+

and change DUMP_D variable in /etc/psa/psa.conf file accordingly.

Have more questions? Submit a request
Please sign in to leave a comment.