Error migrating from MySQL to MariaDB

  • Resolved towerss

    (@towerss)


    1 year, 6 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 1 year, 6 months ago by towerss.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Cory Lamle

    (@corylamleorg)

    1 year, 6 months ago

    Hey @towerss

    Thanks for the feedback! There are a few items in the FAQ that may provide a solution to this issue, this one may get you going.

    – How to fix database write issues?
    – https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-103-q

    See Issue C

    If you would like to submit a support ticket for this issue we can have a closer look at your setup. Please provide a link to this forum thread when submitting the ticket.

    Hope this helps~

    Thread Starter towerss

    (@towerss)

    1 year, 6 months ago

    @corylamleorg
    Thank you for taking the time to reply. This is the first time I have had any issues with this awesome plugin.

    I will open the support ticket.

    Cory Lamle

    (@corylamleorg)

    1 year, 6 months ago

    ok thanks for the update!

    markyoungiw

    (@markyoungiw)

    1 year ago

    I was wondering if a solution was found to this error, as I have just been tasked with the same issue. A friend who has used Duplicator to migrate a wordpress site, but the new server uses Maria DB and they are getting exactly the same errors.

    Kind Regards

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Error migrating from MySQL to MariaDB’ is closed to new replies.