MySQLdump Got error: 29

3 June 2009 - 4:59am

mysql-logo

ใช้ Mysql Dump แล้วเจอ error ตามนี้mysqldump: Got error: 29: File './thaiavTmp/Shop_Ext.MYD' not found (Errcode: 24) when using LOCK TABLE
เค้าบอกว่าให้ไปเพิ่ม config open_files_limit to 8192
( ปกติมันจะ open_files_limit = 512) แค่นี้ก็หายแล้ว

Responses

Real (not verified) Says:
9 June 2009 - 10:09pm
Anonymous's picture
mysqldump: Got error: 29:

mysqldump: Got error: 29: File '/vbookie_news.MYD' not found (Errcode: 13) when using LOCK TABLES

The other day I complaint that could not backup my mysql databse. I complaint about getting an error and I wanted support from the hosting 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.

PangPond Says:
11 June 2009 - 1:57pm
PangPond's picture
@Real in this case You can

@Real in this case You can try to notice to hosting admin to edit mysql config (/etc/my.cnf)

from open_files_limit = 512 to open_files_limit = 8192