Mysql dump is basically a backup program which is used to dump a single database or its collection mainly for the purpose of backup so as to transfer the data to another mysql server whenever required. This program consists of such SQL statements that can be used to create or populate the table and leads to successful creation of backup. But at times, you might face errors like mysql error 29 while using mysql dump after which you are not allowed to create backup.

Let’s take this example in a practical scenario where you are using mysql dump but receive the following error message on screen:

[root@www diaendomet]# mysqldump -ucojjohealth -p --all-databases >
alldatabases.sql
Enter password:
mysqldump: Got error: 29: File '../diaendomet/users.MYD' not found
(Errcode: 2) when using LOCK TABLES

The above error message occurs in each and every attempt of mysqldump program running and thus you are unable to precede the backup process at all.

Cause:

When the mysql database gets corrupt due to reasons like improper system shutdown, virus attack or application malfunction, then you may face mysqldump error 29

Solution:

To get rid of the mysql_error 29, you need to execute the following command:

“mysqlcheck --all-databases --auto-repair -ucojjohealth -p”

This command automatically repairs your damaged mysql database, but sometimes you may face another error message after executing the above command which gives you an indication about the severe database corruption issues:

“error: File '../diaendomet/users.MYD' not found (Errcode: 2)”

In such situations, the best option is to opt for mysql repair tool which is capable to resolve entire corruption problems completely by making use of highly developed scanning techniques and ensures you complete repair and recovery of mysql database.