From owner-freebsd-questions@FreeBSD.ORG Tue Sep 30 22:24:06 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 6A82F106568B for ; Tue, 30 Sep 2008 22:24:06 +0000 (UTC) (envelope-from bill@ayn.mi.celestial.com) Received: from ayn.mi.celestial.com (hayek.celestial.com [192.136.111.12]) by mx1.freebsd.org (Postfix) with ESMTP id 487038FC51 for ; Tue, 30 Sep 2008 22:24:06 +0000 (UTC) (envelope-from bill@ayn.mi.celestial.com) Received: from localhost (localhost [127.0.0.1]) by ayn.mi.celestial.com (Postfix) with ESMTP id DAA3F68614789; Tue, 30 Sep 2008 15:24:05 -0700 (PDT) X-Virus-Scanned: amavisd-new at mi.celestial.com Received: from ayn.mi.celestial.com ([127.0.0.1]) by localhost (ayn.mi.celestial.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id obimGd83RrTS; Tue, 30 Sep 2008 15:24:05 -0700 (PDT) Received: by ayn.mi.celestial.com (Postfix, from userid 203) id BBB78680036BF; Tue, 30 Sep 2008 15:24:05 -0700 (PDT) Date: Tue, 30 Sep 2008 15:24:05 -0700 From: Bill Campbell To: freebsd-questions@freebsd.org Message-ID: <20080930222405.GA14576@ayn.mi.celestial.com> Mail-Followup-To: freebsd-questions@freebsd.org References: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com> User-Agent: Mutt/1.5.18 OpenPKG/% (2008-05-17) Subject: Re: Best way to back up mysql database X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: freebsd@celestial.com List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 30 Sep 2008 22:24:06 -0000 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