Backup fails mysqldump: Got error: 1016:

[Kees]

Hi

I am having trouble with backing up a wordpress multisite.. When backup is on i am getting this error:

Not all the data was backed up into /var/lib/psa/dumps/domains/<domain>/databases/<db_name> successfully. mysqldump: Got error: 1016: Can't open file: './<db_name>/<some_table>.frm' (errno: 24) when using LOCK TABLES

Why is this happening and how can I fix this? Any ideas?

thanks!

 

[IgorG]

Looks like InnoDB corruption. Try to fix it with help of KB article http://kb.odin.com/en/6586

 

[Kees]

I have not tried your solution yet, but am getting another error now. Please check below. Is this caused by the same?

Not all the data was backed up into /var/lib/psa/dumps/domains/<domain>/databases/<db_name> successfully. mysqldump: Got error: 23: Out of resources when opening file './<db_name>/<some_table>.MYD' (Errcode: 24) when using LOCK TABLES

I am not very good in all this command line stuff so if there's a simple solution please let me know ;-)

 

[IgorG]

Out of resources when opening file

Is this Plesk installed on VPS? In this case there may be lack of resources for these MySQL operations or something like this.
I can only recommend to create a request to support team to do in-depth investigation to find the reason and to fix it. Please create a ticket to support at https://www.odin.com/support/request/ .
You may have free support, please check what kind of Plesk license you use for available support options at http://kb.odin.com/en/121580 .
If there’s no free support in your case, you can order Plesk per-incident support at http://www.odin.com/support/buy-support/ Support team will contact you as soon as purchase is processed, and they will do the best to resolve it.
If it is found that your problem was caused by product bug w/o available solution or workaround from Parallels, then your purchase will be re-funded.