error importing sql file from one host to another.

lassie911 Well-Known Member

Messages:: 1,521

Likes Received:: 27

Best Answers:: 0

Trophy Points:: 160

#1

Here is the error I'm getting while trying to import a wordpress database file in phpamdin. Does anyone know how this can be fixed? It's only importing 21 of the 53 tables.

Error

SQL query:

-- -- Dumping data for table `wp_autoblogged` -- INSERT INTO `wp_autoblogged` (`id`, `title`, `type`, `url`, `category`, `enabled`, `addothercats`, `addcatsastags`, `tags`, `includeallwords`, `includeanywords`, `includephrase`, `includenowords`, `searchfor`, `replacewith`, `templates`, `poststatus`, `customfield`, `customfieldvalue`, `saveimages`, `createthumbs`, `playerwidth`, `playerheight`, `uselinkinfo`, `useauthorinfo`, `customplayer`, `taggingengine`, `randomcats`, `usepostcats`, `addpostcats`, `author`, `alt_author`, `schedule`, `updatefrequency`, `post_processing`, `max_posts`, `posts_ratio`, `last_updated`, `update_countdown`, `last_ping`, `stats`, `usefeeddate`) VALUES (1, '', 2, 'GPS', 'a:1:{i:0;s:8:"TWpnPQ==";}', 1, 1, 1, 'a:0:{}', '', '', '', '', 'a:0:{}', 'a:0:{}', '

%excerpt%
\r\n%if:video%

%video%
%endif:video%\r\n%if:thumbnail%

%thumbnail%
%endif:thumbnail%\r\n[Read more here|Read the original here|Read more from the original source|Continued h[...]

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'id'
Click to expand...