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

[Peter Bowyer]

On 17/03/2008, Bruce Markey <bjm at lvcm.com> wrote:
>
> The backup I'm using is a gzipped file bigboy.sql.gz . I use
> zcat to pipe the ascii through grep:
>
> : bjm at moktoo ; zcat bigboy.sql.gz | grep 'INSERT INTO `channel`' > foo
>
> If your file isn't compressed you can just:
>
> : bjm at moktoo ; grep 'INSERT INTO `channel`' bigboy.sql.gz > foo

zgrep does the magic for you uncompresses the file if it's compressed.....

(gilding the lily of your excellent advice for the OP)

Peter

-- 
Peter Bowyer
Email: peter at bowyer.org