Zen Cart Logo
Forums / General Questions / Help moving database to new install please

Help moving database to new install please

Locked

Views: 744

Results 1 to 9 of 9
This thread is locked. New replies are disabled.
31 Oct 2010, 8:55 PM
#1
coasyalk avatar

coasyalk

New Zenner

Join Date:
Nov 2009
Posts:
4
Plugin Contributions:
0

Help moving database to new install please

I am moving my zen cart to a new host and new domain name. I have exported the database in phpadmin. them tried to import in to the new database on the new host.
Zencart is already set up and runs fine.
Everytime I import the old database it imports all the items...but none of them show up in zencart!. HELP? and yes I have gone through and read allllllll the documentation.

1 Nov 2010, 5:18 AM
#2
drbyte avatar

drbyte

Sensei

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

Re: Help moving database to new install please

Apparently you skipped the note in step 2(a) in the tutorial: https://www.zen-cart.com/tutorials/index.php?article=100

a. Install (when asked about the database-table-prefix during Database-Setup, use the same prefix that your old store uses)

1 Nov 2010, 6:22 PM
#3
coasyalk avatar

coasyalk

New Zenner

Join Date:
Nov 2009
Posts:
4
Plugin Contributions:
0

Re: Help moving database to new install please

But it is the same prefix...this is what I dont understand

1 Nov 2010, 6:29 PM
#4
wmorris avatar

wmorris

Totally Zenned

Join Date:
Aug 2007
Location:
Amarillo, Tx
Posts:
1,682
Plugin Contributions:
0

Re: Help moving database to new install please

what is your web address so we can take a look.

1 Nov 2010, 6:43 PM
#5
saitomedia avatar

saitomedia

Zen Follower

Join Date:
Feb 2008
Location:
Southern California
Posts:
146
Plugin Contributions:
0

Re: Help moving database to new install please

I don't know if this helps, but here is my little checklist I made for configure.php and/or .htaccess files regarding shop migration.

Check/change:
· path of the installation (if different)
· zen cart version must be identical
· database name (if different)
· database table prefix (if different)
· database username (if different)
· database password (if different)
· .htaccess contents in root directory & admin directory
· .htpasswrd file location
· reset directory key (http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_54&products_id=82)

1 Nov 2010, 6:58 PM
#6
coasyalk avatar

coasyalk

New Zenner

Join Date:
Nov 2009
Posts:
4
Plugin Contributions:
0

Re: Help moving database to new install please

I am going to try a complete reinstall....check off everything I am doing.....then come back.......try try and try again:dontgetit

1 Nov 2010, 7:16 PM
#7
saitomedia avatar

saitomedia

Zen Follower

Join Date:
Feb 2008
Location:
Southern California
Posts:
146
Plugin Contributions:
0

Re: Help moving database to new install please

Keep trying, you'll see that the time you spent is well worth it! Post anything if you figured it out, or still having trouble :P

1 Nov 2010, 8:32 PM
#8
coasyalk avatar

coasyalk

New Zenner

Join Date:
Nov 2009
Posts:
4
Plugin Contributions:
0

Re: Help moving database to new install please

yeeeeeeeeeeeeha....the silly mistakes you make when you arent paying full attention...zc_ instead of zen_ as the prefix. yeh....I ama woman and I am admitting I was wrong:clap:
well....three kids amd installs at the same time. somethings you just can't multi task

1 Nov 2010, 9:43 PM
#9
saitomedia avatar

saitomedia

Zen Follower

Join Date:
Feb 2008
Location:
Southern California
Posts:
146
Plugin Contributions:
0

Re: Help moving database to new install please

Thanks for your report coasyalk,

You double checked the table prefix and it was wrong. Good catch!

It made this thread meaningful for other people.