Solution to mysqldump error caused by too many files opened in MySQL database

MySQL databaseIf a fault occurs during useMysqldumpError:

1: run the mysqldump command to dump the entire database:

 
 


  
  
Mysqldump: Got error: 1105: File './db/data_20070901.myd' not found (Errcode: 24) when using LOCK TABLES

 
 

2: Check whether the files under/data/db are missing. Using the mysql client to connect to the desc and select * from table is normal. If you use the dump command to directly dump this table, no error will occur.

Perror 24 indicates that the error message is:

 
 


  
  
[Root @ localhost ~] # Perror 24

  
  
 

  
  
OS error code 24: Too enabled open files

 
 

Therefore, modify/etc/my. cnf and set open_files_limit to a greater limit, for example, 4096. Restart mysqld to solve the problem.

The mysqldump fault solution for MySQL databases is introduced here. If you want to know