Best way to back up mysql database
freebsd at celestial.com
Tue Sep 30 22:24:06 UTC 2008
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.
INTERNET: bill at 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.
More information about the freebsd-questions