mySQL error #1062

  • Hello there!
    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!

Viewing 3 replies - 1 through 3 (of 3 total)

  • Kind of sounds like you are importing into the same database as one of your other sites. Keep in mind if you are on the same server you can access databases from other hosts/domains on the same server. Also how are you importing? If the SQL file has the database name in it then it will import into that one or you have to edit the file.

    Thread Starter jessi-ray

    (@jessi-ray)

    Well I am hosted on a subdomain by someone else, or was. My hostess uses Dream Host. I just got hostmonster for another site, which also uses wordpress, but I know the database names are different. The one I’m uploading is Jessisql, and the one that is on there is wp-something… I’m not sure but I know it’s different.

    As far as HOW I’m uploading, I’m just going to my php admin, and then going to import, browse for my sql file and upload. Is there something I have to do to specify a separate upload? Please, let me know!!

    If you are using phpmyadmin than that is it. UNLESS…There is already data and tables in it. If you are moving it should be an empty database. If someone is giving you a db already populated you will want to do a Drop (all) tables which will remove all data.

    Hopefully you have already read:
    https://codex.www.ads-software.com/Moving_WordPress

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘mySQL error #1062’ is closed to new replies.