not a ISAM-Table

redbone · February 21st, 2005, 07:47 AM

OK... here is the history... running photopost and mysql... my hard drive ran out of space...which stopped photopost from running correctly... I freed up some space then when to run isamchk -r and below is the error that I am now getting...

e:\mysql\bin\isamchk: error: 'admlog.MYI' is not a ISAM-table

all the .MYI files are there but it's not recognizing them...what to do?

TIA
Dan

Chuck S · February 21st, 2005, 08:03 AM

Are you running this command

myisamchk -r tbl_name

redbone · February 21st, 2005, 08:15 AM

i was running myisamchk -r *.myi

redbone · February 21st, 2005, 08:18 AM

fyi...

E:\mysql\data\photopost>e:\mysql\bin\myisamchk -r users.MYI
- recovering (with sort) MyISAM-table 'users.MYI'
Data records: 1942
myisamchk: error: Can't create new tempfile: 'users.TMD'
MyISAM-table 'users.MYI' is not fixed because of errors
Try fixing it by using the --safe-recover (-o) or the --force (-f) option

Chuck S · February 21st, 2005, 08:39 AM

well first try one table at a time

myisamchk -r admlog

or

myisamchk -r -q admlog