how to dump triggers separately

2007-03-23 Thread asv
I need to create dump of all triggers in my database (This means that ONLY triggers must be dumped and nothing more: no data and no table structure). Is there any direct (or simple) way to do that? Mysqldump seems to be unable to do that. The only two ways i see -- to create a script that gets

Re: how to dump triggers separately

2007-03-23 Thread Rolando Edwards
- Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, March 23, 2007 9:23:06 AM (GMT-0500) Auto-Detected Subject: how to dump triggers separately I need to create dump of all triggers in my database (This means that ONLY triggers must be dumped and nothing more