0

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

Community
  • 1
Alex
  • 55
  • 8

1 Answers1

3

Error 24 is : "Too many open files"

try this (add --single-transation):

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

moul
  • 575
  • 1
  • 4
  • 11