Please note: This website includes an accessibility system. Press Control-F11 to adjust the website to people with visual disabilities who are using a screen reader; Press Control-F10 to open an accessibility menu.
Popup heading
How can I backup stored procedures in my mysql database?
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