Michael Blood wrote:
>
> Hello everyone.
>
> I am running a 2.2 Debian OS with 3.23.34a-log..
> I had an entire database which was 2GB installed on a 2GB partition.
> Stupidly the database is not backed up and when I attempt to access the
> database an error is returned when accessing certain tables
>
> errno: 145
>
> Saying that it can not open the table.
>
> I have looked up some infomration about repairing databases on the mysql
> site and found isamchk. however this only seems to work when you have *.ISM
> files. All of my files are .MYD .MYI and .frm.
>
> Does any one have any suggestions on how I can repair these tables?
>
> Michael Blood
> --:--
>
Hi,
isamchk is for the 'old' (ISAM) table format.
Your table is in MyISAM format (this format appeared in 3.23); you should use
myisamchk.
Regards
--
Joseph Bueno
NetClub/Trader.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
