Moving to a different Host — getting sql error when importing DB

  • Resolved timlem

    (@timlem)


    15 years, 10 months 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

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator James Huff

    (@macmanx)

    15 years, 10 months 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

    Thread Starter timlem

    (@timlem)

    15 years, 10 months 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.

    Thread Starter timlem

    (@timlem)

    15 years, 10 months ago

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

    Thread Starter timlem

    (@timlem)

    15 years, 10 months 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

    Moderator James Huff

    (@macmanx)

    15 years, 10 months ago

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

    Thread Starter timlem

    (@timlem)

    15 years, 10 months 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?

    Moderator James Huff

    (@macmanx)

    15 years, 10 months ago

    No, that should be sufficient.

    Thread Starter timlem

    (@timlem)

    15 years, 9 months ago

    Thx man!

    Moderator James Huff

    (@macmanx)

    15 years, 9 months ago

    You’re welcome!

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Moving to a different Host — getting sql error when importing DB’ is closed to new replies.

Tags