Skip to content

MySQL Backup Stored Procedures

Procedures and Functions

By default, mysqldump only backup the data from which database indicated in the command line. For stored procedures, You have to enable the backup by adding an option --routines in the mysqldump command line. For example:

[root@test ~]# mysqldump --routines -u root -p database_name > dump.sql

Which routines oly include:

  1. Procedures
  2. Functions

Events

If you additionally need events to be backed up, you should add --events in mysqldump.

[root@test ~]# mysqldump --routines --events -u root -p database_name > dump.sql

It makes the dump file include:

  1. Events

For MySQL 5.7, there's a new client utility called mysqlpump which can backup all objects in databases by default without explicit declarations. You may refer to the document for more details: MySQL :: MySQL 5.7 Reference Manual :: 4.5.6 mysqlpump — A Database Backup Program.

Leave a Reply

Your email address will not be published. Required fields are marked *