During dump the database for backups this morning, I face some LOCK TABLES annoying problem. Dealt with this before but nothing came up from memory.
{code}[root@www tempbup]# mysqldump -uroot -p axioo9 > axioo9.sql
Enter password:
mysqldump: Got error: 29: File ‘./axioo9/traveler_comprofiler_lists.MYD’ not found (Errcode: 24) when using LOCK TABLES
{/code}
At first I thought this was cause by table being use or permission problem, but stoping all services and chown the mysql folder doesn’t change anything. So I come up by investigating myql bible for half an hour or so, and the solution is pretty easy :
{code}[root@www tempbup]# mysqldump –skip-lock-tables -uroot -p axioo9 > axioo9.sql
Enter password:
[root@www tempbup]#{/code}
Checked with mysqlcheck and importing for real production server the dump result was good. Need to document this somewhere before I forgot and have to read that bible again …
