mysqldump: Got error: 23

I was getting this error when dumping a large MySQL database:

mysqldump: Got error: 23: Out of resources when opening file ‘./customTrash/t1_128_ed0_1a01e0.MYD’ (Errcode: 24) when using LOCK TABLES

Solution: add –single-transaction to the mysqldump command.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s