This function has none of the DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enable (you *might* want to use the less safe log_bin_trust_function_creators variable)

This function has none of the DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enable (you might want to use the less safe log_bin_trust_function_creators variable)

Posted on August 23, 2011 by chanmingman

If your MySQL database has a binary field in it and you hit the above error while restoring from the dump like the one below.

Issue the follow command in MySQL console.

SET GLOBAL log_bin_trust_function_creators = 1;

About these ads

About chanmingman

Ming Man is a senior manager for a development company. With 20 years of experience in the IT field, he has developed system using Clipper, COBOL, VB5, VB6, VB.NET, Java and C #. He is familiar with the N-Tier design of business application and is also an expert with database experience in MS SQL, Oracle and AS 400.

View all posts by chanmingman →

This entry was posted in Community and tagged log_bin_trust_function_creators, This function has none of the DETERMINISTIC. Bookmark the permalink.

One Response to This function has none of the DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enable (you might* want to use the less safe log_bin_trust_function_creators variable)*

Wilinton Aguirre Ortiz says:

February 18, 2013 at 10:09 am

To relax the preceding conditions on function creation (that you must have the SUPER privilege and that a function must be declared deterministic or to not modify data), set the global log_bin_trust_function_creators system variable to 1. By default, this variable has a value of 0, but
you can change it like this:

mysql> SET GLOBAL log_bin_trust_function_creators = 1;
You can also set this variable by using the –log-bin-trust-function-creators=1 option when starting the server.

http://dev.mysql.com/doc/refman/5.0/en/stored-programs-logging.html

Reply

Follow “Chanmingman's Blog”

%d bloggers like this: