[mythtv-users] I am an idiot - deleted everything without DB backup - a question...

[Jay R. Ashworth]

On Sat, Sep 08, 2007 at 11:19:37AM -0400, John Drescher wrote:
> I make a backup my mythtv database every night with a cron job:
> 
> # cat /etc/cron.daily/mythtv.cron
> #! /bin/sh
> mkdir -p /var/backup/mythtv
> /usr/bin/mysqldump -u mythtv mythconverg | /bin/bzip2 -c >
> /var/backup/mythtv/mythtv-`date +%F`.bz2

That's roughly akin to what I put in my mythbak command script, but 

Tip! Tip! Tip!  (:-)

I put it in a script, and called the script from cron, so that I could
handily use it manually when necessary, as well.  I handled name
collisions as well, though I don't remember it is was simply by
including the time part of the timestamp -- I think it was.

Cheers,
-- jra
-- 
Jay R. Ashworth                   Baylink                      jra at baylink.com
Designer                     The Things I Think                       RFC 2100
Ashworth & Associates     http://baylink.pitas.com                     '87 e24
St Petersburg FL USA      http://photo.imageinc.us             +1 727 647 1274