transferring wordpress database issue

  • josoap

    (@josoap)


    9 years, 9 months ago

    Hi,

    I’ve developed a wordpress site on my hosting account. Now it’s finished I’m transferring it to my client’s hosting account.

    Tried using Duplicator plug in. Normally takes 10 minutes ish. But my clien’t hosting account can’t handle Duplicator for some reason. So I’ve had to do it manually.

    Problem is, when I get to the importing the database I get this message:

    “Your PHP MySQL library version 5.1.73 differs from your MySQL server version 5.5.33. This may cause unpredictable behavior”

    Then it wont import the database. I get an error saying there’s an error on this line 73 of the mysql database:
    “INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id) VALUES”

    I haven’t got a clue what to do and would appreciate any advice please from someone who’s experienced this before.

    Thanks.

Viewing 1 replies (of 1 total)
  • Moderator James Huff

    (@macmanx)

    9 years, 9 months ago

    That first bit is the problem, “Your PHP MySQL library version 5.1.73 differs from your MySQL server version 5.5.33. This may cause unpredictable behavior”

    Basically, PHP only knows how to talk to MySQL 5.1.73 (the final version of a branch of MySQL discontinued in 2014), but the server is running MySQL 5.5.33 (actually an older version, even though it’s a newer branch, released in 2013).

    You will need to report this to the hosting provider to fix, thought to be honest, based on those versions, you might want to find a different hosting provider. We have a few recommendations listed at https://wordpress.org/hosting/

Viewing 1 replies (of 1 total)

The topic ‘transferring wordpress database issue’ is closed to new replies.

Tags