We have a server that does nightly backups to the secondary drive.
On about 8 accounts an error such as this occurs and we dont get the sql db in the backup.
Entering timeout safety mode
Grabbing mysql dbs............
.........
mysqldump: Got error: 1105: File './acctname/emaill 265.MYD' not found (Errcode: 24) when using LOCK TABLES
Done
the result is it just doen't dump the db at all. so i go in and delete the table which is ancient and not even used. then the next day i get an error like this:
Grabbing mysql dbs............
.........
mysqldump: Got error: 1105: File './acctname/emaill 264.MYD' not found (Errcode: 24) when using LOCK TABLES
Done
repairing the database does nothing at all and deletinng that 264 table just give me and error on the next table down (263)
what could the problem be?
On about 8 accounts an error such as this occurs and we dont get the sql db in the backup.
Entering timeout safety mode
Grabbing mysql dbs............
.........
mysqldump: Got error: 1105: File './acctname/emaill 265.MYD' not found (Errcode: 24) when using LOCK TABLES
Done
the result is it just doen't dump the db at all. so i go in and delete the table which is ancient and not even used. then the next day i get an error like this:
Grabbing mysql dbs............
.........
mysqldump: Got error: 1105: File './acctname/emaill 264.MYD' not found (Errcode: 24) when using LOCK TABLES
Done
repairing the database does nothing at all and deletinng that 264 table just give me and error on the next table down (263)
what could the problem be?