[mySQL] mysqldump: Got error: 29: File ‘…’ not found (Errcode: 22) when using LOCK TABLES
Posted by skoch on 13. Juli 2010When using mysqldump (on windows) to dump databases with large amount of tables (>2048), you will get the error:
mysqldump: Got error: 29: File '...' not found (Errcode: 22) when using LOCK TABLES
As you are on Windows, 2048 open files is a (known) limitation of current versions on that platfrom.
My Solution (Workaround)
I moved the files from database folder to several new database folders (each with less than 2048 files), created my dumps and moved the files back to the former database folder again.
Leave a Reply
You must be logged in to post a comment.