[mythtv-users] MySQL borked

Gary Buhrmaster gary.buhrmaster at gmail.com
Sat May 25 00:03:59 UTC 2013


On Fri, May 24, 2013 at 11:37 PM, Phill Edwards <philledwards at gmail.com> wrote:
> Sorry for the long post here...

First, taking the thunder from Mike, this is one more reason for
people to regularly (daily) run the database backup script and
store the files in a "safe" place (not on the disk which contains
the mysql database).  Databases crash.  Systems fail.  Power
goes out.  UPS's are not.

Now that that is out of the way....

I do not suppose you tried the various forced recovery options
which are designed to (try to) recover from broken recovery
files before trashing the mysql install?  Some of them enable
one to simply ignore the transaction logs, so the database
may not be 100% consistent, but it likely can be started up.
What did the logs show for those attempts?

As an aside, have you disabled barriers on your filesystem
(which can assist in the creation of the most interesting
failures especially when power outages hit).

Gary


More information about the mythtv-users mailing list