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>
next in thread | previous in thread | raw e-mail | index | archive | help
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. m
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050713020612.GA4921>