Error migrating from MySQL to MariaDB

  • Resolved towerss

    (@towerss)


    2 years, 5 months ago

    Hi guys,

    I am trying to migrate a website using the free version of your plugin, and I ran into a database error. The migration is from a Google Cloud instance with MySQL, and the target is an AWS lightsail instance with MariaDB.

    These are the error messages from Duplicator:

    1. Databse version
    The current database engine is [MariaDB 10.6.9] (Target AWS) while the host database engine was [MySQL 8.0.23] (Origin GCP)

    2. Character set and collation support
    This server’s database does not support the source site’s character set [utf8], so the installer is going to use default character [utf8mb3].

    3. Character set and collation capability
    character set and collation isn’t supported on current database. “Legacy Character set” and “Legacy Collation” will be replaced with default values.

    *Character set list
    utf8mb4 -> Pass
    utf8 -> Fail

    *Collations list
    utf8_general_ci -> Fail
    utf8mb4_0900_ai_ci -> Fail
    utf8mb4_general_ci -> Pass
    utf8mb4_unicode_520_ci -> Pass

    Any help would be much appreciated.

    • This topic was modified 2 years, 5 months ago by towerss.
Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Error migrating from MySQL to MariaDB’ is closed to new replies.