mysqldump: Got error: 29: File (Errcode: ) when using LOCK TABLES

Forums » Mysql »» mysqldump: Got error: 29: File (Errcode: ) when using LOCK TABLES

Fri Feb 29, 2008 12:01 pm - mysqldump: Got error: 29: File (Errcode: ) when using LOCK TABLES

#1455

You need to start your MYSQL Server.
This is a commnad that works for Redhat Distributions like Fedora:

Code:

/etc/init.d/mysqld restart

author: toyer

Share this post by copy and paste this URL and put it on your forums or use it on your profile like myspace, friendster, Facebook, Twitter or others and add in with your comments.

Use this HTML code to embed this topic, just copy the code from the "Embed" box. Once you've copied the code, just paste it into your website or blog to embed it.

BBCODE is use on forums. You can put this code on all your BBCODE enabled forums like PhpBB, vBulletin® and others. Just Copy and Paste this code on with Posts and Replies on your forums

Thu Jul 20, 2006 9:15 am - Re: mysqldump: Got error: 29: File (Errcode: ) when using LOCK TABLES

#1880

toyer

I am getting this error:

Code:

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.

1. I wanted to backup a database with the following Linux Shell Command:

Code:

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:

Code:

mysqldump: Got error: 29: File './web1_db1/vbookie_news.MYD' not found (Errcode: 13) when using LOCK TABLES

Php Mysql Test Script

mysqldump: Got error: 29: File (Errcode: ) when using LOCK TABLES

Fix Warning: mysql_connect() [function.mysql-connect]: Too many connections

How To Fix Cannot Load mysql extension. Please check your PHP Configuration