Q: How to set --set-gtid-purged=OFF as a default Export parameter in Mysql workbench?
Solution 1
I want to do exactly what you are looking for but in AWS RDS. so for your case what you must do is:
Solution
-
Update config file Update
/etc/my.cnf
and add[mysqldump] set-gtid-purged=OFF
-
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
-
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 enable/disable GTID (Global Transaction Ids)
MySQL extra options during DUMP
Solution 2
I've found a temporary solution for this on Linux/Ubuntu
- Open /usr/lib/mysql-workbench/modules/wb_admin_export.py
- Search for "--set-gtid-purged=OFF"
- Delete or comment that line (#) and the if statement above it.
- 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.
b0uncyfr0
Updated on June 18, 2022Comments
-
b0uncyfr0 almost 2 years
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.