View Full Version : not a ISAM-Table
February 21st, 2005, 06: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?
February 21st, 2005, 07:03 AM
Are you running this command
myisamchk -r tbl_name
February 21st, 2005, 07:15 AM
i was running myisamchk -r *.myi
February 21st, 2005, 07:18 AM
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
February 21st, 2005, 07:39 AM
well first try one table at a time
myisamchk -r admlog
myisamchk -r -q admlog
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.