service MailScanner stop
service mysqld stop
cd /var/lib/mysql/mailscanner
myisamchk --check *.MYI
myisamchk --recover maillog.MYI
service mysqld start
service MailScanner start
is there a new procedure for repairing corrupt tables?
When the DB wouldn't start for me (memory errors crashed the host), I did the following and apparently just looking at it read-only was enough to get it to start properly..... That matches up with things I'd seen elsewhere where people said just dumping the DB would resolve their issue.
create /etc/my.cnf.d/innodb_recovery.cnf (NOTE: This has the option commented out, uncomment for actual use)
Yeah, the recovery in eFa does not do this on purpose, it uses only a safe recovery, because this has potential to wreck havoc. Backing up before proceeding like this is a must.