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

[DanijelD]

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?

 

[IgorG]

Look at this KB article - http://kb.odin.com/en/118644

 

[DanijelD]

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.

 

[DanijelD]

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?

 

[DanijelD]

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?