I'm trying to do a mysqldump on a Windows server and I get the following error message :
mysqldump: Got error: 23: Out of resources when opening file '.\db\sometable.MYD' (Errcode: 24) when using LOCK TABLES
Here's the command I'm running :
mysqldump -u user -p"pass" --lock-tables --default-character-set=latin1 -e --quick databasename > "query.sql"
Restarting the mysql service didn't help.
I always get the message for the same table.
I've tried reducing the table_cache and max_connections variables from 64 to 32 and 30 to 10 respectively but I still get the error only this time for a different table (and from now on the error message is always mentionning the second table).
The same script is running on a dozen other Windows servers having the same database without problems.
All databases have 85 tables.