Issue
When importing a database on Acquia environment, you might face this error message:
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.