Backup table data today encountered an error code:1197 multi-statement TRANSACTION required more THAN ' max_binlog_cache_size ' bytes of STORAGE

Backup table data today encountered an error code:1197 multi-statement TRANSACTION required more THAN ' max_binlog_cache_size ' bytes of STORAGE

Version: mysql5.6.35

System: centos6.5

Here is the BACKUP statement

CREATE TABLE  as SELECT *  from

1197 Multi - TRANSACTION ' max_binlog_cache_size '  of  and try Again

Internet search, found that the max_binlog_cache_size set is not large enough reason

to the InnoDB engine
Because InnoDB is transactional, the entire operation of the load file is treated as a transaction,
Breaking the load operation halfway will result in a rollback.
Some parameters related to this:
Max_binlog_cache_size----The maximum cache memory size that can be used.
When executing a multi-statement transaction, if the max_binlog_cache_size is not large enough,
The system may report a "multi-statement
Transaction required more than ' max_binlog_cache_size ' bytes of storage ' error.
Note: For load data, if the file size of load is 512M, during load execution,
All generated binlog are written to binlog_cache_size until the end of the load data operation.
Finally, a binary log, such as mysql-bin.0000008, is written by Binlog_cache_size.
Therefore, the size of this parameter must be greater than the size of the file to load, or the size of the current transaction operation to be made.

Solve the problem of changing the big max_binlog_cache_size

SET = 20971520

Backup table data today encountered an error code:1197 multi-statement TRANSACTION required more THAN ' max_binlog_cache_size ' bytes of STORAGE