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)
- Click Save