[mythtv-users] Rebuild then reimport recorded programs data

Robert Kulagowski bob at smalltime.com
Sat May 8 10:25:13 EDT 2004


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


More information about the mythtv-users mailing list