mysqldump overflow?

2004-07-22 Thread Wolfgang Riedel
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 mysqlmysql 224 Feb

Re: mysqldump overflow?

2004-07-22 Thread Brian Mansell
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