mysqldump and stored procedures
Posted by Prem on January 4th, 2010 filed in mysqlToday I found out something interesting. Â Well, probably its only for me. Â Mysqldump does not dump the stored procedures by default. Â Default option for mysql dump is to exclude stored procedures. Â Where as triggers are include by default.
So, in order to include stored procedures, you have to use option –routines. So, the command goes like:
mysqldump [other options of mysql dump] –routines > out_filename
Leave a Comment
You must be logged in to post a comment.