We are currently trying to restore our phone system data from a backup to a new installation.
The phone system is a Shortel system which runs on SQL.
There is a sample script in the MySQL folder called RestoreConfig, which relies on a file being located in the c:\ called shorewareConfigDump.sql.
This file is in the c:\ and I have gone to run the script and it comes back with the following error code (see below).
The backup was taken from a Server 2003 machine and is being restored to a Server 2008 machine.
A quick google indicateds “SET GLOBAL log_bin_trust_routine_crea
tors=1; “ should resolve but I don't know how to implement it.
Any help would be appreciated.
C:\Program Files (x86)\Shoreline Communications\ShoreWare Server\MySQL\MySQL Ser
ERROR 1418 (HY000) at line 8083: 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)