[mythtv-users] Database Backup (Was: How big is your database?)

Tom Lichti 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
>> http://sourceforge.net/projects/automysqlbackup/
>>
>> 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:
> #!/bin/sh
> /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.... :)

Tom


More information about the mythtv-users mailing list