<div>In my daily cron job I run this 4 line script which keeps the last 7 backups live on disk, long enough for me to quickly rewind to a recent version, and for my backup software to put them to more permanent backup weekly. it's basic, but functional for roll-back purposes. I loose meta-info for the occassional recording if I rollback after a recording was made, </div>
<div> </div>
<div># cat mysql_backup_myth<br>#!/bin/bash</div>
<div>cd /var/log/mythtv<br>mysqldump -u root --password=my00SQL mythconverg > dump-`date +"%Y%m%d-%H%M%S"`-myth.sql</div>
<div>ls -t dump-*.sql | head -7 | xargs rm<br><br></div>
<div>Buzz.<br></div>
<div class="gmail_quote">On Jan 25, 2008 8:37 PM, Stuart Morgan <<a href="mailto:stuart@tase.co.uk">stuart@tase.co.uk</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="Ih2E3d">On Friday 25 January 2008 10:20:07 Andrew Williams wrote:<br>> It would be nice if the backend would take a snapshot of your database<br>> before moving up to the next version, would be handy for us tracking<br>
> SVN and not realising theres a schema update in the recent revisions.<br><br></div>Someone is working on this feature and creating regular backups automatically<br>from the mythtv.<br>--<br><font color="#888888">Stuart Morgan<br>
</font>
<div>
<div></div>
<div class="Wj3C7c">_______________________________________________<br>mythtv-dev mailing list<br><a href="mailto:mythtv-dev@mythtv.org">mythtv-dev@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev</a><br>
</div></div></blockquote></div><br>