Mysqldump: Got error: 1016: Can’t open file (errno: 24) when using LOCK TABLES

Ok so today I had to dump 700mb mysql database. I have tried using standard syntax:

mysqldump -uUSER -pPASS db_name > dump.sql

But I have got the following error:
Mysqldump: Got error: 1016: Can’t open file: ‘./db_name/xxx.frm’ (errno: 24) when using LOCK TABLES

I’ve searched a bit and I have found that solution was to add parameter –lock-tables=false so the final working mysqldump command was like this

mysqldump -uUSER -pPASS db_name --lock-tables=false > dump.sql

This post helped you out?
Why not buy me a coffee?

Amount

1x Geek Coffee $5.00 USD 2x Geek Coffees $10.00 USD 3x Geek Coffees $15.00 USD 4x Geek Coffees $20.00 USD Geek Coffee for a week $25.00 USD Geek Coffee for two weeks $50.00 USD Caffeine overdose (monthly dose) $100.00 USD

Your message for me

See who already bought me some coffee

Related Posts

• Laravel 5.4 migration: Specified key was too long error solution