BitMiner - free and simple next generation Bitcoin mining software




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