mysqldump Export Stored Procedure instance

Mysqldump is a MySQL with a backup database tool, using mysqldump can be very convenient to export the existing database, using

The code is as follows	Copy Code
Mysqldump--help

If Mysql_home/bin does not join path, you need to specify the path to see a number of optional parameters.

Note: By default, mysqldump does not export stored procedures and functions for the database, and if a stored procedure is created on the database and the backup is required to back up the stored procedure, it needs to be specified with parameter-R.

For example:

The code is as follows	Copy Code
Root@localhost bin]# mysqldump-uroot-p-hlocalhost-p3306-n-d-t-R dbname > Procedure_name.sql

Parameter description:

-N:--no-create-db
-D:--no-data
-T:--no-create-info
-r:--routines Dump stored routines (functions and procedures)