Best way to back up mysql database

[Bill Campbell]

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 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.
    Will Rogers