Importing MySQL problem

[twinkle]

I am trying to export a mySQL db from one server and import it to another.

When I try to do it though, I get an error that the field or data already exists. What I want to do is overwrite the fields that already exist with the imported data. What am I doing wrong?
_________________
I shine

[administrator]

Can you post the exact error you got? How did you do the export and import?


Thanks,

Peter
_________________
Peter
ASP & ASP.NET Articles and Tutorials

[twinkle]

I am getting "Table Marksman_Data Already Exists"

I am just using the export option and then pasting the file in phpmyadmin on the other server and then it processes it and gives me that error.
_________________
I shine

[administrator]

You can import the data to a new table, lets say Marksman_Data_Temp and then update (overwrite) the original table with the values from the temp one...




Peter
_________________
Peter
ASP & ASP.NET Articles and Tutorials

[mikelbeck]

Are the structures the same in both databases? If so, when you export from the first database, don't include the "create table" commands. That way it'll just insert the data but won't try to create tables that already exist.

[twinkle]