Date: Tue, 12 Jul 2005 22:06:12 -0400 From: "Mark Bucciarelli" <mark@gaiahost.coop> To: freebsd-isp@freebsd.org Subject: Re: fastest way to duplicate production server? Message-ID: <20050713020612.GA4921@pooh.hubcapconsulting.com> In-Reply-To: <018801c58731$0929f8a0$0aae5218@garrincha> References: <20050712214555.42683.qmail@web53902.mail.yahoo.com> <018801c58731$0929f8a0$0aae5218@garrincha>
index | next in thread | previous in thread | raw e-mail
On Tue, Jul 12, 2005 at 03:28:32PM -0700, Gustavo A. Baratto wrote: > - to copy over mysql data, you must do a " FLUSH TABLES WITH READ LOCK" > then rsync the data directory over to the test server (/var/db/mysql is the > freebsd default). Then you "UNLOCK TABLES" after rsync is done. Start mysql > and you are done. Instead of a "flush tables with read lock", you could > just stop mysql in the production server. This is just to make sure there > is no updates in the tables while you are copying them over. You can also use the mysqlhotcopy perl script for this task (assuming ISAM tables). It is fast. mhelp
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050713020612.GA4921>