Zen Cart Logo
Forums / Installing on a Linux/Unix Server / Database issue in moving store...

Database issue in moving store...

Locked

Views: 995

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
25 Aug 2010, 7:59 PM
#1
srhedd avatar

srhedd

New Zenner

Join Date:
Jun 2010
Posts:
55
Plugin Contributions:
0

Database issue in moving store...

I have a complete site on a test server, installed the same "d" version as on the current server. No matter what instructions I follow, I can't get the test site to see the old database. The fresh install works fine, and the old site is still live, so it works perfectly. I need the test site to be exactly like the live site before I pull the plug on that hosting account. I've made so many tweaks and adjustments, it is impractical to start over again, AND we have 200 or so customers in the old database, not to mention all the product data.

HELP?!?!?!:frusty:

25 Aug 2010, 8:12 PM
#3
srhedd avatar

srhedd

New Zenner

Join Date:
Jun 2010
Posts:
55
Plugin Contributions:
0

Re: Database issue in moving store...

When I exported the db from our old GoDaddy server, it just gave me a file name that was 1017510012483.sql. My hosting account supports staff tell me the prefix is "zen_".

25 Aug 2010, 8:25 PM
#4
drbyte avatar

drbyte

Sensei

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

Re: Database issue in moving store...

Is the prefix in your new store the same as the prefix in the old one?

Most likely you're importing a database that used different prefixes, and thus you'll likely have two sets of tables in your new site, and since new site is using a different prefix, it's not seeing the old data from the old tables using the old prefix.

25 Aug 2010, 8:40 PM
#5
srhedd avatar

srhedd

New Zenner

Join Date:
Jun 2010
Posts:
55
Plugin Contributions:
0

Re: Database issue in moving store...

Yes, both are 'zen_'

25 Aug 2010, 8:46 PM
#6
drbyte avatar

drbyte

Sensei

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

Re: Database issue in moving store...

How did you do the move?
Did you follow the tutorial I mentioned? what did you do differently?

25 Aug 2010, 8:53 PM
#7
srhedd avatar

srhedd

New Zenner

Join Date:
Jun 2010
Posts:
55
Plugin Contributions:
0

Re: Database issue in moving store...

Followed it to the letter... three times.