From owner-freebsd-questions@FreeBSD.ORG Sun Jan 15 23:12:42 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id EA05B16A42B for ; Sun, 15 Jan 2006 23:12:42 +0000 (GMT) (envelope-from grog@lemis.com) Received: from ext-gw.lemis.com (ext-gw.lemis.com [150.101.14.10]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2D43543D46 for ; Sun, 15 Jan 2006 23:12:42 +0000 (GMT) (envelope-from grog@lemis.com) Received: from wantadilla.lemis.com (wantadilla.lemis.com [192.109.197.135]) by ext-gw.lemis.com (Postfix) with ESMTP id 17C35131DE3; Mon, 16 Jan 2006 09:42:41 +1030 (CST) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id DF57585843; Mon, 16 Jan 2006 09:42:40 +1030 (CST) Date: Mon, 16 Jan 2006 09:42:40 +1030 From: Greg 'groggy' Lehey To: Hans Nieser Message-ID: <20060115231240.GB73071@wantadilla.lemis.com> References: <43C6E55A.8020500@xs4all.nl> <20060113145003.GJ2451@ayvali.org> <43C9C14F.3050105@nieser.net> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="/Hw833bnybanDj6H" Content-Disposition: inline In-Reply-To: <43C9C14F.3050105@nieser.net> User-Agent: Mutt/1.4.2.1i Organization: The FreeBSD Project Phone: +61-8-8388-8286 Fax: +61-8-8388-8725 Mobile: +61-418-838-708 VoIP: sip:0871270137@sip.internode.on.net WWW-Home-Page: http://www.FreeBSD.org/ X-PGP-Fingerprint: 9A1B 8202 BCCE B846 F92F 09AC 22E6 F290 507A 4223 Cc: freebsd-questions@freebsd.org, siegfried.pietralla@eds.com Subject: Re: mysql backups (was Re: Remote backups, reading from and writing to the same file) 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: Sun, 15 Jan 2006 23:12:43 -0000 --/Hw833bnybanDj6H Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sunday, 15 January 2006 at 4:28:15 +0100, Hans Nieser wrote: > N.J. Thomas wrote: >> * Hans Nieser [2006-01-13 00:25:14 +0100]: >>> Among the things being backed up are my mysql database tables. This >>> made me wonder wether the backup could possibly get borked when mysql >>> writes to any of the mysql tables while tar is reading from them. >> >> Yes. While MySQL is writing to the the database, it will put the files >> on the disk in an inconsistent state. If you happen to copy those files >> while they are in that state, MySQL will see a corrupted database. > > Thanks for the replies all. I think for the short term I will simply > lock/shutdown my MySQL server (it is a home-server after all), in the long > term I think I will look into snapshotting. I've also been thinking about > just doing an SQL dump with mysqldump right before the backup, that will > still copy along the tables which may be in an inconsistent state, but > also the sql dump. We (MySQL) are currently working on an online backup solution which will address the issues you mention. We don't have a firm date yet, but it should be this year. If you or anybody else has feature requests, please let me know (preferably grog@MySQL.com, but this address will work too). Greg -- When replying to this message, please copy the original recipients. If you don't, I may ignore the reply or reply to the original recipients. For more information, see http://www.lemis.com/questions.html See complete headers for address and phone numbers. --/Hw833bnybanDj6H Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (FreeBSD) iD8DBQFDytboIubykFB6QiMRAvTxAJ9YL9KuoiRpTCXEkDcr8mFcDWRkmgCbBoPK H7eP3de56nAfCvbHhNswUX0= =ggge -----END PGP SIGNATURE----- --/Hw833bnybanDj6H--