[mythtv-users] restore borked db

[cythraul]

This demonstrates again the need for some kind of easy-to-use backup
and recovery tool for myth.

To answer your question, the "record" and "recorded" tables are what you want.

Of course, it depends on how proficient with sql but it's fearly easy.

PLEASE backup your db before doing anything, I might be wrong, flat
wrong or completely thick headed. Also, the tables you're restoring
might contain corrupted data which would segfault your backend. :)

I assume you will be starting from the point were your restarted your DB...

grep "INSERT INTO record" [your db backup file] > record.sql
grep "INSERT INTO recorded" [your db backup file] > recorded.sql
cat record.sql | mysql -u mythtv -pmythtv mythconverg
cat recorded.sql | mysql -u mythtv -pmythtv mythconverg

This should do the trick

You could also retrieve the "oldrecorded" table containing your
previously recorded programs.

cyth

On Thu, 10 Mar 2005 17:35:07 -0700, pmb <junk at umich2.com> wrote:
> Something in mythconverg was causing the frontend to seg fault while
> connecting to the backend. I backed up the bad db and installed a fresh
> one. What is the easiest way to pull info out of the bad db to insert
> into the good one? The only parts I really would like to retrieve are
> the listings for the recorded shows and my recording schedule. I'm
> running 0.17 from atrpms.