Moving Wordpress To New Host - Importing Database Error #1062


Staff member
I am moving a wordpress website to a new domain & hosting and I am having problems with this. I have backed up the whole site, imported it via ftp to the new domain and installed wordpress.

However when I try to import my old database to the new site I get this error:


    SQL query:

    -- -- Dumping data for table `wp_contact_form_7` -- INSERT INTO `wp_contact_form_7` (`cf7_unit_id`, `title`, `form`, `mail`, `mail_2`, `messages`, `additional_settings`) VALUES (1, 'Contact form 1', '

    Your Name (required)
    \r\n [text* your-name 35/100]


    Your Email (required)
    \r\n [email* your-email 35/100]

    Your Message
    \r\n [textarea your-message 30/5]

    [submit "Send"]
    ', 'a:7:{s:7:"subject";s:32:" Contact Form";s:6:"sender";s:26:"[your-name] <[your-email]>";s:4:"body";s:194:"From: [your-name] <[your-email]>\r\nSubject: Contact Form\r\n\r\nMessage Body:\r\n[your-message]\r\n\r\n\r\n--\r\nThis mail is sent via contact form on Nixon & Co";s:9:"recipient";s:14:"[email protected]";s:18:"additional_headers";s:0:"";s:11:"attachments";s:0:"";s:8:"use_html";s:0:"";}', 'a:8:{s:6:"active";s:0:"";s:7:"subject";s:14:"[your-subject]";s:6:"[...]

    MySQL said: Documentation
    #1062 - Duplicate entry '1' for key 1

How can I sort this problem?