From c172f69e15a9dbe262034445b7db4190e7c03849 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Dani=C3=ABl=20van=20Eeden?= Date: Sat, 3 Sep 2016 11:35:23 +0200 Subject: [PATCH] Don't dump mysql.gtid_executed https://bugs.mysql.com/bug.php?id=82848 Otherwise this will overwrite the value which is set with SET @@GLOBAL.GTID_PURGED=... And this could cause a server to lose the GTID position after a restart --- client/mysqldump.c | 3 +++ 1 file changed, 3 insertions(+) diff --git a/client/mysqldump.c b/client/mysqldump.c index 45506bc..37b81be 100644 --- a/client/mysqldump.c +++ b/client/mysqldump.c @@ -1009,6 +1009,9 @@ static int get_options(int *argc, char ***argv) "mysql.apply_status", MYF(MY_WME))) || my_hash_insert(&ignore_table, (uchar*) my_strdup(PSI_NOT_INSTRUMENTED, + "mysql.gtid_executed", MYF(MY_WME))) || + my_hash_insert(&ignore_table, + (uchar*) my_strdup(PSI_NOT_INSTRUMENTED, "mysql.schema", MYF(MY_WME))) || my_hash_insert(&ignore_table, (uchar*) my_strdup(PSI_NOT_INSTRUMENTED, -- 2.7.4