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

mysql database gtid
b0uncyfr0 picture b0uncyfr0 · Oct 30, 2017 · Viewed 19k times · Source

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.

Answer

Mark Bucknell picture Mark Bucknell · Jan 10, 2018

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.

Related questions

'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More
How do I quickly rename a MySQL database (change schema name)?

The MySQL manual at MySQL covers this. Usually I just dump the database and reimport it with a new name. This is not an option for very big databases. Apparently RENAME {DATABASE | SCHEMA} db_name TO new_db_name; does …

Read More
MySQL Error: : 'Access denied for user 'root'@'localhost'

$ ./mysqladmin -u root -p 'redacted' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' How can I fix this?

Read More