Date: Sun, 15 Jan 2006 04:28:15 +0100 From: Hans Nieser <hans@nieser.net> To: freebsd-questions@freebsd.org Cc: siegfried.pietralla@eds.com Subject: Re: mysql backups (was Re: Remote backups, reading from and writing to the same file) Message-ID: <43C9C14F.3050105@nieser.net> In-Reply-To: <20060113145003.GJ2451@ayvali.org> References: <43C6E55A.8020500@xs4all.nl> <20060113145003.GJ2451@ayvali.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?43C9C14F.3050105>