[mythtv-users] 0.21 and database corruption/how to rebuild and update from backup

Bruce Markey bjm at lvcm.com
Mon Mar 17 22:40:21 UTC 2008


Robin Gilks wrote:
...
> That must rate as one of the best replies I've ever seen on -users.

Thanks, now here are my mistakes:

- The uncompressed example should not have had the ".gz" suffix.

- I should have shown "select count(*) from channel;" after
the "truncate channel;" to show that there were now "0" rows.

- I didn't mention cleaning up the mess in 'program' and friends:

mysql> truncate program;
mysql>quit
Bye
: bjm at moktoo ;mythfilldatabase

--  bjm




More information about the mythtv-users mailing list