Month: January 2014

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…

Continue reading…