Re: "ERROR 23: Out of resources when opening "
Posted by: david forstner
Date: May 13, 2009 10:12AM

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.......

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

Options: ReplyQuote

Written By
Re: "ERROR 23: Out of resources when opening "
May 13, 2009 10:12AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.