Skip to main content

How to export database from Digital Ocean using Drush

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"