How to backup Stored Procedures in MySQL?

Type this on SSH / command line

mysqldump -u username -p database_name --routines > /home/asim/database_backup_with_procedures.sql

Type in the password when prompted.

P.S. Replace username with actual mysql username and database_name with actual database name.

2 thoughts on “How to backup Stored Procedures in MySQL?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.