From owner-freebsd-questions@FreeBSD.ORG Tue Sep 30 22:18:38 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 2254B1065688 for ; Tue, 30 Sep 2008 22:18:38 +0000 (UTC) (envelope-from jalmberg@identry.com) Received: from mx1.identry.com (on.identry.com [66.111.0.194]) by mx1.freebsd.org (Postfix) with ESMTP id B429A8FC15 for ; Tue, 30 Sep 2008 22:18:37 +0000 (UTC) (envelope-from jalmberg@identry.com) Received: (qmail 84960 invoked by uid 89); 30 Sep 2008 22:18:36 -0000 Received: from unknown (HELO ?192.168.1.110?) (jalmberg@75.127.142.66) by mx1.identry.com with ESMTPA; 30 Sep 2008 22:18:36 -0000 Mime-Version: 1.0 (Apple Message framework v752.3) Content-Transfer-Encoding: 7bit Message-Id: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: freebsd-questions@freebsd.org From: John Almberg Date: Tue, 30 Sep 2008 18:18:35 -0400 X-Mailer: Apple Mail (2.752.3) Subject: 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:18:38 -0000 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