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.
Thread: Moving DB to New Server
Results 1 to 4 of 4
Hybrid View
-
22 Jun 2006, 03:47 AM #1
New Zenner
- Join Date
- Jul 2005
- Posts
- 31
- Plugin Contributions
- 0
Moving DB to New Server
-
22 Jun 2006, 04:37 AM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,443
- Plugin Contributions
- 279
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, 03:42 AM #3
New Zenner
- Join Date
- Jul 2005
- Posts
- 31
- 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, 04:04 AM #4
Sensei
- Join Date
- Jan 2004
- Posts
- 66,443
- Plugin Contributions
- 279
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.
Similar Threads
-
v150 moving to a new server
By raf696 in forum General QuestionsReplies: 17Last Post: 21 May 2012, 05:52 PM -
SMTP - Failed to Connect - SMTP Server Logs EMPTY - after moving to new server
By 3DPeruna in forum Basic ConfigurationReplies: 1Last Post: 16 Mar 2012, 07:47 AM -
Moving to a new server
By snowy2008 in forum Installing on a Linux/Unix ServerReplies: 2Last Post: 25 Jun 2008, 11:31 PM -
Moving to new server
By peak in forum General QuestionsReplies: 5Last Post: 3 Jun 2006, 02:01 AM
