Troubleshooting the "Error 1419" error

Issue

When importing a database on Acquia environment, you might face this error message: 

ERROR 1419 (HY000) at line XXXX: 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)

As explained in the documentation "Problems using MySQL stored procedures, triggers, and functions", Acquia Cloud Enterprise has disabled the use of stored procedures, triggers, or MySQL functions in all environments

Acquia recommends you don’t use stored procedures, triggers, or functions in your Drupal database on Acquia Cloud. Using stored procedures, triggers or functions will break replication, backups, and even the database copy process. To avoid the issue, Acquia Cloud Enterprise has disabled the use of stored procedures, triggers, and MySQL functions in all environments.

Resolution

You need to remove the stored procedures and the triggers from the dump file.