[mythtv-users] Rebuild then reimport recorded programs data

[Robert Kulagowski]

> 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.

> 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.