After upgrading my servers from MySQL 5.5.x to MySQL 5.6.13, on one of my servers with many databases, I am not able to use "Admin Backup/Transfer" to backup/dump all databases anymore.
After dumping around 30% of the databases, it stops with with errors like this:
I have tried to increase open_files_limit from 2046 to be 4096 in my.cnf, like this:
But it did not help. I did not have this problem in MySQL 5.5.x. Does anybody knows what I can do?
After dumping around 30% of the databases, it stops with with errors like this:
Code:
Error while backing up database USER_NAME
mysqldump error output: mysqldump: Error: 'Out of resources when opening file '/tmp/#sql_390d_2.MYD' (Errcode: 24 - Too many open files)' when trying to dump tablespaces
mysqldump: Couldn't execute 'show fields from `NAME_accesslog`': Out of resources when opening file '/tmp/#sql_390d_0.MYD' (Errcode: 24 - Too many open files) (23)
I have tried to increase open_files_limit from 2046 to be 4096 in my.cnf, like this:
Code:
open_files_limit=4096
But it did not help. I did not have this problem in MySQL 5.5.x. Does anybody knows what I can do?