[mythtv-users] Database Backup (Was: How big is your database?)
tom at redpepperracing.com
Mon Dec 5 10:52:36 EST 2005
Brian Bosch wrote:
> On 12/3/05, Wade Maxfield <mythtv at hotblack.co.nz> wrote:
>>> Anyone care to post their scipt to back up/compress their database?
>>> I suppose I could write my own, but why reinvent the wheel? :)
>> This is what I use for all my automatic mysql backups (webservers as well)
>> MySQL Backup Script
>> You'll just need to set a couple of preferences in the start of the
>> script, and setup a mysql user with the right permissions...
>> - Wade
> There is information on this here:
> http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5 as well as in the
> archives: http://www.gossamer-threads.com/lists/engine?list=mythtv&do=search_results&search_forum=forum_1&search_string=database+backup&search_type=AND
> Based on info found in the above I have this in my backup script:
> /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | gzip -c >
> "/home/mythtv/backup/mythconverg_backup.`date +%w`.sql.gz"
> cp /home/mythtv/backup/* /home/mythtv/nas/mythbackup/
I do pretty much the same thing, except at the end I split the file into
small (<10MB) segments and email them to my gmail account. Now I have
offsite backup as well, just in case the house burns down and I _really_
need to get my MythTV box working again.... :)
More information about the mythtv-users