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 <[EMAIL PROTECTED]> 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.
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
