Mysqldump:couldn ' t execute ' savepoint SP ':

1. Error message

# mysqldump--default-character-set=utf8--set-gtid-purged=on-uxx-pxx-hx.x.x.x--triggers--routines--events--singl E-transaction--databases xx >./bak_xx_$ (date +%f). sql

Mysqldump: [Warning] Using a password on the command line interface can be insecure.

Warning:a partial dump from A server which has gtids would by default include the Gtids of all transactions, even those tha T changed suppressed parts of the database. If you don ' t want to restore gtids, pass--set-gtid-purged=off. To make a complete dump, pass--all-databases--triggers--routines--events.

Mysqldump:couldn ' t execute ' savepoint SP ':

The MySQL server is running with the--transaction-write-set-extraction!=off option so it cannot execute this statement (1 290)

2. Handling Methods

> Set global Transaction_write_set_extraction=off; --reserved.

Query OK, 0 rows Affected (0.00 sec)

3. Summary

Database version 5.7.15, backup time error, according to the error message to the official website to view the relevant parameters meaning. The above parameters are reserved for future use, the default is off, can be dynamically modified, future group replication features need to use this parameter.

This article is from the "12318731" blog, please be sure to keep this source http://12328731.blog.51cto.com/12318731/1875700

Mysqldump:couldn ' t execute ' savepoint SP ':