If this is your first visit, check our documentation. To post, register or login.
Forums / Installing on a Windows Server / Moving DB to New Server

Moving DB to New Server

Locked

Started by czone on 22 Jun 2006, 2:47 AM · Views: 2,497

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
22 Jun 2006, 2:47 AM
#1
czone avatar

czone

New Zenner

Join Date:
Jul 2005
Posts:
16
Plugin Contributions:
0

Moving DB to New Server

I have Zencart installed in a two server configuraton with everything on the web server except for the DB which is on the second server. I have full control of both servers. I need to re-purpose the current DB server for another role and have installed MySQL on the web server and am trying to move the ZenCart database from the current server to the new one.

I've used mysqldump to backup the DB and then restored it onto the new server.
I've granted the correct user access to the DB on the new server.
I changed the DB configuration in both configure.php files to point to the new DB.

I still get a DB connection error.

Can anyone help me figure out what step I'm missing?

Thanks in advance.

22 Jun 2006, 3:37 AM
#2
drbyte avatar

drbyte

Sensei

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

Re: Moving DB to New Server

did you change the name of the database host to point to localhost ?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

23 Jun 2006, 2:42 AM
#3
czone avatar

czone

New Zenner

Join Date:
Jul 2005
Posts:
16
Plugin Contributions:
0

Re: Moving DB to New Server

Yes, I changed the name of the DB Host to localhost. Sorry I didn't mention that before.

23 Jun 2006, 3:04 AM
#4
drbyte avatar

drbyte

Sensei

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

Re: Moving DB to New Server

All the DB authorization info is in the configure.php files.
The only reason Zen Cart will give you authentication errors is if the info in your configure.php files doesn't match what your database server is expecting.

Is your username correct? ie: maybe it should be "myaccount_user" instead of just "user" ?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.