Fix Error - mysqldump: Got error: 29: File (Errcode: ) when using LOCK TABLES This page contains information about Fix Error - mysqldump: Got error: 29: File (Errcode: ) when using LOCK TABLES Here you can also give your thought about the subject of Fix E
mysqldump: Got error: 29: File '/vbookie_news.MYD' not found (Errcode: 13) when using LOCK TABLES
The other day a customer complaint they could not backup their mysql databse. They complaint about getting an error and they wanted support from our admin.
At first I was lost, I had never heard of this error before. I went to the msyql website, but all I could find was to read the documentation, but never provide a solution on how to fix this problem. I searched the search engines but no one had a solution.
Well, I am glad to say that I was able to NOT get an error. These are my notes:
1. I wanted to backup a database with the following Linux Shell Command:
| mysqldump --opt -u webmaster -p my_database | gzip > backup_070606.sql.gz |
2. After I executed this command, I got a prompt to enter my password. After I entered the password, I got this error:
| mysqldump: Got error: 29: File './web1_db1/vbookie_news.MYD' not found (Errcode: 13) when using LOCK TABLES |
3. WHAT I DID TO FIX THIS - At first I thought it was a permissions issue. so I logged in as root, but I got the same errror, so I knew it wasn't a permissions problem. While I was taking this computer class serveral years ago, the teacher drilled this into our brains. "Power Cycle" That was a good advise, Power Cycling has saved me from alot of headaches and this MYSQL was no exception. After all, I have nothing to loose, but I did not want to reboot ther server, so what I did- I just rebooted mysql server. This particular customer had redhat/fedora server installed so I executed the following command at the shell prompt:
| /etc/init.d/mysqld restart |
4. After I executed the above command, I tried to backup the datase again with the following command:
| mysqldump --opt -u root -p my_database | gzip > backup_070606.sql.gz |
5. After I executed this command, I was prompted to enter my password, in this example, I entered my msyql root password then I hit return on my keyboard. After I entered return, The shell just sat there. It didn't show me any, Not even the shell, it appeared to be hang. But then I thought, its probably processing my command, so I patiently waited. I thought since this was a big database it was going to take hours... Finally at about 2 minutes later, I got my sell prompt again ($). I listed all the files and sure enought, there was a file called "backup_070606.sql.gz"
SUMMARY: rebooting mysql server did the trick for me. I think maybe there must have been a process that was hang and rebooting released that process. I dont know exactly since I am not an expert, but I am just glad it work. Hope this also works for you if you are also having the same problem. If it does help you. We would appreciate credit or a link back to www.wallpaperama.com
Thanks - Admin Team