Re: "ERROR 23: Out of resources when opening "

[david forstner]

have the same trouble....... also on win2k when trying to dump the databse.

hm....... are there any settings where i can asign mysl more resources?

here is the same topic.......

http://lists.mysql.com/win32/15363

-> mysql dump
mysqldump: Got error: 29: File './databasename/tablename.MYD' not found (Errcode: 24) when using LOCK TABLES

http://dev.mysql.com/doc/refman/5.1/de/not-enough-file-handles.html
shell> perror 23
Error code 23: File table overflow
shell> perror 24
Error code 24: Too many open files
shell> perror 11
Error code 11: Resource temporarily unavailable

There’s two ways to fix the problem. First, if you find that you only hit the limit during mysqldumps and never during normal database operation, just
add --single-transaction to your mysqldump command line options. This will cause mysql to keep only one table open at a time.



Edited 1 time(s). Last edit at 05/13/2009 10:17AM by david forstner.