Mysqldump specific stored procedures / functions, but not others

I know that mysqldump does not include default stored procedures / functions and that you must use -routines to enable them. I also know that you would use the following to reset only functions and stored procedures.

mysqldump --skip-triggers --routines --no-create-info --no-data --no-create-db --skip-opt your_db_name > your_output_file.sql

I have a question on how to dump specific stored procedures / functions, and not all of them?

So this is what I tried - ignore-table = your_db_name.FUNCTION1 and even your_db_name FUNCTION1 , to output exactly this function. None of them worked.

Thanks in advance.

+3
source share
1 answer
0

Source: https://habr.com/ru/post/1776430/


All Articles