corrupt swauditlogs table - what do I do?

[pdc_irl]

Hi,

I run a backup script, as part of a cronjob, to take a dump of the swift database nightly. Esentially it runs the following command;

mysqldump --opt -u root --password="password" swift >/backups/swift$date.sql

In the last day I've noticed that the backups had been not working right, it turns out there's a problem with the swauditlogs table, it's corrupted.
I've tried

myisamchk -c swauditlogs.MYI

which didn't work so then tried

myisamchk -r swauditlogs.MYI

which is returning;

- recovering (with sort) MyISAM-table 'swauditlogs.MYI'
Data records: 38753
- Fixing index 1
- Fixing index 2
myisamchk: Error writing file '/usr/local/mysql-standard-4.1.14-pc-linux-gnu-i686/data/swift/swauditlogs.MYI' (Errcode: 5)
myisamchk: error: 5 when fixing table
MyISAM-table 'swauditlogs.MYI' is not fixed because of errors

Can anyone advise what to do in order to correct this? Is is possible to just drop & recreate the table ?

Any assistance would be gratefully appreciated
Paul D
(currently using ver 3.0.0.13 of esupport, looking to update to the latest build as soon as I have the DB issue sorted)

[Jamie Edwards]

Hi pdc_irl,

I would suggest you contact support to seek the assistance of a Services staff or Developer in this case - however, from the sounds of it it sounds as if your support period has expired?

[pdc_irl]

Hi Jamie,
I'll get in touch with support on the problem. Maintenance & support is up to date, as I've only recently updated it.
(I'd been waiting for a period for the builds to settle down, at the time I installed 0.13, there was a high frequency on the esupport revisions, I eventually got dragged away with other jobs and only recently remembered that it needed updating)


Rgds
PaulD