How can I backup stored procedures in my mysql database?
I know how to backup tables... but I have MANY stored procedures that I need to backup too. How do I do that?
Our Tier 2 team advises that to ensure the backup gets the stored procedures you will want to run the following command:
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.
Like this Question? Tweet
Related ArticlesHow to View MariaDB databases in SSH
MariaDB - How to Change Database in SSH
How to Delete a Database with MariaDB
How to Create a Database with MariaDB
How to Install Percona DB Server