SQL Problem with Shortel Migration

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_creators=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
ver 5.0\Examples>restoreconfig.bat
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)

Open in new window

Who is Participating?
lemonvilleConnect With a Mentor Author Commented:
This has to be done VIA the MySQL command line. (found in the MySQL\bin folder)
Once set the issue is resolved.

To set the variable you can use the command prompt such as: -

set SET GLOBAL log_bin_trust_routine_creators=1

This will create and variable called "GLOBAL log_bin_trust_routine_creators" with a value of 1 which you can query by entering SET at the command prompt or echo %GLOBAL log_bin_trust_routine_creators% this variable is only available for the command prompt session you are in.

You could add it via My Computer > Properties > Advanced > Environment Variables > New. This sets it permanently.

lemonvilleAuthor Commented:
Doing the echo command just brings back %GLOBAL log_bin_trust_routine_creators%
Which I would assume means the variable hasn't been set as it should come back with a value of 1

Does the server need a restart after setting the variable?
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

lemonvilleAuthor Commented:
I think this command is supposed to be done in some sort of SQL command line, as per:

"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.

If binary logging is not enabled, log_bin_trust_function_creators does not apply. SUPER is not required for function creation unless, as described previously, the DEFINER value in the function definition requires it."
lemonvilleAuthor Commented:
After a restart, the system variable was set.

However - this system variable has not helped and the same error is occurring.
I'd suggest you delete this question and post again for someone with more exp with mySQL- sorry
lemonvilleAuthor Commented:
No acceptable answers, ended up doing my own research
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.