mysqldump error

[sjau]

Hiya

I'm using this command for dumping my databases:

mysqldump -uroot -p********** -Q -c --add-drop-table --add-locks --quick --lock-tables --all-databases > /mysql_backup/backup.sql

It worked in the afternoon but not anymore tonight.

I receive this error message:

mysqldump: Got error: 1105: File './usr_web4_12/1140101384616.MYD' not found (Errcode: 24) when using LOCK TABLES

[falko]

Never seen this error before. Did you delete files or directories on the shell?

[sjau]

I found out that the error is wrong... there's some bug. In reality it means mysql wanted to open too many files and I needed to change my my.cnf to:

[mysqld_safe]
open-files-limit=8192

Furthermore I did also change my routine on how I create the dumps. I don't make a big .sql file anymore containing all data but split it up and create for each db an own .sql file:

#Dump new files
USER=root
PASSWORD=***
HOST=localhost

for i in $(echo 'SHOW DATABASES;' | mysql -u$USER -p$PASSWORD -h$HOST|grep -v '$
mysqldump \
-u$USER -p$PASSWORD -h$HOST \
-Q -c -C --add-drop-table --add-locks --quick --lock-tables \
$i > /mysql_backup/$i.sql;
done;