CODEWITHSUNDEEP
importmysqlgtid
JAVAC
JAVAC

Reputation: 1270

Import MySQL data failed with error 1839

I have master slave setup of MySQL with GTID configured. I took back data backup of master and importing it to individual Test server. It is failing to import as

ERROR 1839 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ON

I tried with --set-gtid-purged=OFF and AUTO, but no luck.

Upvotes: 4

Views: 2015

Answers (0)

Related Questions