24 = Too many open files. I think you can resolve this issue by increasing the number of file descriptors available to mysqld by setting an appropriately higher 'open-files-limit' in your configuration.
--bmansell Brian E. Mansell MySQL Professional On Thu, 22 Jul 2004 13:20:24 +0200, Wolfgang Riedel <[EMAIL PROTECTED]> wrote: > Hi, > > I want to save a database with 'mysqldump' and get the following error: > mysqldump: Got error: 1105: File '/var/lib/mysql/mydb/J99.MYD' not found > (Errcode: 24) when using LOCK TABLES > > But the file *does* exist: > > ls -l /var/lib/mysql/mydb/J99.MYD > -rw-r----- 1 mysql mysql 224 Feb 24 2002 > /var/lib/mysql/mydb/J99.MYD > > What's the reason for the error? > Is there a possibility, that the database is to large? It has about 1000 > tables, but the database altogether has an amount of 35 MB. > Could I tell mysqldump to access the database in portions? > > Regards, > Wolfgang > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]