mysql 只导出存储过程,MySQL-mysqldump-例程仅导出1个存储过程（按名称），而不是每个例程...

So we have a lot of routines that come out from exporting. We often need to get these out in CLI, make changes, and bring them back in. Yes, some of these are managed by different folks and a better change control is required, but for now this is the situation.

If I do:

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

then great, I have 200 functions. I need to go through a file to find just the one or set I want.

Is there anyway to mysqldump routines that I want like there is for tables?

解决方案

To answer your exact question: no.

But this will probably give you what you want.

Take a look at SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION:

Those commands allow you to dump the code for one routine at a time.