MYSQL error when doing backup: (Errcode: 24) when using LOCK TABLES

[albatroz]

I am trying to backup a kind of huge database 8MB but every time I use

mysqldump -p --opt xxxxxxxxx


I get the following error:

mysqldump: Got error: 1105: File './admune_clarodb/c_142_pages.MYD' not found (Errcode: 24) when using LOCK TABLES


Any ideas?

 

[albatroz]

What would happen if zip the directory where the MySQL database files are located?

/var/lib/mysql/xxxxx

will that work?

 

[nobaloney]

Yes ...

but maybe no.

If you're going to/from the same OS distribution, and the same version of MySQL, absolutely.

But it's not supported.

And to do it that way you'd have to shut down MySQL for everyone long enough to back it all up.

Jeff

 

[speedyexe]

i have an idea that works for me and i created backup successfully

cd /var/lib/mysql/database_name

find your file (MYD) inside and check ls -al for chmod
propably (MYD file) not gonna have -rw-rw---- like others files inside

just make chmod 660 your_problematic_file.MYD

then /etc/init.d/mysql restart

after that in direct admin in user account make chceck then repair database in directadmin

after that make backup and it will be without errors
thats all folks!