Date: Thu, 02 Oct 2008 09:22:14 +0100 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: =?UTF-8?B?U2ViYXN0aWFuIFR5bWvDs3c=?= <sebastian.tymkow@gmail.com> Cc: John Almberg <jalmberg@identry.com>, freebsd-questions@freebsd.org Subject: Re: Best way to back up mysql database Message-ID: <48E484B6.7090502@infracaninophile.co.uk> In-Reply-To: <692660060810010933t6ada2c85g18b3e0e60d2cf02d@mail.gmail.com> References: <835F48BA-494E-44A0-8D2B-D9F139AB2125@identry.com> <94136a2c0810010201y6d561828lb125419de1613aee@mail.gmail.com> <81F44C16-59C8-4A44-AE2A-B9F233834383@identry.com> <692660060810010933t6ada2c85g18b3e0e60d2cf02d@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 Sebastian Tymków wrote: | Hello, | | You can store whole db files too. It's faster to run database from scratch | than use mysqldump and mysql "source". Um... no. In general you cannot do this, and it is exceedingly irresponsible to suggest such a thing. The *only* way this would ever be workable is if you shut down MySQL completely while your backup process was running. For anything other than a pissant little hobbyist DB that does no real work, that idea is just going to be a non-starter. If MySQL is running, then there is no guarantee that the contents of any disk file has been properly synched with the in-memory working copy of the data. Basically what you'ld be copying off the disk drive will be full of inconsistencies and hence useless as a backup. This is why programs like mysqldump(1) exist. Cheers, Matthew - -- Dr Matthew J Seaman MA, D.Phil. Flat 3 ~ 7 Priory Courtyard PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate ~ Kent, CT11 9PW, UK -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREDAAYFAkjkhLYACgkQ3jDkPpsZ+VYlrQCgs+tBSJfxa8cKHF+oYsu5Cai2 qZEAoJ6lZupzjapi9ugrE20Jp6Ol1xxj =PMs9 -----END PGP SIGNATURE-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?48E484B6.7090502>