Backup error on Database
In daily backup process i have this error . need help to fix please, thanks
confpe_db[2017-10-04 02:02:36 +0200] confpe_db: mysqldump: Got error: 29: File './confpe_db/ifq_wfHits.MYD' not found (Errcode: 2) when using LOCK TABLES
slccgila_bruzzo[2017-10-04 02:54:58 +0200] slccgila_bruzzo: mysqldump: Got error: 29: File './slccgila_bruzzo/wp_visitor_maps_wo.MYD' not found (Errcode: 2) when using LOCK TABLES
-
Hello, Please check open_files_limit and even though you are getting the errors but database backup will be fine. You can verify it. It seems that your database is big in size. If you want to run mysqldump use --skip-lock-tables option. 0 -
Hello, You may also find this thread helpful: SOLVED - Problem with backup process Thank you. 0
Please sign in to leave a comment.
Comments
2 comments