3/22 To make a long story short... I have NO idea why one of the tables
got corrupted (mysql said "This is marked as 'crash', please repair
this table"). I've run REPAIR TABLE <tables> and now Berkeley MOTD
is working again. Thanks for the quick notification. FYI I've run
Berkeley MOTD for a while and this is the first time something like
this has happened. If you know why and how to fix it please email
me. Thanks guys -kchang
\_ Just curious, why do you bother or care?
\_ someone important asked me to do it.
\_ i'll repair YOUR table
\_ Are you using MyISAM (default) or InnoDB tables? MyISAM tables can
and do corrupt if you hit mysql hard enough. In theory, InnoDB
tables should be immune from this. Obviously switching to a
different RDBMS is not a decision to take lightly, but, as a worst
case scenario, consider switching to postgres, which is definitely
more robust than mysql. -dans |