Our Tier 2 team advises that to ensure the backup gets the stored procedures you will want to run the following command:
mysqldump --routines
This lets the backup grab the procedures, triggers, etc as the standard mysqldump command does not back them up.
I hope this answers your question. If you have any more questions or information specific to the issue please leave a comment below so we can further assist you.
Our Tier 2 team advises that to ensure the backup gets the stored procedures you will want to run the following command:
mysqldump --routines
This lets the backup grab the procedures, triggers, etc as the standard mysqldump command does not back them up.
I hope this answers your question. If you have any more questions or information specific to the issue please leave a comment below so we can further assist you.
Best Regards,
Scott M