Zen Cart Logo
Forums / General Questions / Move only database to a new server?! Possible?

Move only database to a new server?! Possible?

Locked

Views: 2,882

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
25 Nov 2008, 7:20 AM
#1
dachilla avatar

dachilla

New Zenner

Join Date:
Feb 2006
Posts:
66
Plugin Contributions:
1

Move only database to a new server?! Possible?

Hiya folks,

At first I hope i didnt post this to the wrong place in the forum. I have not found a thread so far concerning what I would like to do. I am planning the following stunt:

I want to move the database to a new server, but leave the files on the old one. My old server, where the files are located is https://www.XXX.com and the new server where the database will be located will be https://www.YYY.com

How do i have to change the config files to make that possible?

Please, I appreciate any help, I really need to do this.

Thx to all

D.C.

25 Nov 2008, 7:54 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Move only database to a new server?! Possible?

The important question is "WHY?"

If you do make the move, you're going to have to deal with a number of security issues and networking issues. You'll have to configure the new server's firewall and database to allow connections from another server. You'll have to create new database users to allow connections from the other server. You'll have to post a note to your customers that you are passing all your data across the internet without encryption. You'll have to adjust the old server's configuration to point the database to the new server. You'll have to deal with the fact that your site will suddenly be a whole lot slower than it is now because of connection latency between the database server and your webserver.

If you're going to move, it's generally best to move the whole thing, rather than just pieces.