ApsaraDB for OceanBase:Backup error of mysqldump

mysqldump, which is native to MySQL, is usually used for data backup in MySQL mode of ApsaraDB for OceanBase. The error shown in the following figure will be reported in this case. This is because ApsaraDB for OceanBase does not support triggers in MySQL mode.

Solution:

Add the --triggers parameter, and set it to false.

mysqldump -h xxx  -P 3306 -u xxx -p  xxx --triggers=false