Mysql Table Repair

Support
1

NethServer Version: 6.6
Module: Backup

I had some days of backup failure, with the message: ‘Event pre-backup-data failed’.
I found where to look to know which problem affected the backup and I found in |var\log\messages this error:

Dec 11 19:00:04 mail esmith::event[9167]: mysqldump: Couldn’t execute 'show create table audit': Table ‘./smbaudit/audit’ is marked as crashed and should be repaired (145) Dec 11 19:00:04 mail esmith::event[9167]: Action: /etc/e-smith/events/pre-backup-data/S50mysql-dump-tables FAILED: 1 [0.785301]

But now I don’t know how to repair the audit table in Mysql. Anyone know how to do it?
Thank you very much, and sorry for my bad English

2

One way could be:

mysqlcheck -r smbaudit audit
3 Likes
3

It worked! Everything is fine.
Thank you very much!!