Support » Plugin: All-in-One WP Migration » Database migration fails

  • Resolved Frank P. Walentynowicz

    (@frankpw)


    If export is done on server with MySql 5.5.3+ the database cannot be imported to server with MySql version lower than 5.5.3. The genenated SQL script contains references to character set utf8mb4 and collation utf8mb4_unicode_ci unknown to MySql version lower than 5.5.3.

    This problem can be solved by adding ‘MySql compatibility mode‘ dropdown to export screen with values ‘NONE‘ and ‘MYSQL40‘. In case described above ‘MYSQL40‘ should be selected. In ‘MYSQL40‘ mode plugin should strip all references to character set and collation. This by default will use ‘utf8’ and ‘utf8_general_ci’ respectively.

    https://wordpress.org/plugins/all-in-one-wp-migration/

Viewing 3 replies - 1 through 3 (of 3 total)
  • midlandsonlinemedia

    (@midlandsonlinemedia)

    Hi Frank

    Is this the reason so many people are unable to login after they upload their site?

    Thread Starter Frank P. Walentynowicz

    (@frankpw)

    If the backup is created on server with Mysql 5.5.3+ and restore is attempted on server with Mysql version lower than 5.5.3 then yes.

    Plugin Author Borislav Angelov

    (@bangelov)

    Hi

    Thanks a lot for your feedback!

    I’ve created a task in our backlog and this one will be fixed in the upcoming version.

    Best Regards,
    Bobby

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database migration fails’ is closed to new replies.