WordPress.org

Forums

WP Migrate DB
[resolved] Does WP Migrate DB support export from mysql 5.0 to import to 5.5? (3 posts)

  1. FeralReason
    Member
    Posted 1 year ago #

    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/

  2. FeralReason
    Member
    Posted 1 year ago #

    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 ? ...

  3. Chris Aprea
    Member
    Plugin Author

    Posted 1 year ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WP Migrate DB
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic