[MySQL] Dump only triggers and stored procedures

By default mysqldump backup triggers but not stored procedures. For that you must add the --routines option.

But how do you do to dump only triggers and stored procedures ?

Like this :

mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt <database> > <dump>.sql

Leave a Reply

Your email address will not be published. Required fields are marked *