Mysqldump TRIGGERS Only By admin on September 17, 2015 in MySQL Here’s the command to dump the triggers and stored procedures for a database: mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt [dbname] 1 mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt [dbname] Related posts: Sync MySQL Slave From Another Slave On Amazon AWS MySQL Error: Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted; MySQL Import Problem – Autoincrement Zabbix Proxy Install WordPress Development Sites
