Checking Whether log_bin_trust_function_creators Is Set to On in Both the Source and Destination Databases
MySQL
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot