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 <table> - recovering (with keycache) MyISAM-table '<table>' Data records: 21622679 49800008000 7256000 10627000 myisamchk: error: 126 for record at pos 1589881104 MyISAM-table '<table>' is not fixed because of errors myisamchk -r --force --tmpdir=/data2/tmp <table> - recovering (with sort) MyISAM-table '<table>' Data records: 12876899 - Fixing index 1 - Fixing index 2 - Fixing index 3 Key 3 - Found wrong stored record at 0 MyISAM-table '<table>' is not fixed because of errors Where do I go from here? I've got a backup of the table, but I'm not sure what sort of state it is in. -- /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
