The Utf8mb4_unicode_520_ci error

Hey @bg17aw,

Thanks for the feedback! The only work-a-rounds we have at the moment are in this FAQ.

? ? – What is Compatibility mode & ‘Unknown collation’ errors?
? ? – https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-110-q

The underlying issue with changing the collation type from one server to the next is that you can cause data loss. In order to maintain the highest integrity of the data its best to keep the collations the same during a move which means trying to have mysql server versions close together between the build and install servers.

Hope that helps~

Let me know if any of them help~

Thanks for your answer,

Not sure if there would be data loss between Utf8mb4_unicode_520_ci and Utf8mb4_unicode_ci though.

Personally, I just open the database.sql file from the Duplicator archive and search/replaced all occurrences of Utf8mb4_unicode_520_ci with Utf8mb4_unicode_ci.

Although I understand your concern, but I think it would help a lot of users (looking at the huge number of Google Search hits for this issue) if you would implement a checkbox somewhere in the “Advanced” options, and display a warning about possible data loss. 99.9% of the cases there would be no data loss, the user was warned etc.

Thanks

I’ll add the task to the backlog to see if we can come up with a solution like that.

Thanks for the feedback!