Moving a Shared Database

logistics of IP addresses and changing hosts

[old_expat]

I am changing hosting providers and want my sites to have unique IP addresses with different C blocks if possible.

The new hosting company advises me to move the sites several days apart since the IP addresses are assigned automatically.

No problem except for a database on mysite1.com.

Mysite2.com uses the same database.

The first several lines of code are:

$server="mysite1.com";
$user="mysite1";
$password="password";
$database="database_database";
mysql_connect('localhost',$user,$password);
@MYSQL_SELECT_DB($database) or die("");

So if both sites are on the same server, it works.

I am thinking of putting the database on mysite2.com when it goes on the new server. Then when mysite1.com is moved, I just move it less the database.

It seems pretty simple, but I need to make sure I'm not missing something.

[Jaunty Edward]

Hi,

are you saying you will first more the DB to new server and then the files later on.

if yes,
just make sure that you will be able to use the DB from the new server by files on the old server. Some of the host do not allow that.

secondly if you are using cPanel then you can transfer your complete site including DB email stats to the new server directly(with the help the server admin of the new server, as you need the root pass). Remember this direct transfer has its own issues, actually it depends on the size of the site. If its few hundred MBs it should not be a problem.

Hope this helps in some way.

Thanks
Bye