mysqldump: Got error: XX: File ' XXX.MYD' not found (Errcode: 24) when using LOCK TABLES

1。先登录mysql查看当前的open_files_limit是多少：

   >show variables like '%open_files_limit%'  

    +------------------+-------+

    | Variable_name    | Value |

    +------------------+-------+

    | open_files_limit | 1024  | 

    +------------------+-------+

2.修改/etc/my.cnf

  添加open_files_limit=2048，并重启mysql:/etc/init.d/mysql restart

3.在mysqldump -uXXX -hXXX -pXXX database > XXX/XXX/XX.sql

ok，一切正常了

转载于:https://blog.51cto.com/samfeng/1126033