Re: recovery question

Gleb Paharenko wrote: > Hello. > > REPAIR TABLE ... USE_FRM helps in difficult cases. See: > http://dev.mysql.com/doc/mysql/en/repair-table.html > Thanks Gleb. I'd forgotten about that option. To others who try the same thing - make sure you have enough space in your TMPDIR or set TMPDIR/

Re: recovery question

try REPAIR TABLE 'tablename' Gleb Paharenko wrote: >Hello. > > > >REPAIR TABLE ... USE_FRM helps in difficult cases. See: > > http://dev.mysql.com/doc/mysql/en/repair-table.html > > > > > > > > > > > >Per Jessen <[EMAIL PROTECTED]> wrote: > > > >>All, >> >> > > > >>I've got a table wit

Re: recovery question

Hello. REPAIR TABLE ... USE_FRM helps in difficult cases. See: http://dev.mysql.com/doc/mysql/en/repair-table.html Per Jessen <[EMAIL PROTECTED]> wrote: > All, > I've got a table with about 25mill rows that was victim of a crash recently. > (power-failure). > I've been trying t

Re: recovery question

Per Jessen wrote: > I've got a backup of the table, but I'm not sure what sort of state > it is in. Correction - no backup is available. This table has got to be recoverable. -- /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

recovery question

All, I've got a table with about 25mill rows that was victim of a crash recently. (power-failure). I've been trying to recover it, but I'm not making much progress. >From the most recent attempts: myisamchk --safe-recover --force - recovering (with keycache) MyISAM-table '' Data records: 21622