MySQL Export Stored Procedure

To export a stored procedure using the mysqldump command

[Email protected] sql]# mysqldump-uroot-p-n-d-t-r--all-databases > All.sql

Parameter description:

-n, --no-create-db  suppress the create database ... if exists  statement that                       normally is output for each dumped  database if                       --all-databases or --databases is given.-t , --no-create-info                        don ' t write table creation info.-d,  --no-data       no row information.-r, --routines       Dump stored routines  (functions and procedures).- A, --all-databases dump all the databases. this will be same as --databases                        with all databases selected.

This article is from "Hello Tech" blog, please make sure to keep this source http://ninefive.blog.51cto.com/9469723/1566213

MySQL Export Stored Procedure