I am trying to import a database using phpmyadmin but i get an error that says: #1062 - Duplicate entry '153' for key 'id' anyone how to trouble shoot this puppy?
You have a non-unique ID - maybe because you didn't use autoincrement on the old database, or you have content populating the current database which you're trying to add to. You can chose to drop the id-column (reassigning IDs), but this might be a problem if there is linked content in other tables. What you need to do is validate your data, or if possible, make sure you're importing into an empty table. If that's not possible, you can undo the unique-state of the ID column in the current database, but that might involve a lot of other trouble.
Hey thanks popsicle. I am definitely uploading to an empty database--- i deleted the whole thing right before upload. What is the best way to validate my data?
if you already removed everything => that means in the import sequence you have the issue with the duplicate entry => the insert is twice with the same id if the file isn't too large you could manually edit the insert lines with a text editor