How big does this DB-dump get?
On Mon, 14 Mar 2005 08:17:29 -0800, Ian Forde <[EMAIL PROTECTED]> wrote:
> 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
>
>
> _______________________________________________
> mythtv-users mailing list
> [email protected]
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
>
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
