It seems that the .FRM file for one of my largest tables has disappeared. 180 million rows. I am not so much concerned about finding out WHY it was deleted as I am trying to figure out how to recover the table.
I've tried making a new table using a similar data structure (the table is only three columns wide) and then using it's .FRM file as a definition. However, I cannot seem to get it quite right. The table is integer, integer, and then a varchar() or enum(). I can usually get the varchar/enum column correct, but the first two ints are giving me hassle. I know I used a combination of different integer types to conserve space (some of the numbers will never be higher than 100K or so). However, I cannot determine *what* integer types I've used. I always use unsigned, but I cannot recall if I used NOT NULL with a default value. Is there any way to solve this without trying the hundreds of permutations of integer definitions? -- R -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
