Date: Wed, 10 Dec 2008 15:18:32 +0200 From: "Valentin Bud" <valentin.bud@gmail.com> To: "=?ISO-8859-1?Q?Sebastian_Tymk=F3w?=" <sebastian.tymkow@gmail.com> Cc: freebsd-questions@freebsd.org Subject: Re: Best way to back up mysql database Message-ID: <139b44430812100518i1ef9be79v33885dcf6793b745@mail.gmail.com> In-Reply-To: <692660060811060018m7122c5c6k57f22431a2e8cd8@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> <48E484B6.7090502@infracaninophile.co.uk> <692660060811031405t334a1a2cq876913d4b801b180@mail.gmail.com> <692660060811060018m7122c5c6k57f22431a2e8cd8@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?139b44430812100518i1ef9be79v33885dcf6793b745>