MySQL 5 has introduced some new interesting features, like stored procedures and triggers. I will show in this small post how we can backup and restore these components using mysqldump. mysqldump will backup by default all the triggers but NOT the stored procedures/functions. There are 2 mysqldump parameters that control this behavior: --routines - FALSE by default --triggers - TRUE by default This means that if you want to include in an existing backup script also the triggers and stored procedures you only need to add the --routines command line parameter:
