1062 Error while importing SQL data from old website to a new website.

Hello Guys,

Here I come with a new problem.

I have a old domain latest-autoreviews.info and my new domain cforcars.com

I am moving all of my contents from old domain to new domains, and redirecting my old domain to new domain.

I have exported the sql database of my old domain, and while I am trying to upload it to the new domain I am getting the error as said below

As I am not able to paste the error here Please find the attachment containing the error.

Can you guys please help me in resolving this issue for me. both the domains are hosted on the same a hosting accoutn @ hostgator (linux)

 

1) Run a select query and see if a duplicate value exisits.
2) Try Dumping the batch with drop statment
http://stackoverflow.com/questions/14628269/error-code-1062-duplicate-entry-1-for-key-primary

 

I am sorry I don't konw how to do it. can you guide me step by step

 

you probably have a column in your old table with an ID or something, that is set to auto increment on the new table, and that is where the dupe is coming from on import

 

I think you have tried loading this data many times all you need to do is at the moment is run bellow command and start dumping data again to check it:

truncate table wp_cbnetpo_ping_optimizer;

hope it works

 

or "delete from wp_cbnetpo_ping_optimizer"