Skip to main content
All CollectionsHow Tos / Using SimpleBackupsDatabase Backup
How to dump stored procedures/functions on MySQL
How to dump stored procedures/functions on MySQL

Add the --routines flag to dump MySQL database stored procedures and functions.

Islam Essam avatar
Written by Islam Essam
Updated over 2 years ago

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

  2. Click on Advanced

  3. Under the Custom Dump Flags section (only visible if your backup type supports it)

  4. Enter --routines

  5. Click Save

How to dump stored procedures/functions on MySQL

Did this answer your question?