<br><br><div><span class="gmail_quote">On 9/11/07, <b class="gmail_sendername">Bruce Nordstrand</b> <<a href="mailto:brucen@ksl.com.au">brucen@ksl.com.au</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><br>Jon wrote:<br>>> Oh, and I have to get myself a backup command to automatically put a<br>>> backup somewhere else on the network. That or don't do Myth rebuilds<br>>> when I haven't had enough sleep....
<br>>><br><br></blockquote><br><br>Here is mine. Put in /etc/cron.daily/<br>
----------------------------------------------------------------------------------------<br>
FN=mythtv_backup-$(date +%Y-%m-%d_%H:%M).sql<br>
DIR=/home/myth/.mythbackups<br>
<br>
mysqldump -u mythtv -pmythtv mythconverg -c > $DIR/$FN<br>
<br>
# bzip our db backup so it takes alot less space<br>
bzip2 $DIR/$FN<br>
<br>
#delete any backup files that status haven't changed for over 3 days.<br>
rm $(find $DIR -ctime +3 -name "mythtv_backup*")<br>
---------------------------------------------------------------------------------------<br>
<br>
This keeps 3 but can be modified easily.<br>
<br>
Mitchell<br></div>