WordPress.org

Support

Support » Plugins and Hacks » WP Migrate DB » [Resolved] Does WP Migrate DB support export from mysql 5.0 to import to 5.5?

[Resolved] Does WP Migrate DB support export from mysql 5.0 to import to 5.5?

  • Just exported from my localhost WP site to import to a new live site. The localhost site is running MySQL 5.0. The live site is running MySQL 5.5. When I tried to import the file from the WP Migrate DB export, I got an error. Does WP Migrate DB support importing into MySQL 5.5 a file that was exported from a MySQL 5.0 site?

    Here’s the entire error message I got in phpmyadmin:

    Error
    SQL query:

    < style TYPE = “text/css” > ul.remote – EVENTS {list – style – TYPE : none;

    MySQL said: Documentation

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘<style type="text/css">

    ul .remote-events{
    list-style-type: none’ at line 1

    https://wordpress.org/plugins/wp-migrate-db/

Viewing 2 replies - 1 through 2 (of 2 total)
  • This is apparently an issue of a corrupted export file (and a possible bug), not a 5.5 vs.5.0 issue. (I re-installed / re-exported with a 5.0 DB and got same results.) Details:

    1) WP Migrate DB version: Version 0.5; WP version: 3.8.1; Exported with default options.
    2) The exported .sql file begins with css code:
    <style type=”text/css”>

    ul .remote-events{
    list-style-type: none;
    }
    .remote-events li{
    list-style-type: none;
    }
    …etc …
    </style>
    3) The exported file is truncated at the end, in the middle of “wp_users” (user details changed for safety):
    “…
    INSERT INTO wp_users VALUES (5, ‘jdoe’, ‘$P$BUs23VOZuyoxwFGIQmeCFk45E5dh/’, ‘jdoe’, ‘jdoe@mysite.com’, ”, ‘2013-02-28 20:49:39’, ”, 0, ‘John Doe’) ;
    INSERT INTO `wp_us”

    4) Did a grep for the css and found it (inline) inside of one of my files: “theme-shortcodes.php”. Altho I shouldn’t have put the code there, I am not sure why WP Migrate DB would read the contents of this file…
    Once I removed the css, the output SQL looked okay and imported correctly.

    Sounds like this may be a bug ? …

    Are you able to send a copy of the dump file to nom@deliciousbrains.com

    I’ll take a closer look at it for you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Resolved] Does WP Migrate DB support export from mysql 5.0 to import to 5.5?’ is closed to new replies.
Skip to toolbar