From: Claudio Nanni Date: November 28 2011 7:43am Subject: Re: Corrupted TRG file List-Archive: http://lists.mysql.com/mysql/226376 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf300fb1fbee4df204b2c6a965 --20cf300fb1fbee4df204b2c6a965 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Halasz, Have you tried to 'browse' the information schema? Whats in there? Claudio On Nov 25, 2011 6:20 PM, "Hal=E1sz S=E1ndor" wrote: > 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 > > --20cf300fb1fbee4df204b2c6a965--