How to solve “Out of resources when opening file”

When you got “23: Out of resources when opening file” or “1016: Can’t open file” from Directadmin backup output or mysqldump output, it is all about open-file-limit

what you need to do is increase the open-file-limit and set it into /etc/my.cnf
open_files_limit=14096
then restart the mysql service
/etc/init.d/mysqld restart

Leave a Reply

 

This site uses Akismet to reduce spam. Learn how your comment data is processed.