5

Whenever I add --set-gtid-purged=OFF, it still adds @@SESSION.SQL_LOG_BIN=0; to the output.

According to the documentation, shouldn't it get removed?

--set-gtid-purged=OFF: SET @@SESSION.SQL_LOG_BIN=0; is not added to the output.

Dump created by MySQL pump utility, version: 8.0.16, Win64 (x86_64)

SET @@SESSION.SQL_LOG_BIN= 0;

Is this correct behavior for this tool?

Watson
  • 155
  • 1
  • 5

1 Answers1

1

There is a bug report open for this: https://bugs.mysql.com/bug.php?id=91915

Describing exactly the issue you are facing.

mysqlpump with --set-gtid-purged=off, still has "SET @@SESSION.SQL_LOG_BIN=0" in output.

As a "temporary" fix (since the bug report is open since 2018) I simply replaced the line with an empty line.

sed -i 's/SET @@SESSION.SQL_LOG_BIN= 0;//' "${DB}.sql"
Bram
  • 111
  • 5