Knowledge Walls
John Peter
Pune, Maharashtra, India
Dumping Triggers / Skip Triggers in mysqldump
4299 Views
Hints 
--triggers  (Used to take all the triggers)
--skip-triggers (Used to skiping all the triggers)


Example
mysqldump -uusername -ppassword db_name --triggers > export_filename.sql
mysqldump -uusername -ppassword db_name --routines --skip-triggers > export_filename.sql
Best Lessons of "MySQL"
Top lessons which are viewed more times.
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details