Back ups not running

Back ups not running

by Robin Trangmar -
Number of replies: 2

Hi Folks

Much to my horror the back-ups are not running - logs show 'error' but not why. I've had a look at the database and there seems to be a problem with one file. This is the report:
>
Can't open file: 'mdl_cache_text.MYD'. (errno: 145)
Error
SQL-query :
SHOW KEYS FROM `mdl_cache_text`
MySQL said:
#1016 - Can't open file: 'mdl_cache_text.MYD'. (errno: 145)
>

I've had the systems people check the settings and I can at least now download the definitions but if I save as a zipped file, its empty.

However, running ../backups/try.php puts the backup files in the pathway I set in the backups page under the Admin settings

Be grateful for advice; the definitions report is attached

Average of ratings: -
In reply to Robin Trangmar

Re: Back ups not running

by Martín Langhoff -
You need to repair your database. Get your sysadmins to run myisamchk on all the database tables.
Average of ratings: -
In reply to Martín Langhoff

Re: Back ups not running

by Robin Trangmar -

Thanks Martin

Sysadmins ran myisamchk and resolved most of the problems - once they had done that I was able to compact and repair a few times and things are now back to normal. Thanks again for your help.

Average of ratings: -