Re: Corrupted TRG file

[Claudio Nanni]

Halasz,
Have you tried to 'browse' the information schema?
Whats in there?

Claudio
 On Nov 25, 2011 6:20 PM, Halász Sándor h...@tbbs.net 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

Corrupted TRG file

[Hal�sz S�ndor]

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

Corrupted TRG file?

[Jerry Schwartz]

Version 5.1.31 Community (Win32)

 

I created a trigger named TC_Products_Date_Trigger on the table TC_Products.

 

I typed in 

 

SHOW CREATE TRIGGER tc_products_date_trigger;

 

and this came back at me:

 

ERROR 1602 (HY000): Corrupted TRG file for table `subtable_usa`.`tc_products`

 

I almost jumped out of my skin. Then I typed in

 

SHOW CREATE TRIGGER TC_Products_Date_Trigger;

 

and that worked just fine. I didn’t find any bug reports that seemed relevant, 
but I can’t believe I’m first one to stumble on this.

 

Regards,

 

Jerry Schwartz

Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032

 

860.674.8796 / FAX: 860.674.8341

E-mail:  mailto:je...@gii.co.jp je...@gii.co.jp 

Web site:  http://www.the-infoshop.com/ www.the-infoshop.com