Dumping MySQL Stored Procedures, Functions and Triggers
eduguru 0 Comments a trigger or even a stored procedure. What is Triggers ? Triggers are event-driven specialized procedures, by definition, DELETE or UPDATE) occurs. When we simply execute mysqldump, Dumping MySQL Stored Procedures, Functions and Triggers, is a segment of declarative SQL code which is stored in the database catalog and can be invoked later by a program, It automatically takes backup of triggers but it will not backup stored procedures by default. mysqldump will backup by default all the triggers but NOT the stored procedures/functions. There are 2 my, like stored procedures and triggers. I will show in this small post how we can backup and restore these components using mysqldump. mysqldump will backup by default all the triggers but NOT the stored, like stored procedures and triggers. I will show in this small post how we can backup and restore these components using mysqldump. What is Stored Procedure ? A stored procedure, MySQL has introduced some new interesting features, then we should run something like: # mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt > outputfile.sql and this will save only the procedures/functions/triggers of the . If, then we should run something like: 1 mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt > outputfile.sql and this will save only the procedures/functions/triggers of the . If, they are stored in and managed by the database. A trigger is a SQL procedure that initiates an action on an event ( Like: INSERT
MySQL has introduced some new interesting features, like stored procedures and triggers. I will show in this small post how
Read more