The following always is the outcome of the command "show create trigger":

mysql> show create trigger memberchange;
ERROR 1602 (HY000): Corrupted TRG file for table `membership`.`address`

mysqld x86 5.5.8 under Vista

The trigger works, there is no problem with "show triggers", and this error appears right after the trigger file was deleted ("drop trigger" until then) and anew made by installing a trigger--as if the code that handles "show create trigger" expects a format that no other does.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql