In the last episode (Sep 23), Shafi AHMED said: > I have a mysql database of 200G size and the backup fails due to the foll. > Issue. > > mysqldump: Got error: 1017: Can't find file: > './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES > > Can someone assist pls.?
$ perror 24 OS error code 24: Too many open files You need to bump up the max files limit in your OS. It may be defaulting to a small number like 1024. If you can't change that limit, edit your my.cnf and lower the table_open_cache number. You'll lose performance though, since mysql will have to stop accessing some tables to open others. http://dev.mysql.com/doc/refman/5.5/en/not-enough-file-handles.html -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org