Support » Installing WordPress » error when installing new wordpress site from backup database

  • petronius

    (@petronius)


    I installed wordpress on the new host using auto-install program softaculus from the host
    uploaded the code, changing the config to the new db
    then went to import the db from an phpmyadmin export to db.sql file
    it runs through it then
    i get a duplicate error?

    ‘#1062 – Duplicate entry ‘2’ for key 1′

    Any advice?
    Should I drop all the tables and try the import again?

Viewing 2 replies - 1 through 2 (of 2 total)
  • esmi

    (@esmi)

    Pavel Petrov

    (@smoth3r3d)

    You should have checked “DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT” when exporting the database with phpMyAdmin. If you manually drop the table, recreate an empty one and then import your CSV/SQL with phpMyAdmin it should work.
    Other solution would be if you have XAMPP/WAMP installed import the database there, and then export it with the DROP option checked.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘error when installing new wordpress site from backup database’ is closed to new replies.