From owner-freebsd-questions@FreeBSD.ORG Wed Oct 1 09:33:20 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 0E9391065692 for ; Wed, 1 Oct 2008 09:33:20 +0000 (UTC) (envelope-from zszalbot@gmail.com) Received: from hs-out-0708.google.com (hs-out-0708.google.com [64.233.178.241]) by mx1.freebsd.org (Postfix) with ESMTP id 841518FC27 for ; Wed, 1 Oct 2008 09:33:18 +0000 (UTC) (envelope-from zszalbot@gmail.com) Received: by hs-out-0708.google.com with SMTP id 54so136952hsz.11 for ; Wed, 01 Oct 2008 02:33:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=CcqA0e71TeklsAeZauv1y9vqjxProuSTXdC1GfcydeI=; b=cWTI/Emi5GYQwdO+N8n6efe7vu7yhPPrTqsnTF3xEYuwO10l8mb2E3Czlj11bubUNs VJKD1FeGitMO09BBbLs8VPHUapmb3CLbVa4UDpj3D3nCFHnGkJrm3a/Pflaxu91N9acL k+u8hRNfMBzcLnfOIggaUORNDP7AgAbS/xGKM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=iHphZRhHYNHL9aycxg+YszR0B6v2N9sFGMBSOHWraV7GS06e2vcieGM6pv4B6EpWo6 6M9tZaMt0xmgbeKbXdJJuMJbGzC1riCDX+BA/Lu+5al02NrnAT7rVFWLOjcpHNxof2yi g4jAtpDSnE6psz13cKV9ojkFTTgYwNijTQaXA= Received: by 10.64.180.15 with SMTP id c15mr13531328qbf.26.1222851715763; Wed, 01 Oct 2008 02:01:55 -0700 (PDT) Received: by 10.64.112.18 with HTTP; Wed, 1 Oct 2008 02:01:55 -0700 (PDT) Message-ID: <94136a2c0810010201y6d561828lb125419de1613aee@mail.gmail.com> Date: Wed, 1 Oct 2008 11:01:55 +0200 From: "Zbigniew Szalbot" To: freebsd-questions In-Reply-To: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com> 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: Wed, 01 Oct 2008 09:33:20 -0000 Hi, 2008/10/1 John Almberg : > 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... I'd recommend http://sourceforge.net/projects/automysqlbackup/ very easy to set up. -- Zbigniew Szalbot