Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > mysqldump: Couldn’t execute ‘SELECT @@GTID_MODE..._MySQL

mysqldump: Couldn’t execute ‘SELECT @@GTID_MODE..._MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-01 13:34:44
Original
1190 people have browsed it

mysqldump

bitsCN.com

mysqldump: Couldn’t execute ‘SELECT @@GTID_MODE...

 

在使用MySQL 5.6的mysqldump备份5.6之前版本的MySQL时会遇到异常

 

1

mysqldump: Couldn't execute 'SELECT @@GTID_MODE': Unknown system variable 'GTID_MODE' (1193)

 

造成此错误的原因是因为5.6引入了Global Transaction Identifiers (GTIDs) 。GTIDs可以让主从结构复制的跟踪和比较变得简单。mysqldump会试图查询这个系统变量，但这个变量在5.6之前的版本中不存在，所以产生错误。的方法很简单。在mysqldump后加上–set-gtid-purged=OFF命令。

 

1

mysqldump -h dbHost -u dbuser dbName --set-gtid-purged=OFF

 

bitsCN.com
Previous article：mysql存储过程：复制表A的某列到表B中去_MySQL Next article：mysql innodb行锁解锁后出现1213死表现象Deadlock found when解_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2825
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2945
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
2470
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
2394
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
2444
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template