how to recover mysql table from .{MYI|MYD|frm} files?
Rick Stevens
rstevens at vitalstream.com
Tue Jan 23 01:52:03 UTC 2007
On Mon, 2007-01-22 at 17:38 -0800, Robinson Tiemuqinke wrote:
> Hi,
>
> Here is a newbie on both Fedora Core and MySQL. I
> have my database corrupted and so data in one table is
> currently not playable.
>
> But fortunately I have the <tableName>.{MYI|MYD|frm}
> file saved accidently two days ago. should I just stop
> mysql and overwrite related files? or I have to play
> log files?
I'd stop it first and try "myisamchk <name-of-table>". See if that
fixes it first before doing anything more drastic. You can add a "-v"
to the command for verbose output. Have a look at the man page for
other options.
----------------------------------------------------------------------
- Rick Stevens, Senior Systems Engineer rstevens at vitalstream.com -
- VitalStream, Inc. http://www.vitalstream.com -
- -
- Perseverance: When you're too damned stubborn to say "I quit!" -
----------------------------------------------------------------------
More information about the fedora-list
mailing list