From owner-freebsd-questions@FreeBSD.ORG Wed Dec 10 13:18:34 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 3E0CE1065670 for ; Wed, 10 Dec 2008 13:18:34 +0000 (UTC) (envelope-from valentin.bud@gmail.com) Received: from mail-ew0-f21.google.com (mail-ew0-f21.google.com [209.85.219.21]) by mx1.freebsd.org (Postfix) with ESMTP id 950B88FC17 for ; Wed, 10 Dec 2008 13:18:33 +0000 (UTC) (envelope-from valentin.bud@gmail.com) Received: by ewy14 with SMTP id 14so729868ewy.19 for ; Wed, 10 Dec 2008 05:18:32 -0800 (PST) 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:cc:in-reply-to:mime-version:content-type:references; bh=9DF2e5ecr6a5xzz13kszuvbOdQvn53GSdDXvS3tb8Vo=; b=wiR4SEHM+1t8890+hyOQ0BFRfMdONEcNC18rmoDENphZPpRy1BiZRKNCALj7nbA89n 1LGBfUR8SanlFk+WumZEfSdo5O5oThp1n2JyTkitw8WcC49YpO5BYmjt2MdW59Z+Enry AqbseC5lSsLhxgLS2frOvfEqx3QapbkpYJ4dY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:references; b=h6WLydMhq/NMOTpUhhaPdrH4QbnMgJP4t1akq/j9Wn2h1KZwUwMvHD0izjbkHs7BAg 1g+9umh+2gZJKJXx3eUCXtysLfZMULfafqvB+VeYP0zRw6xqmeNVbokgNuq1XBEm2kbJ 7iYcIBbvvCGDQ/CL1oxc2NUAU4V8hUC/9n+QE= Received: by 10.210.18.8 with SMTP id 8mr1644778ebr.47.1228915112265; Wed, 10 Dec 2008 05:18:32 -0800 (PST) Received: by 10.210.58.12 with HTTP; Wed, 10 Dec 2008 05:18:32 -0800 (PST) Message-ID: <139b44430812100518i1ef9be79v33885dcf6793b745@mail.gmail.com> Date: Wed, 10 Dec 2008 15:18:32 +0200 From: "Valentin Bud" To: "=?ISO-8859-1?Q?Sebastian_Tymk=F3w?=" In-Reply-To: <692660060811060018m7122c5c6k57f22431a2e8cd8@mail.gmail.com> MIME-Version: 1.0 References: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com> <94136a2c0810010201y6d561828lb125419de1613aee@mail.gmail.com> <81F44C16-59C8-4A44-AE2A-B9F233834383@identry.com> <692660060810010933t6ada2c85g18b3e0e60d2cf02d@mail.gmail.com> <48E484B6.7090502@infracaninophile.co.uk> <692660060811031405t334a1a2cq876913d4b801b180@mail.gmail.com> <692660060811060018m7122c5c6k57f22431a2e8cd8@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-questions@freebsd.org 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, 10 Dec 2008 13:18:34 -0000 Hello list, I apologize if I somehow highjack the thread. I just want to tell the list for further references one way (my way) of doing mysql backup and to ask you if it's safe or not. I have 2 server: one of which is the master (named for the sake of brevity with M) in mysql terms and the second being the slave (named with S). I use mysqldump on S and deliver the tarballs to a remote location. I first stop the slave, do mysqldump and start the slave. Is this approach safe? Some might argue that it's not necessary or even expensive somehow to have 2 boxes *but* in my case I have 2 servers in production and one backups the other. thanks for your input and have a great day, v