Zen Cart Logo
Forums / Installing on a Linux/Unix Server / Having trouble importing my database

Having trouble importing my database

Locked

Views: 1,031

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
22 Jun 2009, 2:36 AM
#1
pharry avatar

pharry

Zen Follower

Join Date:
Jun 2009
Posts:
131
Plugin Contributions:
0

Having trouble importing my database

I've created a small test environment on my pC, and now I'm trying to move it to the test environment on my remote server. I've run the install, and I'm now trying to import the database. I get an error saying address book table already exists.

I created the database on the remove server before the install. I think I had to do this, right? So now how do I import my tables from my PC into the tables on the remote server?

22 Jun 2009, 3:39 AM
#2
canopy avatar

canopy

Totally Zenned

Join Date:
Oct 2006
Posts:
625
Plugin Contributions:
0

Re: Having trouble importing my database

I assume you have followed the instructions in this FAQ about moving your Zen Cart installation to a another server.

Based on the error you posted, it is likely you did not check the DROP TABLE option while exporting the database and hence you have a problem during the database import on your server.

Try going through the recommended settings for exporting your current test database from this FAQ and retry the database import on your server again.

22 Jun 2009, 10:14 AM
#3
pharry avatar

pharry

Zen Follower

Join Date:
Jun 2009
Posts:
131
Plugin Contributions:
0

Re: Having trouble importing my database

Thank you! I found a FAQ that simply said to export then import. Somehow I totally missed this one that you referenced. I was able to export and import with that. And I've bookmarked it for next time. Thank you very much.