Does "repair table" work in this case? --- "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> wrote:
> Hi Vicki, > > If you have a backup of the .MYD file, you should be > able to copy this > over the existing one and run myisamchk -r to > rebuild the index. > > Regards > > David Logan > Database Administrator > HP Managed Services > 148 Frome Street, > Adelaide 5000 > Australia > > +61 8 8408 4273 - Work > +61 417 268 665 - Mobile > +61 8 8408 4259 - Fax > > > -----Original Message----- > From: Vicki Brown [mailto:[EMAIL PROTECTED] > Sent: Thursday, 20 January 2005 8:49 AM > To: Dathan Pattishall; mysql@lists.mysql.com > Subject: RE: I seem to have lost a table somehow :-( > > At 3:21 PM -0800 1/18/05, Dathan Pattishall wrote: > >Somehow your table was zero'ed out, i.e. TRUNCATE / > DROP-CREATE. > > > >MYD - data of the table > >MYI - index of the table > >Frm - TABLE definition > > > >I hope you have a backup. > > Ewwch. > I may have a backup. I definitely have the data. > Unfortunately, there > doesn't > seem to be an "easy" way to put the data back into > the db. > > On the other hand, it's not my weblog, it's seen > very little activity > over > its lifetime, the last entry was September and the > owner is temporarily > "off > the Internet". So it couldn't have happened to a > less important > database. > > Still. I wonder what crashed. > -- > Vicki Brown ZZZ Journeyman > Sourceror: > SF Bay Area, CA zz |\ _,,,---,,_ > Scripts & Philtres > http://www.cfcl.com zz /,`.-'`' -. ;-;;,_Code, > Doc, Process, QA > http://cfcl.com/vlb |,4- ) )-,_. ,\ ( `'-'Perl, > Unix, Mac OS X, WWW > ____________________ '---''(_/--' `-'\_) > ___________________________ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
