Why MySQL errors occur during database migration

Sometimes your database backup can produce errors which prevent you from completing your site migration.

An example of this can occur when your source site is using a different version of MySQL to your destination site.

Here’s an example error:

0001.543 () An error (1) occurred: @@GLOBAL.GTID_PURGED cannot be changed: the new value must be a superset of the old value – SQL query was (type=0): SET @@GLOBAL.GTID_PURGED=’d7059570-cdd3-11eb-a823-42010a9c0003:1-43961096′;

and

Requested table character set (utf8) is not present

How do I fix it?

Ensure both the source and destination sites are running the same version of MySQL.  After performing the migration you can then upgrade MySQL to the latest version.