On Wednesday 16 October 2002 03:14, Jeffrey_N_Dyke@Keane.com wrote: > I am in the process of upgrading my UNIX hardware and moving web sites from > two different servers on to one server. I am curious as to opinions about > moving/replicating the databases and peoples experiences. For the two that > i have already done, i have taken a rather manual approach which was easy, > but the rest are more dynamically generated and dependent on MySQL and I > was looking for a tool that could replicate the structure and data onto a > new server. > > Anybody find an easy way to do this. I could write something in PHP, but > if i could, it's probably already written.... For mysql, if you have the luxury of being to stop the server(s) then just stop mysqld and copy the data files across to the new server. Or if you need to keep the server running you can use mysqldump -- but if you have a busy server then as soon as you've used mysqldump the data is out of date! -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Blore's Razor: Given a choice between two theories, take the one which is funnier. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
