WordPress.org

1. timlem
   Member
   Posted 1 year ago #

   I am trying to migrate to a different host. I have done the xml export and import and I am missing a bunch of posts (200 and some). I also did the mysql database import and get the following error. PLEASE HELP!

   Error
   SQL query:

   -- -- Dumping data for table wp_ak_twitter -- INSERT INTO wp_ak_twitter (id, tw_id, tw_text, tw_reply_username, tw_reply_tweet, tw_created_at, modified) VALUES (1, '318893232', 'just got back from baptizing my daughter! This is one of the best days of my life! Very cool experience!', NULL, NULL, '2007-10-07 21:23:49', '2007-10-08 14:24:32'), (2, '318242402', 'Sitting 1st service youth. Can''t wait for my daughter to get baptized today! My 2 cousins are getting baptized today too!', NULL, NULL, '2007-10-07 14:13:02', '2007-10-08 14:24:32'), (3, '303149102', 'Last night''s Halo Party was awesome! 2nd serv is almost over and I''m starting to crash! I''M TIRED...but it was worth it!', NULL, NULL, '2007-09-30 15:53:40', '2007-10-08 14:24:32'), (4, '301121302', 'Cleaning house like a mad man for today''s festivities!', NULL, NULL, '2007-09-29 14:06:45', '2007-10-08 14:24:32'), (5, '299601372', 'Just saw my friend matt newton! also got to see my first iPhone! Wow! I''v[...]

   MySQL said:

   #1062 - Duplicate entry '1' for key 1

2. James
   Happiness Engineer
   Posted 1 year ago #

   If you can, try deactivating all plugins, then backup your database on the previous host following these instructions and restore it on the new host following these instructions.

   If that doesn't work, try the XML import again, but you may need to increase PHP's memory limit, execution time, or file upload limit. Though this FAQ is not directly related to your problem, it does detail the necessary alterations:

   http://codex.wordpress.org/FAQ_Working_with_WordPress#How_do_I_Import_a_WordPress_WXR_file_when_it_says_it_is_too_large_to_import.3F

3. timlem
   Member
   Posted 1 year ago #

   Thx for replying man. I'll take a look at it, unfortunately I won't have anytime for a little while but I'll let you know if it worked.

4. timlem
   Member
   Posted 1 year ago #

   do i have to do the xml export as well as the database import? Or is that just redundancy?

5. timlem
   Member
   Posted 1 year ago #

   I got this error when importing new xml file after deactivating all plugins.

   Post Wingsuit BaseJumpingHTTP/1.1 200 OK Date: Tue, 15 Jun 2010 21:18:55 GMT Server: Apache Expires: Wed, 11 Jan 1984 05:00:00 GMT Last-Modified: Tue, 15 Jun 2010 21:18:56 GMT Cache-Control: no-cache, must-revalidate, max-age=0 Pragma: no-cache Connection: close Transfer-Encoding: chunked Content-Type: text/html; charset=iso-8859-1
   OK

   The server encountered an internal error or misconfiguration and was unable to complete your request.
   Please contact the server administrator, support@supportwebsite.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

   More information about this error may be available in the server error log.

   Apache/1.3.33 Server at timlemons.com Port 80

6. James
   Happiness Engineer
   Posted 1 year ago #

   You won't need to import the XML file if you can restore the database backup. Were you able to do that?

7. timlem
   Member
   Posted 1 year ago #

   WOW. ok i kept doing it and eventually it downloaded all of it. So if I imported all my xml stuff do i still need to mess with my database import?

8. James
   Happiness Engineer
   Posted 1 year ago #

   No, that should be sufficient.

9. timlem
   Member
   Posted 1 year ago #

   Thx man!

10. James
    Happiness Engineer
    Posted 1 year ago #

    You're welcome!

Topic Closed

This topic has been closed to new replies.