Import MySQL data failed with error 1839

Asked Apr 22 '15 at 14:47

Active Apr 27 '15 at 03:34

Viewed 1,727 times

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.

edited Apr 27 '15 at 03:34

Rick James

135,179
13
127
222

asked Apr 22 '15 at 14:47

JAVAC

1,230
3
17
38

Should this be in "superuser"? – a coder Apr 27 '15 at 03:38
ok i do create their i am not sure i can move from this site to that site directly.. for this time i am copy paste :) – JAVAC Apr 27 '15 at 21:19
I mean shouldn't this be posted on stack overflows "superuser" site. – a coder Apr 27 '15 at 22:06
2

NO MAN I DID GOOGLE SEARCH IT DIDN'T COME UP – JAVAC Apr 27 '15 at 22:13
What I mean is http://superuser.com/ I think it's all server side issues. – a coder Apr 27 '15 at 22:36
found solultion here https://stackoverflow.com/a/38129690/944593 – shareef Aug 22 '21 at 12:11
Does this answer your question? [Cloud sql database export import issue](https://stackoverflow.com/questions/38123263/cloud-sql-database-export-import-issue) – shareef Aug 22 '21 at 12:11

Import MySQL data failed with error 1839

0 Answers0