Brian Bosch wrote:
On 12/3/05, Wade Maxfield <[EMAIL PROTECTED]> 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
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
