• The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Backup fails: "Failed to execute backup of mysql database"

DanijelD

Basic Pleskian
Hi,

My OS is CentOS 5.8.
Plesk is 11.0.9.

Having problems with failed daily domain backups. All databases that have been created by Plesk cannot be backed up, thus backup fails with the following message:

<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="error" log-location="/usr/local/psa/PMM/sessions/2015-02-19-044701.875/migration.result">
<object name="domain.com" type="domain">
<object name="admin_wp" type="mysql">
<message id="d11a87ee-c9b2-4b91-8104-96136f842ca9" severity="error" code="msgtext">
<description>Failed to execute backup of mysql database &#39;admin_wp&#39;</description>
</message>
<message id="b48ab60d-159d-4cc5-8600-7e02b325acb5" severity="error" code="msgtext">
<description>Failed to pack files domain.com_daily_admin_wp_1_1502190447 in /var/lib/psa/dumps/domains/domain.com/databases/admin_wp_1 [ 224051896320 bytes free of 241180323840 bytes total on mount point 0]</description>
</message>
</object>
<object name="domain_web" type="mysql">
<message id="f064effe-abed-4da4-8237-6e771d8620c0" severity="error" code="msgtext">
<description>Failed to execute backup of mysql database &#39;domain_web&#39;</description>
</message>
<message id="b108fcc3-3f18-4daf-8587-fd527f672443" severity="error" code="msgtext">
<description>Failed to pack files domain.com_daily_domain_web_1_1502190447 in /var/lib/psa/dumps/domains/domain.com/databases/domain_web_1 [ 224051896320 bytes free of 241180323840 bytes total on mount point 0]</description>
</message>
</object>
</object>
</execution-result>

What could be the reason?
 
Thanks Igor.
That articele is talking about something that is not related to my problem. Or did I not understand correctly? I mean, for me the problem is "failed to execute backup of mysql database", and this artilce is about no space in /tmp folder and failing FTP upload. I checked it and my disc is only 7% full and upload works OK.
 
I am still getting "Failed to execute backup of mysql database". This happens only for one out of my 3 domains.

Seems like Plesk doesn't know the password, maybe the passwords are different for Plesk and MySQL? How can I change the password for MySQL? For which user?
 
Some more info from the migration.results file:
"Failed to pack files mydomain.com_daily_admin_wp_1_1503091102 in /var/lib/psa/dumps/domains/mydomain.com/databases/admin_wp_1"

Does that help?
 
Back
Top