[PHP-DB] Server Upgrade and DB Move(s)
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 Thanks in advance. Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Server Upgrade and DB Move(s)
On Wednesday 16 October 2002 03:14, [EMAIL PROTECTED] 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
Re: [PHP-DB] Server Upgrade and DB Move(s)
At 03:14 PM 10/15/02 -0400, [EMAIL PROTECTED] 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 So how different are the servers? Moving databases between similar servers can be as simple as copying the database directories, and executing a CREATE DATABASE dbname command for each. You will also need to GRANT access to various users as needed. That is part of the mysql database and the easiest way to merge them is by issuing the needed commands. Rick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Server Upgrade and DB Move(s)
thanks guys. that is how i planned to do it, but i wanted to hear this from others. This is how i accomplished the other two moves. sometimes you just want to see if anyone has a better way. and the file copy method just seems to easy, it almost seems wrong ;-), but it doesn't stop me from using it all the time. thanks again. jd Rick Widmer php3@developer To: [EMAIL PROTECTED], [EMAIL PROTECTED] sdesk.comcc: Subject: Re: [PHP-DB] Server Upgrade and DB Move(s) 10/15/2002 04:35 PM At 03:14 PM 10/15/02 -0400, [EMAIL PROTECTED] 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 So how different are the servers? Moving databases between similar servers can be as simple as copying the database directories, and executing a CREATE DATABASE dbname command for each. You will also need to GRANT access to various users as needed. That is part of the mysql database and the easiest way to merge them is by issuing the needed commands. Rick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Server Upgrade and DB Move(s)
On Tue, 2002-10-15 at 15:31, [EMAIL PROTECTED] wrote: and the file copy method just seems to easy, it almost seems wrong ;-), This is a feature that is pretty nice about MySQL. You cannot do this with Postgres, which caused my quite a few nice headaches over the summer. You must dump the tables to an SQL file and read it into the new database. MySQL is pretty cool. --Dave -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php