How to export triggers to another host

[l roles]

Hi,

I have a simple question regarding moving triggers from one server to another.
I have a batch file 'triggers.sql' which contains two triggers for one particular table.

Can I simply drop ONLY the triggers into an existing database without having to dump the tables as well?

E.g:
mysql <some options> <database> <table> < triggers.sql

If so, is someone able to tell me the specific options to do this?

Many thanks,
ns



Edited 1 time(s). Last edit at 04/14/2011 04:34AM by l roles.