Import sql backup error
-
Any help much appreciated. I tried to import using PHPMyAdmin a backup *.sql file from a previous WP site (older version) to my new host with a 3.9.1 fresh install. I got the following error.
#1062 – Duplicate entry ‘4’ for key ‘PRIMARY’
It did upload a bunch of files and when I tried to redo it I got the following also. Now I’m lost what to do. Help please.
INSERT INTO
wp_commentmeta(
meta_id,
comment_id,
meta_key,
meta_value`) VALUES
(4, 5, ‘_wp_trash_meta_status’, ‘0’),
(3, 6, ‘_wp_trash_meta_status’, ‘0’),
(5, 10, ‘_wp_trash_meta_status’, ‘0’),
(6, 9, ‘_wp_trash_meta_status’, ‘0’),
(7, 8, ‘_wp_trash_meta_status’, ‘0’),
(51, 282, ‘_wp_trash_meta_status’, ‘0’),
(50, 275, ‘_wp_trash_meta_status’, ‘0’),
(10, 29, ‘_wp_trash_meta_status’, ‘0’),
(11, 32, ‘_wp_trash_meta_status’, ‘0’),
(12, 31, ‘_wp_trash_meta_status’, ‘0’),
(13, 28, ‘_wp_trash_meta_status’, ‘0’),
(14, 25, ‘_wp_trash_meta_status’, ‘0’),
(15, 19, ‘_wp_trash_meta_status’, ‘0’),
(16, 49, ‘_wp_trash_meta_status’, ‘0’),
(17, 48, ‘_wp_trash_meta_status’, ‘0’),
(18, 47, ‘_wp_trash_meta_status’, ‘0’),
(19, 46, ‘_wp_trash_meta_status’, ‘0’),
(20, 45, ‘_wp_trash_meta_status’, ‘0’),
(21, 44, ‘_wp_trash_meta_status’, ‘0’),
(49, 274, ‘_wp_trash_meta_status’, ‘0’),
(23, 42, ‘_wp_trash_meta_status’, ‘0’),
(24, 41, ‘_wp_trash_meta_status’, ‘0’),
(25, 40, ‘_wp_trash_meta_status’, ‘0[…]`
- The topic ‘Import sql backup error’ is closed to new replies.