备份存储过程mysql,如何在MySQL中备份存储过程

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?

解决方案

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 #or

mysqldump --routines

Just the stored procedures:

mysqldump -n -t -d -R #or

mysqldump --no-create-db --no-create-info --no-data --routines

Does that help?