Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
Out of resources for mysqldump

I'm trying to export all databases from my wamp installation (so I can do a reinstall), but I get this error when trying to generate a dump file:

C:\wamp\bin\mysql\mysql5.1.36\bin>mysqldump -u root --all-databases > dbs.sql mysqldump: Got error: 23: Out of resources when opening file '.\site\posts_rg_lea d_detail.MYD' (Errcode: 24) when using LOCK TABLES

the export stops after ~70 MB...

share|improve this question

marked as duplicate by Iain Mar 19 '12 at 12:29

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

up vote 3 down vote accepted

Error 24 is : "Too many open files"

try this (add --single-transation):

mysqldump -u root --all-databases --single-transaction > dbs.sql

share|improve this answer
tx that works :D – Alex Mar 19 '12 at 12:06

Not the answer you're looking for? Browse other questions tagged or ask your own question.