Thursday, September 13, 2012

MySQL dumping triggers and procedures

To dump MySQL triggers and stored procedures using mysqldump, you have two options:

1) Dump the mysql schema (which may not always be feasible)

OR

2) Use the following mysqldump command:


mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt <database> > outputfile.sql


Post a Comment