InMotion Hosting Support Center

How can I backup stored procedures in my mysql database?

Category: Databases

2012-07-13 3:40 pm EST

Hits: 2,558
I know how to backup tables... but I have MANY stored procedures that I need to backup too. How do I do that?

You must login before you can ask a follow up question.

You must login before you can submit an answer.



43,761 Points
2012-07-13 4:25 pm EST
Hello dgspurin,

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

You must login before you can post a comment about this answer.

Like this Question?

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!