Backup Stored Procedures only on MySQL
I’ve needed to do this a few times in the past and I still needed to do it again yesterday. Hence, I decided to put it here for reference processes.
$ mysqldump --routines --no-create-info --no-data \
--no-create-db --skip-opt \
<database_name> > sp.sql
This would export just the stored procedures to the specified file (sp.sql )