mysql :Got error: 1016: Can’t open file: … (errno: 24) when using LOCK TABLES

Sometimes, when you have got a large number of tables in your database and while taking the dump of that particular database, you would have encountered this strange error.

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

There are two solutions for this problem.

1) Set the following value to some higher number in your my.cnf file.

open-files-limit=20000

2) or, While taking the mysql dump, use –lock-tables=false option.

mysqldump –lock-tables=false -u root -p db-with-lots-of-tables  >  databasename.sql