[mythtv-users] Mythvideo listing suddenly empty

[Ian Forde]

On Mon, 2005-03-14 at 07:25 +0000, David Morrison wrote:
> After spending ages carefully entering all the information about my
> videos into MythVideo, my videometadata table seems to have emptied
> itself and lost everything. What logs can I look at to find out
> how/when/why this might have happened?
> 
> Obviously, I'm not doing any backups otherwise I wouldn't be grumbling
> so much :-)

Which is why I put this little gem into a script in /etc/cron.daily:

#!/bin/sh

datenow=`date +"%Y%m%d"`
mysqldump --opt mythconverg > /var/lib/backups/mysqldump-${datenow}.sql
gzip -9 /var/lib/backups/mysqldump-${datenow}.sql

Make it executable, create the directory /var/lib/backups/ and you're
golden...

	-I