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.
I want to do exactly what you are looking for but in AWS RDS. so for your case what you must do is:
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