Help Center> Data Replication Service> User Guide (ME-Abu Dhabi Region)> Troubleshooting> Solutions to Failed Check Items> Database Parameters> Checking Whether log_bin_trust_function_creators Is Set to On in Both the Source and Destination Databases
Updated on 2023-02-02 GMT+08:00

Checking Whether log_bin_trust_function_creators Is Set to On in Both the Source and Destination Databases

MySQL

Table 1 Checking whether log_bin_trust_function_creators is set to on in both the source and destination databases

Check Item

Whether log_bin_trust_function_creators is set to on in both the source and destination databases

Description

During the out-of-cloud migration from MySQL to MySQL, the log_bin_trust_function_creators value of the source database must be the same as that of the destination database. If the source database supports user-defined functions (UDFs) but the destination database does not, change the log_bin_trust_function_creators=off parameter of the destination database to log_bin_trust_function_creators=on. If the parameters of the source and destination are different, the migration may fail.

Item to Be Confirmed and Handling Suggestion

Item to be confirmed: The destination database does not support custom functions.

Handling suggestions: In the my.cnf file of the destination database, check whether log_bin_trust_function_creators=on exists. If it does not exist, add log_bin_trust_function_creators=on and restart the database for the modification to take effect.