[mythtv-users] how do I list previously recorded shows?

[Michael T. Dean]

On 09/04/2009 01:16 AM, Michael T. Dean wrote:
> Do a full backup of your broken database ( 
> http://www.mythtv.org/wiki/Database_Backup_and_Restore ), then drop 
> the database and then run mc.sql ( 
> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Database_Restore 
> ), then start mythtv-setup and exit and do a partial restore of the 
> database ( 
> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup 
> ).  Then, erase all your broken oldrecorded.programid values:
>
> mysql -umythtv -p mythconverg -e "UPDATE oldrecorded "\
> "SET programid = '' WHERE REGEXP('..[[:digit:]]{1,13}');"

Just realized I didn't copy correctly from my test run...

mysql -umythtv -p mythconverg -e "UPDATE oldrecorded "\
"SET programid = '' WHERE programid REGEXP('..[[:digit:]]{1,13}');"

Mike