How to dump stored procedures / functions
Add the --routines flag to dump MySQL database stored procedures and functions.
Stored procedures/functions are not dumped by default (unless you choose the back up all databases option).
To dump stored procedures/functions on a single MySQL database, you need a special dump flag --routines
to your backup.
- Go to the backup page
- Click on Advanced
- Under the Custom Dump Flags section (only visible if your backup type supports it)
- Enter
--routines
- Click Save
![](https://www.notion.so/image/https%3A%2F%2Fdownloads.intercomcdn.com%2Fi%2Fo%2F634994351%2F169896830b503c6624cdde60%2FSimpleBackups-Mysql-Stored-Procedures-Fucntions-Dump.png?table=block&id=9f2fac44-b7c4-420e-86bb-2fd75a50a140&cache=v2)
Did this answer your question?
😞
😐
🤩
Last updated on August 4, 2021