Need to dump both routines, and any event(s) that trigger those routi…

[CompPhy]

It is not sufficient to export just the routines. You also need to export any events that are used to trigger those routines. This is especially key for those of us that have partitioned our history tables, as the routines are how we maintain the partitions.

This has been tested to work for both export and import on Zabbix 3.0.31 release. As this is a function of the mysqldump command, I would expect this to work just fine with any other Zabbix version.

[CompPhy]

Also... Is there a reason you used --skip-extended-insert on the data export? This option makes importing take FOREVER because it doesn't take advantage of bulk inserts.