Posted on April 14, 2022
Running a regular
drush sql-dump command on a Drupal project that uses a managed database will generate a dump file with GTID data. Because importing a dump file with GTID data can be problematic, it would be ideal to generate dump files that don't retain the GTID data.
Here is how you generate a dump file without GTID data using Drush:
drush sql-dump --result-file=[dump file destination] --extra-dump="--set-gtid-purged=OFF"