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
Your message for me
Tags: 9MJ5, https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1822 DwWmJ_gKGKEzH7Ap_WLvGxhNV1wQxZmgpKioT83k8uSn-ETbl9gXB7w-mbdPiszU 3d6d9713072c417cbc916d20e97b41497ddb4bb7&uuid=&state=_BLhILn4SxNIvvL0W45KSic66uCIg23qh8iRG98qeIXme, https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1827 d0fkJLGmfguYSCknFI8HMkEifYg-7goVB-EDsp2_jPBP_Ep5J3DzjmGIMiK8xbjI 34cb201397f4bf957038c3806e25a12e78a6af9d&uuid=&state=_BLhILn4SxNIvvL0W45KSic66uCIg23qh8iRG98qeIXme
How to change proftp FTP password from SSH shell
How to whitelist your IP at CPHulk

Comments

  1. Thanks exactly what I needed

Leave a Reply

Your email address will not be published / Required fields are marked *