开发者

Mysqldump specific stored procedures/functions but not others

I know that mysqldump does not include stored procedures/functions by default and that you have to use the -routines to include them. I am also aware that to dump just the functions and stored procedures you would use the following.

mysqldump --skip-triggers --routines --no-cre开发者_运维问答ate-info --no-data --no-create-db --skip-opt your_db_name > your_output_file.sql

The issue I have is how dump specific stored procedures/functions and not all of them?

So this is what I have tried --ignore-table=your_db_name.FUNCTION1 and even your_db_name FUNCTION1 to output just that function. None of these have worked.

Thanks in advance.


(Adding a link here in order to remove this question from the "Unanswered" feed.)

This is a duplicate question. See the original for the answer:

MySQL - mysqldump --routines to only export 1 stored procedure (by name) and not every routine

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜