I want to back up stored procedure in mysql

Question

I use mysqldump with mysql 5.0 and I back it up every day, but do not understand the method that only stored procedure backs up.

How can I back it up?

Answer 1

I'm not sure whether you're asking to back up stored procedures as well as everything else, or just the stored procedures on their own...

Stored procedured in dump with everything else:

mysqldump -r <dbname> #or
mysqldump --routines <dbname>

Just the stored procedures:

mysqldump -n -t -d -r <dbname> #or
mysqldump --no-create-db --no-create-info --no-data --routines <dbname>

Does that help?

Answer 2

yes, this answer is very uselful