User Tools

Site Tools


db:mysqldump_procedures

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

db:mysqldump_procedures [2015/11/12 05:05] (current)
admin created
Line 1: Line 1:
 +====== mysqldump for Procedures ======
 +12.11.2015
  
 +By default, mysqldump is not outputting the [[db:​storedpf|stored procedures]] (but does that with triggers).
 +
 +In order to export also the procedures:
 +
 +<​code>​
 +mysqldump -u <​user>​ -p --routines <​database>​ > output.sql
 +</​code>​
 +
 +To export **only** the stored procedures (no tables or triggers):
 +
 +<​code>​
 +mysqldump --skip-triggers --routines --no-create-info --no-data --no-create-db --skip-opt -u <​user>​ -p <​database>​ > output.sql
 +</​code>​
db/mysqldump_procedures.txt ยท Last modified: 2015/11/12 05:05 by admin