[mythtv-users] Rebuild then reimport recorded programs data

[Bruce Markey]

Robert Kulagowski wrote:
>> grep "INSERT INTO record "   mythtv_backup.sql > restore.sql
>> grep "INSERT INTO recorded " mythtv_backup.sql >> restore.sql
>> grep "INSERT INTO oldrecorded " mythtv_backup.sql >> restore.sql
>> grep "INSERT INTO recordedmarkup " mythtv_backup.sql >> restore.sql
> 
> 
> You can start with ">>" on the first one, just to keep it simple.

Good 'nuff unless you start over or already have a restore file as
I usually do =).

>> If something goes terribly wrong you can:
>>
>> $ mysql -u mythtv -pmythtv mythconverg
>> mysql> delete from record
>> mysql> delete from recorded
>> mysql> delete from oldrecorded
>> mysql> delete from recordedmarkup
> 
> 
> Don't forget the semicolon at the end of each of the commands above.

D'oh!

--  bjm