Monday, June 16, 2014

MySQL Import error

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;

No comments: