Dumping MySQL Stored Procedures, Functions and Triggers

To backup ONLY the stored procedures and triggers:
mysqldump -h<host> -u<user> -p<password> --routines --no-create-info --no-data --no-create-db --skip-opt --add-drop-table <database> > outputfile.sql

Leave a Reply

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