使用mysqldump命令导出存储过程
[root@one sql]# mysqldump -uroot -p -n -d -t -R --all-databases > all.sql
参数说明:
-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.
转载于:https://blog.51cto.com/medone/1566213