Having trouble importing my database

[pharry]

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?

[canopy]

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.

[pharry]

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.