03 June, 2012

mysql exporting or dumping stored procedures using mysqldump

For exporting stored procedure function and triggers using mysqdump use the following command in mysql command prompt

mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt <database_name> > output_sp_dump.sql

No comments:

Post a Comment