MariaDB: dump one database with routines/triggers
For small databases, do not forget routines, triggers, and events.
mariadb-dump --single-transaction --routines --triggers --events appdb > appdb.sql
grep -E "CREATE (TRIGGER|PROCEDURE|EVENT)" appdb.sql | head
Verify the result
The dump should contain these objects when they exist in the database.