Mysqldump: Got Error: 29: File (Errcode: ) When Using LOCK TABLES



Mysqldump: Got Error: 29: File (Errcode: ) When Using LOCK TABLES
 (380) Click. Work. Collect
Mysqldump: Got Error: 29: File (Errcode: ) When Using LOCK TABLES
Post Description:
Post Tags: mysqldump, got, error, 29, file, errcode, when, using, lock, tables
This Post Has Been Viewed 1960 Times Since Thu Jul 20, 2006 9:20 am Posted By toyer with 1 replies
Mysqldump: Got Error: 29: File (Errcode: ) When Using LOCK TABLES
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     [ dejar commentarios ]
  * Name     [nombre]

  * eMail (will not be published)     [coreo electronico]

* Enter Your Reply or Comments:    [commentarios]


Add Picture To Comments         [incluir foto]
YES NO             upload
Receive Replies on my Comments (An email will be sent to you when someone replies to your comments)

     

Comments and replies About Mysqldump: Got Error: 29: File (Errcode: ) When Using LOCK TABLES




:: 1 :: #2 - Reply By toyer On Thu Jul 20, 2006 9:15 am
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