How to take the dump of Stored procedures, Functions & Triggers.

We can take the backup of the Stored Procedures, Functions and Triggers as below.

# mysqldump --routines > outputfile.sql

#mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt datbasename > /backups/db_bakup.sql

# mysql databasename < /backups/db_bakup.sql