Date: Tue, 30 Sep 2008 15:24:05 -0700 From: Bill Campbell <freebsd@celestial.com> To: freebsd-questions@freebsd.org Subject: Re: Best way to back up mysql database Message-ID: <20080930222405.GA14576@ayn.mi.celestial.com> In-Reply-To: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com> References: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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: bill@celestial.com 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080930222405.GA14576>