I have workbench 5.2.47
I want to export my database via workbench, but I getting an error:
2:49:32 Dumping @@@@ (logins)
Running: "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe" --defaults-extra-file="@@@@.cnf" --user=root --max_allowed_packet=1G --host=localhost --port=3306 --default-character-set=utf8 --no-data "@@@" "logins"
mysqldump: Couldn't execute 'SELECT @@GTID_MODE': Unknown system variable 'GTID_MODE' (1193)
Of some workarround, I realized that for workbench version the new 'GT ID_MODE' doesn't exist (from mysql 5.6), so there is need to add to command line: –-set-gtid-purged=OFF
A problem - I don't know how to change the command line, since *.cnf file is located on temporary folder (I persume it is built when running export via workbench).
Also, it would be better if there is any declaration on some ini file of workbench, that make "gtid-purged=OFF".
Is there also a hotfix for workbench for that?
June 22, 2013 03:22PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.