Data recovery with just the MYD file
am 30.01.2006 16:33:31 von shirazkDue to a disk space issue, i lost the .MYI for a table. It seems the
..MYD is still intact. Is there any way to recover the data from just
the MYD file?
Due to a disk space issue, i lost the .MYI for a table. It seems the
..MYD is still intact. Is there any way to recover the data from just
the MYD file?
"Shiraz"
news:1138635211.376497.224620@z14g2000cwz.googlegroups.com.. .
> Due to a disk space issue, i lost the .MYI for a table. It seems the
> .MYD is still intact. Is there any way to recover the data from just
> the MYD file?
I think so, but I haven't had occasion to do this.
Read about "Easy safe repair" on this page:
http://dev.mysql.com/doc/refman/5.0/en/repair.html
It seems like you can run "myisamchk -r tbl_name" to rebuild an index.
Regards,
Bill K.