exporting database
Posted by: Eitan Mizrahi
Date: June 22, 2013 03:22PM

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?

Thanks :)

Options: ReplyQuote

Written By
exporting database
June 22, 2013 03:22PM
June 22, 2013 05:17PM

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.