Mysqldump --- difference between 5.5 and 5.6-优快云博客

本文详细介绍了MySQL导出工具mysqldump的两个版本（5.5.20和5.6.10），并阐述了其关键参数及其用途，包括但不限于--no-defaults、--login-path、--add-drop-trigger、--bind-address和--set-gtid-purged等选项。

5.5.20	5.6.10
mysqldump Ver 10.13 Distrib 5.5.20, for Linux (x86_64) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.	mysqldump Ver 10.13 Distrib 5.6.10, for Linux (x86_64) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
--no-defaults Don't read default options from any option file.	--no-defaults Don't read default options from any option file, except for login file.
	--defaults-group-suffix=# Also read groups with concat(group, suffix)
	--login-path=# Read this path from the login file.
	--add-drop-trigger Add a DROP TRIGGER before each create.
	--bind-address=name IP address to bind to.
	--set-gtid-purged[=name] Add 'SET @@GLOBAL.GTID_PURGED' to the output. Possible values for this option are ON, OFF and AUTO. If ON is used and GTIDs are not enabled on the server, an error is generated. If OFF is used, this option does nothing. If AUTO is used and GTIDs are enabled on the server, 'SET @@GLOBAL.GTID_PURGED' is added to the output. If GTIDs are disabled, AUTO does nothing. Default is AUTO.
	--ssl-crl=name Certificate revocation list (implies --ssl).
	--ssl-crlpath=name Certificate revocation list path (implies --ssl).