Importing data into tables

[john_c]

I am importing a database from one server to another via phpMyAdmin. I am importing one table at a time. Importing records into an empty table is no problem. But I am getting SQL errors (duplicate errors) when importing records into a table that is partially populated.

Some of the tables are populated with default data (like the configuration table). I am wondering about a couple of things.

First, does importing data into the Zen Cart database override records or just add records. I don't want to add records but replace records so I am wondering if I should delete all the default records first before I import records into any particular table. Should I delete all the records so I can import into an empty table? Any advice from anyone that has been down this road?

[john_c]

Since no one replied I will answer my own question in case someone else is importing data for the first time using phpMyAdmin and needs some of the same information.

Importing tables went smoothly. Since Zen Cart has some default records in many of it's tables on the initial install, I got SQL errors when I tried to import tables into a table that already had some records. I deleted all the records from a table before I imported the records from the other server. A table has to be empty before you can import records into it (unless you are appending records). This worked well. Occasionally, I would get a SQL error because a field was added to the source table, so I would have to add the same field to the original Zen Cart table.