On Tue, Sep 30, 2008, John Almberg wrote: > First, I wanted to say how great this list is. I'm a newbie FreeBSD > admin and, besides the Handbook and "Absolute FreeBSD" (which never > seems to leave my desk), this list is the best resource I have. > > I just had a huge scare today... One of the websites on my server uses a > large Mysql database. Somehow, one of the tables got corrupted today. > > I have been blithely backing up mysql with a simple cron script that ran > mysqldump every night. Simple, reliable, and I've never needed it. > > Today, when I realized the database was corrupted, I scrambled for my > backup, and realized that if I hadn't caught the problem today, tomorrow > my backup would have been overwritten, and I would have been... well, not > a happy camper.
I would suggest using something like logrotate to rotate the backups giving you several days of backup files. Bill -- INTERNET: [EMAIL PROTECTED] Bill Campbell; Celestial Software LLC URL: http://www.celestial.com/ PO Box 820; 6641 E. Mercer Way Voice: (206) 236-1676 Mercer Island, WA 98040-0820 Fax: (206) 232-9186 There is nothing as stupid as an educated man if you get him off the thing he was educated in. Will Rogers _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"