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 to avoid this error
1. Set the following value to some higher number in your mysql database
2. or, While taking the mysql dump, use –lock-tables=false option.
mysqldump --lock-tables=false -u root -p db-with-lots-of-tables > db.sql