Re: How to backup Triggers

[Paul McArdle]

cat /var/lib/mysql/test/*.TRG > triggers.txt --- gets triggers from test db in /var/lib/mysql
cat triggers.txt
TYPE=TRIGGERS
triggers='create trigger a_bfu before update on a FOR EACH ROW\nbegin\nif new.a <> OLD.a THEN\nset NEW.b = \'c\';\nend if;\nend'
TYPE=TRIGGERS
triggers='create trigger houses_afi after insert on houses for each row insert into fund values( new.id, new.id, new.id, new.id)'

is all we got now.