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.

  1. Go to the backup page
  1. Click on Advanced
  1. Under the Custom Dump Flags section (only visible if your backup type supports it)
  1. Enter --routines
  1. Click Save
Did this answer your question?

Last updated on August 4, 2021