MySQL Got error 24 Too many open files

On taking MySQL backup with mysqldump, i get following error

This is because open_files_limit limit in MySQL. To verify login to MySQL server and run

This will give you current value of open_files_limit.

To increase, edit /etc/my.cnf file, add

Add under [mysqld] section

Now restart MySQL server

Add a Comment

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