Tag Archives: System notes

mysqldump: Got error: 1016: Can’t open file: ‘./xxx.frm’ (errno: 24) when using LOCK TABLES

mysqldump: Got error: 1016: Can’t open file: ‘./bdm0140379_db/lady_forumrecommend.frm’ (errno: 24) when using LOCK TABLES
Add an open_files_limit = 100000 to my.conf (etc/my.conf in my environment)
Service mysqld Restart.
Warning: Skipping the data of table mysql.event.specify the –events option explicitly.
Add –events –ignore-table=mysql.event
mysqldump -u root -pxxxxxxx –all-databases –events –ignore-table=mysql.event > /alidata/26.sql