mysql移植问题

同事在导入mysql文件时发生错误

ERROR 1418 (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_creatorsvariable)

稍微查了一下，用
mysql> SET GLOBAL log_bin_trust_function_creators = 1;

命令就可以解决了

具体原因都是英文的，也没时间看
先记录下网址，以后再研究吧

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