Hello, I am fed up with this error message. I am trying to export the database from one server and then import to another server. what is the problem actually? How to correct it? Why i am getting this error :- MySQL: Duplicate entry 'config_id' for key 1 Please help
It means you are trying to insert two rows with the same config_id and config_id is a primary key so the id for each row must be different. Try removing the primary key
This is software you haven't created right? Then you probably don't want to remove the primary key. What you need to do is checking that the value doesn't exists in both of the databases. (Since primary keys are required to be unique.)
Well, I didn't mean to remove the primary key permanently. I just meant to remove it to see if it would import while the key was gone, then we definitely know that's the issue.