Checking Whether log_bin_trust_function_creators Is Set to On in Both the Source and Destination Databases
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
The destination database does not support user-defined functions.
Handling Suggestion
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.
- Item to Be Confirmed
- Handling Suggestion