MySQL Out of Resources Error

Checking my automated backup I realized that one of my database dump is empty. I chechked the database and it was ok. I tried a manual dump and I got this:

mysqldump: Couldn't execute 'Lock tables on `tablename`': Out of resources when opening file './databasename/tablename###.MYD' 

After some googling I found a solution. I have the following line to my.cnf

open_files_limit = 4096

then restarted MySQL everything was ok.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.