Export mysql database when facing GTID_PURGED error

55 views

                  mysqldump --result-file="OUTPUT-FILE.sql" "SCHEMA-NAME" --skip-add-locks --skip-extended-insert --skip-add-drop-table --skip-disable-keys --skip-lock-tables --skip-create-options --no-tablespaces --set-gtid-purged=OFF

I was facing ERROR 3546 (HY000): @@GLOBAL.GTID_PURGED cannot be changed when restoring previously exported mysql database. The solution is to add --set-gtid-purged=OFF setting when exporting.

mysql

0 Comments

Follow comments

More snips

Move one record to trash using Rails concern Fetching notifications on click while showing pulsating placeholders with htmx and hyperscript on Rails Post like / unlike with htmx on Rails - partial replacement, server-side rendering Concern class with model dependent variations

RSS

pmihalcin

More snips

Export mysql database when facing GTID_PURGED error

0 Comments

More snips