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 triggers by "show
triggers" query or reads them directly from INFORMATION_SCHEMA. Is there a
more simple way?

It would be advisable that your triggers be dumeds in association with your table structures like this

mysqldump -h... -u... -p... --no-data --triggers <dbname>

However, the next line is what you are looking for

mysqldump -h... -u... -p... --no-data --no-create-info --triggers <dbname>

----- Original Message -----
From: asv@pallant-mobile.ru
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: 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 triggers by "show
triggers" query or reads them directly from INFORMATION_SCHEMA. Is there a
more simple way?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=redwards@swmx.com