UpdraftPlus
Back up, restore and migrate your WordPress website with UpdraftPlus
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
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.
Try TeamUpdraft’s full suite of WordPress plugins.
Back up, restore and migrate your WordPress website with UpdraftPlus
Speed up and optimize your WordPress website. Cache your site, clean the database and compress images
Secure your WordPress website. Comprehensive, feature rich and easy to use
Centrally manage all your WordPress websites’ plugins, updates, backups, users, pages and posts from one location