MySQL - mysqldump --routines to only export 1 stored procedure (by name) and not every routine
- by Joe Stein
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???