This is a error : When I open my table ,this mysql return "Can't open file: 'statistic.MYD'. (errno: 145) ". Do anybody can help me ? I am from china,beijing.
root@mong:/usr/local/mysql/bin# ./perror 145 Error code 145: Unknown error 145 145 = Table was marked as crashed and should be repaired
re-create the file or try to repair it =)
I am sorry but do to recent attacks on US servers by Chinese hackers I cannot help you... JK
Well lets see here. From the looks of it it seems that it is a problem with the server your are using. statistics.MYD is a data file for the server itself and if you can't open it chances are it doesn't exist on the server or it has been moved from where it needs to be. Try creating a new database or if you can't talk to the webmaster/admin to make you new one. Hope this helps.
I have checked my database ,and I found the database's link is right.The same table in this database are running correctly. I ever heard that use this command :isamchk can fix table ,but I can't fix my table.
I want to fix it ,please help me
U can just do that :
REPAIR TABLE TABLENAMEHERE
where TABLENAMEHERE is the table to fix ..
u have to do this into PHP admin
and voila ! !
it worked fine for me after this. 😃
