From owner-freebsd-questions@FreeBSD.ORG Tue Sep 30 22:27:53 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 04CF11065686 for ; Tue, 30 Sep 2008 22:27:53 +0000 (UTC) (envelope-from spomerg@cwu.EDU) Received: from scylla.cts.cwu.edu (scylla.cts.cwu.edu [198.104.67.151]) by mx1.freebsd.org (Postfix) with ESMTP id D99D98FC1D for ; Tue, 30 Sep 2008 22:27:52 +0000 (UTC) (envelope-from spomerg@cwu.EDU) Received: from CONVERSION-CWU-DAEMON.SCYLLA.CTS.CWU.EDU by SCYLLA.CTS.CWU.EDU (PMDF V6.4 #31640) id <01N06EDCP2Y80005EE@SCYLLA.CTS.CWU.EDU> for freebsd-questions@freebsd.org; Tue, 30 Sep 2008 15:27:36 -0700 (PDT) Received: from hermes.cwu.edu (hermes.cwu.edu [172.16.21.28]) by SCYLLA.CTS.CWU.EDU (PMDF V6.4 #31640) with ESMTP id <01N06EDCCQES0005OD@SCYLLA.CTS.CWU.EDU> for freebsd-questions@freebsd.org; Tue, 30 Sep 2008 15:27:24 -0700 (PDT) Received: from cwugate1-MTA by hermes.cwu.edu with Novell_GroupWise; Tue, 30 Sep 2008 15:27:24 -0700 Date: Tue, 30 Sep 2008 15:27:19 -0700 From: Gavin Spomer In-reply-to: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com> To: freebsd-questions@freebsd.org Message-id: <48E24557.D9EE.0090.0@gwmail.cwu.edu> MIME-version: 1.0 X-Mailer: Novell GroupWise Internet Agent 7.0.3 References: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8BIT X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: Re: Best way to back up mysql database X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 30 Sep 2008 22:27:53 -0000 >>> John Almberg 09/30/08 3:18 PM >>> 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. Again, I have run into a problem which is stupidly obvious to experienced admins, I'm sure. I want to slap myself, but don't have time. I'll do that after I have a better backup system in place. I am just about to dive into Google in search of a solution, but thought I would fire off a quick request, in case there is an obvious solution that everyone uses. If there is, a name or URL will do. I'll figure out the rest. Any hints much appreciated. Not going home until this is fixed... -- John Off the top of my head, (someone else probably has a better solution, they always do ;) ) why don't you keep more than one backup and rotate them like logs and not overwrite yesterdays backup every day? Hope my 1ยข at least gives you an idea or two. :D