Zen Cart Logo
Forums / Installing on a Windows Server / Moving DB to New Server

Moving DB to New Server

Locked

Views: 2,480

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,513
Plugin Contributions:
177

Re: Moving DB to New Server

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

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,513
Plugin Contributions:
177

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" ?