User Tools

Site Tools


db:mysqldump_procedures

mysqldump for Procedures

12.11.2015

By default, mysqldump is not outputting the stored procedures (but does that with triggers).

In order to export also the procedures:

mysqldump -u <user> -p --routines <database> > output.sql

To export only the stored procedures (no tables or triggers):

mysqldump --skip-triggers --routines --no-create-info --no-data --no-create-db --skip-opt -u <user> -p <database> > output.sql

db/mysqldump_procedures.txt · Last modified: 2015/11/12 05:05 by admin