How can I backup stored procedures in my mysql database?

Category: Databases

dgspurgin
Asked:
2012-07-13 7:40 pm

Hits: 828
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.

OTHER ANSWERS

0

Scott
2012-07-13 8:25 pm
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?

Support Center Login

Latest Questions

If you need some help, submit your question to our Community!
We guarantee a response within 60 minutes (8am - 9pm EST, Monday - Friday)
Ask a Question!
Recent Questions
  1. Connecting email to gmail?
  2. Can I have Oscommerce installed on my site's server?
  3. I'm having trouble publishing with iWeb
Browse other questions

Need more Help?

Search

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: support@InMotionHosting.com
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!