[mythtv-users] DB restore

[Bill Meek]

On 02/02/2015 10:50 PM, Daryl McDonald wrote:
> There was definitely something corrupting my database, what got me going
> again was restoring a database from a few months ago, now I have
> mega-multiple orphans to deal with. The question now is will any of the
> testing you've suggested be of any value, with the old database in place?
> Thanks Bill, Daryl
>

Value, probably. Needed, not now. My next response would *probably* have included the
Wiki and steps for restoring the DB, which it sounds like you've done.

I was trying to verify that a DB restore was all that was required, rather
than the rsync that you had considered.

Knowing your passwords and being able to run mysqlanalyze is probably a
good thing to know now so if you have future problems, you can get a
feel for what's wrong.

Doing more frequent DB backups is probably a good idea. I thought that
Mythbuntu had a cron job that did it for you. I choose to backup weekly,
and /etc/cron.weekly/mythtv-database does the heavy lifting for me. I
changed the script to also check the size of the backup and email the
results to my BE user. That way if the backup runs, but has an unusual
file size, I'll know to see if the backup is correct or some thing's
wrong.

I'd still look at the mysql error logs to see if there are any clues about
why this happened.

-- 
Bill