Importing Triggers on Linux (Ubuntu)

[Gut]

Can someone help me out on importing triggers on linux ubuntu <TFS>

I need:
1. A triggers.sql file that has all the TFS triggers (CREATE TRIGGER `ondelete_accounts`, ect)
2.An explanation on how to import it on ubutnu linux.

Thanks!!!!

 

[elf]

Can someone help me out on importing triggers on linux ubuntu <TFS>

I need:
1. A triggers.sql file that has all the TFS triggers (CREATE TRIGGER `ondelete_accounts`, ect)
2.An explanation on how to import it on ubutnu linux.

Thanks!!!!

1. Seperate them from schema.mysql
2. mysql -u USER -pPASSWORD DATABASE < triggers.sql

^up^ needs some special permission, best to import it with root.

 

[Gut]

Worked, thanks :>