Drop Triggers Batch File for MySQL
Replace {User}, {Password} and {Database}
mysql -u{User} -p{Password} -e "select concat(concat('drop trigger ', trigger_name),';') as '' from information_schema.triggers where upper(event_object_schema) = upper('{Database}') and (trigger_name like 'ON_%%' or trigger_name like 'SYM_%%')" {Database} > drop_triggers.tmp mysql -u{User} -p{Password} {Database}