Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Q: How to set --set-gtid-purged=OFF as a default Export parameter in Mysql workbench?

Ive recently been playing with Mysql Workbench and the Export function has one little annoying feature that is not needed (by me of course). The set-gtid-purged function is set to AUTO by default in the GUI and it seems everytime you want to export without this parameter - you have to change it to OFF in Data Exports - Advanced options. To make it worse - the setting is not remembered.

Wanted to check if anyone has found a way to set it to OFF permanently for every DB/conenction i make?

I even checked the wb_options.xml file and the feature is set to OFF but this doesn't seem to stop it for some reason.

<value type="string" key="wb.admin.export.option:set-gtid-purged">OFF</value>

Thanks.

like image 863
b0uncyfr0 Avatar asked Oct 30 '17 17:10

b0uncyfr0


People also ask

How do you set the set Gtid purged off?

If you don't want to restore GTIDs, pass –set-gtid-purged=OFF. To make a complete dump, pass –all-databases –triggers –routines –events. Whenever I dump the database manually I always set that flag to OFF.

What is set Gtid purged in MySQL?

Set the --set-gtid-purged option to AUTO (the default) or ON , to include information about executed transactions in the dump. Then use the mysql client to import the dump file on the target server.


2 Answers

I want to do exactly what you are looking for but in AWS RDS. so for your case what you must do is:

Solution

  1. Update config file Update /etc/my.cnf and add

    [mysqldump] set-gtid-purged=OFF

  2. No need to restart. If you dont have access to that .cnf file then update the update directadmin.conf with the following instruction:

    extra_mysqldump_options=--set-gtid-purged=OFF

  3. Is possible to run the following command in shell to achieve point number 2:

    echo "extra_mysqldump_options=--set-gtid-purged=OFF" >> /usr/local/directadmin/conf/directadmin.conf service directadmin restart

Official and useful references

MySQL Dump

MySQL enable/disable GTID (Global Transaction Ids)

MySQL extra options during DUMP

like image 83
Andre Leon Rangel Avatar answered Oct 26 '22 23:10

Andre Leon Rangel


I've found a temporary solution for this on Linux/Ubuntu

  1. Open /usr/lib/mysql-workbench/modules/wb_admin_export.py
  2. Search for "--set-gtid-purged=OFF"
  3. Delete or comment that line (#) and the if statement above it.
  4. Restart MySQL Workbench

Using windows, the path to the file will vary and I will update my answer if someone can give it to me.

like image 21
Mark Bucknell Avatar answered Oct 26 '22 23:10

Mark Bucknell