MySQL Error during Backup

[Medienpirat]

Hi

i got an error during daily backups within plesk from one database table:

Not all the data was backed up into...mysqldump: Got error: 23: Out of resources when opening file...
(Errcode: 24) when using LOCK TABLES

Does anyone have a solution?

 

[IgorG]

Check this article http://kb.odin.com/en/124356

 

[Medienpirat]

I have add this but get the same message after next backup. Is there a way to add --single-transaction to mysqldump config?

 

[IgorG]

Check output of following command:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -e "SHOW VARIABLES LIKE 'Open_files_limit';"

And increase open files limit in /etc/my.cnf with adding entry like

open_files_limit = 8196

After that restart mysql service and check limit with first command again.

 

[Medienpirat]

It was 1024 before. I raised it with your suggestion and will report if the issue was gone after that.