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

RegisterLogin

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

mysqldump: Got error: 29: File (Errcode: ) when using LOCK TABLES
Post Description: mysqldump: Got error: 29: File (Errcode: ) when using LOCK TABLES
Tags: mysqldump:, Got, error:, 29:, File, (Errcode:, ), when, using, LOCK, TABLES
This Post Was Posted On Feb 29, 2008 By toyer #1455

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

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

Code:

/etc/init.d/mysqld restart

Leave Your Comments

Related Pages: [Add Your Website]

Post New Topic

toyer

#1880 1

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

Jul 20, 2006 Reply Report abuse