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.
source
share