How To Solved Mysqldump: Got error: 1016: Can’t Open file when using LOCK Tables
Today, i trying to dump my database but when the dump process begin,
MySQL shows error like below :
Example :
root@rainforest# mysqldump -u root -p mypassword –opt sampledb > backupdb.sql
mysqldump: Got error: 1016: Can’t open file: ‘./sampledb/xxx.frm’ (errno: 24) when using LOCK TABLES
root@ami.web.id#
So after googling a way to dump it without any hassle
root@ami.web.id# mysqldump -u root -p mypassword –opt sampledb –lock-tables=fales > backupdb.sql
From the command above, i can dump my backupdb without any problem