I am moving my wordpress based website and I'm having an issue with the mySQL database. I downloaded my file from my old host, but when I tried to import it to my new host it refuses to upload, giving me an error "#1062 - Duplicate entry '492' for key 1" with a bunch of coding jiberish and what I can faintly make out as my comments in between.
As a side note, I have another install of wordpress on that host for a different site. And oddly enough when I go to that site's dashboard, some of my old comments show up (no post, pages or other uploads, just a few of my comments.) It's strange.
I only have a few weeks to move this site, so a prompt reply would be greatly appreciated! Thank you!