SQL Statements Such as SET @@SESSION.SQL_LOG_BIN Displayed After You Run mysqldump

Scenario

When you run mysqldump on a newly purchased Huawei Cloud database, the following code is displayed.

Figure 1 Code

Fault Analysis

The parameter gtid-mode is set to ON.

If GTID is enabled for a database, using mysqldump for backup or dump operations will include all GTIDs in the entire database, even if you are not performing a full backup of all MySQL databases.

Solution

When TaurusDB databases are exported for backup and restoration, check whether GTID is enabled.

If GTID is enabled, add –set-gtid-purged=OFF to the mysqldump command during data dump.