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: [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: 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]