Troubleshooting

Why am I getting MySQL errors when migrating my database?

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.

Our plugins

Try TeamUpdraft’s full suite of WordPress plugins.

  • UpdraftPlus

    Back up, restore and migrate your WordPress website with UpdraftPlus

  • WP-Optimize

    Speed up and optimize your WordPress website. Cache your site, clean the database and compress images

  • UpdraftCentral

    Centrally manage all your WordPress websites’ plugins, updates, backups, users, pages and posts from one location