fastest way to duplicate production server?

[Gustavo A. Baratto]

- install the new versions of Apache/MySQL/PHP in the test server
- make sure apache and php are running with the same configuration of the 
production server (check httpd.conf, php.ini, etc). Just install mysql, no 
need to configure it now, as you gonna copy over the configuration and grant 
tables later.
- use rsync to copy the html and php files from the production server to 
test server.
- 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.

Cheers


----- Original Message ----- 
From: "RC" <rubbishcollector at yahoo.com>
To: <freebsd-isp at freebsd.org>
Sent: Tuesday, July 12, 2005 2:45 PM
Subject: fastest way to duplicate production server?


> We have a production FreeBSD 4.10 server running old versions of
> Apache/MySQL/PHP from ports.  We'd like to upgrade Apache/MySQL/PHP
> to the latest versions.  Before upgrading we'd like to test on a
> test box.
>
> What's the fastest way of duplicating the existing Apache/MySQL/PHP
> (including user databases)?  (The production server cannot go down
> for more than a few seconds.)
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> _______________________________________________
> freebsd-isp at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-isp
> To unsubscribe, send any mail to "freebsd-isp-unsubscribe at freebsd.org"
>