If you got this error:

ERROR 1419 (HY000) at line 1140: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

The error message is pretty clear. Binary logging needs to be enabled in order to restore the functions. There are two ways for doing this:

• Execute the following command into the MySQL console:
  
  SET GLOBAL log_bin_trust_function_creators = 1;

  1	SET GLOBAL log_bin_trust_function_creators = 1;

• Add the line to the mysql.ini configuration file
  
  log_bin_trust_function_creators = 1

  1	log_bin_trust_function_creators = 1

Source : Logikdev