cpbackup errors

[Marty]

In my nightly backup emails, I am getting the following error when running an incremental backup:

Entering timeout safety mode
Grabbing mysql dbs............
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
/usr/bin/mysqldump: Can't get CREATE TABLE for table `ibf_posts` (Can't open file: 'ibf_posts.MYI'. (errno: 144))
Done
Grabbing mysql privs...Done

Anybody have any ideas why that error is occurring. The application that runs off that database is running fine, but I want to make sure I have a good backup.

 

[webignition]

Does this happen every time /scripts/cpbackup runs? Or is it just now and again?

As far as I remember, .MYI files are database indices. If the application is running fine, then there's possibly nothing drastically wrong with the database.

However, you might want to check that /var/lib/mysql/username_databasename/ibf_posts.MYI does exist. If it does, go into phpMyAdmin and see if it shows any errors when trying to read the table data.

 

[Marty]

It does it every time and I have no problem browsing it with phpMyAdmin. The application that uses that table has no problems. I am just concerned about the integrity of the backup.