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
Can't download new apps to your phone because there isn't enough storage space? Lack of…
This issue started to appear on macOS 13 Ventura after recent Dropbox update. I would…
Since this morning (Feb 5th 2020) search just stopped working on my Windows 10 (version…
Many of you have run into a problem when you were working on some old…
After 10 years of running my main desktop computer on Windows 7 - time has…
I installed VestaCP for a clien on a new dedicated server running CentOS 7. Once…
View Comments
Thanks exactly what I needed