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

This Page Contains information about Mysqldump: Got Error: 29: File (Errcode: ) When Using LOCK TABLES By toyer in category MySQL with 1 Replies. [852], Last Updated: Tue Feb 07, 2023

toyer

Thu Jul 20, 2006

1 Comments

3301 Visits

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

CODE:

/etc/init.d/mysqld restart

toyer

Thu Jul 20, 2006

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

https://www.wallpaperama.com/forums/mysqldump-got-error-29-file-errcode-when-using-lock-tables-t20.html

Linux Shell Command - Mysqldump --opt -u Username -p

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

Related Pages