MySQL 8.0.22 to MariaDB 10.5.8

Hey @tobyraistrick

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

Cheers~

Thanks, ticket #E4S-M1N-9Y3X created. Also included screenshots there.

Thanks~

Hi,

I have exactly the same problem. I try to migrate site from localhost with MySQL version 8.0.22-0ubuntu0.20.04.3 for Linux to MariaDb 10.3.27.
As in case of Toby utf8mb4_unicode_520_ci passed and utf8mb4_0900_ai_ci failed.
I also used “Legacy” option but nothing changed.

Thanks in advance.
Regards

Prashant from their support team was able to help me with this single transfer by sending me back a modified version of my archive file, and then it worked when I enabled the Legacy option.
However, I have many other sites to migrate in this way, so I’m trying to find out what he modified inside my archive, so that I can both apply it to my future MySQL > MariaDB migrations, but also post back here with the solution for others to use.
I haven’t had time to compare the DB exports just yet, but it may have been something in there that was modified.
It would also be nice to see the plugin updated to address or correct this issue or bug (if it is indeeed a bug or change that can be made to support these MySQL to MariaDB migrations), so that future exported archives don’t have this same issue.

@corylamleorg, perhaps you could chase up on ticket E4S-M1N-9Y3X I created? I haven’t heard anything since last Thursday. Thanks!

Please could you also not mark this as resolved until the fix has been found and published?
I did not mark this as resolved.

Thanks,
Toby

Hey @tobyraistrick,

Sorry for any delay. With the free version, we are not always able to get to customers right away. We’ll have someone look at your ticket when they are able.

Thanks~

Hello,
was the issue solved?

I’ve been sent an internal, unreleased build of the plugin to test, which apparently includes a fix to my issue.
I’ll be testing this before the end of this week and reporting back to the ticket if it works.
I don’t know if I’m allowed to share it publicly, so I reccomend raising a ticket yourself and asking for a copy to test with.

Just tested on another site and the unreleased internal build of the plugin I was given worked sucesfully after selecting “Legacy”.
I’ve also asked in the ticket if I’m authorised to share this internal build on the public forumns. If yes, I’ll share it here.

Hello,

can you show me your fix or aren’t you authorized?

Hi @tobyraistrick
have you authorized to share the internal build?

im also having this issue rightnow, cannot pass through Test Database because of utf8mb4_0900_ai_ci: Fail

Unfortunately I was advised against sharing the internal development build I received. The comment on the internal ticket from last month said that they were planning on getting the fix released in the next version of the plugin, which was due to come out at the end of last month. It looks like they missed this since the latest version is still last year.

If you want your own copy of the plugin, I suggest you raise a ticket with their internal support like I did, and refrence this www.remarpro.com support thread along with my previous ticket (#E4S-M1N-9Y3X).
https://snapcreek.com/ticket