How to backup Stored Procedures in MySQL?

Home / How to / 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 Comments

Leave a Reply