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
