Merge Word Press same name table in phpmyadmin, two [login to view URL] into one
I have two wp_posts tables, both are already uploaded to myphpadmin. One is labeled wp_posts_new, but they bot need to be merged into wp_posts_new.
Tried to import the new [login to view URL] into the current wp_posts but got error:
Error
SQL query:
-- -- Dumping data for table `wp_posts` -- INSERT INTO `wp_posts` (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`, `comment_count`) VALUES (4, 1, '2011-06-04 09:36:15', '2011-06-04 09:36:15', '<img class="alignnone size-full wp-image-63" title="featured_home" src="http://"website".com/wp-content/uploads/2011/09/[login to view URL]" alt="" width="941" height="506" />', 'Home', '', 'publish', 'open', 'open', '', 'home', '', '', '2011-09-21 22:49:13', '2011-09-22 05:49:13', '', 0, 'http://"website".com/?page_id=4', 0, 'page', '', 0), (5, 1, '2011-06-04 09:36:11', '2011-06-04 09:36:11', '', 'Auto Draft', '', 'inherit', 'open', 'open', '', '4-revision', '', '', '2011-06-04 09:36:11', '2011-06-04 09:36:11', '',[...]
MySQL said: Documentation
#1062 - Duplicate entry '4' for key 'PRIMARY'
Not sure how to fix myself.
Need within one day.