Bug #8245 MYSQL ERROR NO 145
Submitted: 1 Feb 2005 18:52 Modified: 1 Feb 2005 20:23
Reporter: piyush kothaRI Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:Windows (WINDOWS XP)
Assigned to: CPU Architecture:Any

[1 Feb 2005 18:52] piyush kothaRI 
Description:
hI,

I tried opening one of my tables in mysql db.It was corrupted.And I got the mysql error no 145.I did "repair table tablename".After that I was able to see the records in the table but due to repair few records got deleted.
I have two question
First is it possible to get the lost records back?
Second what can I do to prevent such kind of errors not to occur in future?

Immediate reply will be appreciated.

Thanks,
Piyush

How to repeat:
No idea how the particular error occured
[1 Feb 2005 20:23] MySQL Verification Team 
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.