ERROR HY000: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
mysql> SET GLOBAL log_bin_trust_function_creators = 1;
Note: You can also set this variable by using the --log-bin-trust-function-creators=1 option when starting the server.
cmd> mysql --default-character-set=utf8 -u root -p DB_NAME < 2014-06-16_DB_NAME.sql
After imported, run this query to set it back:
mysql> SET GLOBAL log_bin_trust_function_creators = 0;
Monday, June 16, 2014
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment