Re: FRM file disappears -- any way to rebuild or recover?

2003-12-04 Thread Roger Baklund
* Reverend Deuce aka Robert > I am examining the file in a HEX editor right now and have identified the > pattern. The table size divided by the pattern byte length is 8 bytes. The > last byte is always one of three characters ('S', 'B', or 'U') as > defined by > the program that feeds this table.

Re: FRM file disappears -- any way to rebuild or recover?

2003-12-04 Thread Sergei Golubchik
Hi! On Dec 04, Reverend Deuce wrote: > > I'm having a time deciphering this stuff. The mediumint and int say they use > 3 bytes and 4 bytes each, respectively, but using that in the table > definition yields invalid numbers. > > Any ideas? As you still have MYI file, you can simply use myisamch

Re: FRM file disappears -- any way to rebuild or recover?

2003-12-04 Thread Reverend Deuce
rom: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Robert" <[EMAIL PROTECTED]> Sent: Thursday, December 04, 2003 9:52 AM Subject: Re: FRM file disappears -- any way to rebuild or recover? > Whoops. Then we are beyond "Very difficult

Re: FRM file disappears -- any way to rebuild or recover?

2003-12-04 Thread Roger Baklund
* Robert > 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 tab

FRM file disappears -- any way to rebuild or recover?

2003-12-04 Thread Robert
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 c