Date: Mon, 16 Jan 2006 09:42:40 +1030 From: Greg 'groggy' Lehey <grog@FreeBSD.org> To: Hans Nieser <hans@nieser.net> 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) Message-ID: <20060115231240.GB73071@wantadilla.lemis.com> In-Reply-To: <43C9C14F.3050105@nieser.net> References: <43C6E55A.8020500@xs4all.nl> <20060113145003.GJ2451@ayvali.org> <43C9C14F.3050105@nieser.net>
next in thread | previous in thread | raw e-mail | index | archive | help
--/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 <h.nieser@xs4all.nl> [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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060115231240.GB73071>