MYSQLe`Cant open file: .MYI
2022-10-09 20:09:53   (li)Դ   uՓ0 c(din)

@(g)e`ǵ͵mysqlܓpɵQkޏͱ@(g)(wn)}Ҳmysql(jng)׳FmysqlpĵĎʺܴޏҲܷpٴ(li)(wn)}l(f)kDZMpٷ(w)o(w)ʔP(gun)](w)r(sh)ք(dng)P(gun)]mysql

濴@(g)(wn)}


Can’t open file: ‘×××.MYI’ (errno: 145)@(g)e`һĔļpɵɵԭєļŲ(li)ŲȥĽYȻųԭ

wFe`ʾa:
 Invalid SQL: ……

 

@(g)e`ǵ͵mysqlܓpɵQkޏͱ@(g)(wn)}Ҳmysql(jng)׳FmysqlpĵĎʺܴޏҲܷpٴ(li)(wn)}l(f)kDZMpٷ(w)o(w)ʔP(gun)](w)r(sh)ք(dng)P(gun)]mysql

濴@(g)(wn)}


Can’t open file: ‘×××.MYI’ (errno: 145)@(g)e`һĔļpɵɵԭєļŲ(li)ŲȥĽYȻųԭ

wFe`ʾa:
 Invalid SQL: ……
MySQL e`!: 1016 (Can’t open file: ‘×××.MYI’ (errno: 145))

Q@(g)(wn)}жNĔh朽ӻBӵh̷(w)ķ(w)ϵyWindowsôԣ

\->cmd

Ȼmysql –h Cַ –u Ñ(h) –p
ȻݔܴaBӔ
Use Q(chng)
Ȼ ݔ룺reapair table eıQ(chng)܇(ch)@ޏһ¾ͿDƬ£

image002

ڶNOֻ\PHPaôҲܺ(jin)(xi)һ(g)phpļ朽ϔ@δa
Reapair table ``
l(f) “select * ……”һӰl(f)ͽomysqlҲǿԵ

Nɺ(jin)_(ki)myphpadminxCan’t open file:ͬıЂ(g)ˆ“x”x“ޏ”D

image004

ok

ĔCһ(g)߀ܿƵԒ(hu)hMysqlԎޏ͹myisamchk.exeM(jn)ޏ£

ޏǰmysql(w)ֹͣ
WinC_(ki)зʽȻM(jn)뵽mysql/binĿ
myisamchk -r  ·\*.MYI
(li)UnixCֱʹmyisamchk -r  Ŀ\*.MYI

Mysqlеĕr(sh)늻ԭ”peϢ£

MySql: Can't open file: 'sdb_sessions.MYI'. (errno: 145)

For more information, see Help and Support Center at

҂ʹmysqlԎmysqlcheck(li)ޏеĔضĔ;

z郞(yu)ޏеĔ:

# mysqlcheck -A -o -r -p

Enter password:

guestbook.simpgb_avatars OK

guestbook.simpgb_bad_words OK

guestbook.simpgb_banlist OK

guestbook.simpgb_data OK

......

......

......

mysqlcheckZ(y)/html/Program/Mssql/200711/130.html

ޏָĔ

# mysqlcheck -A -o -r Database_NAME -p


 

ֻnjij(g)M(jn)ޏͿãmyisamchkisamchk
myisamchkmMYISAM(li)͵ĔisamchkmISAM(li)͵Ĕ@ɗlҪͬһµϵyʹMYISAMȱʡĔ(li)@myisamchkM(jn)f(shu)l(f)Fij(g)F(wn)}r(sh)ʹã
myisamchk tablename.MYI
M(jn)ЙzyҪޏ͵Ԓ(hu)ʹã
myisamchk -of tablename.MYI
P(gun)myisamchkԔf(shu)ԅҊ(jin)ʹÎҪעĕr(sh)M(jn)޸ĕr(sh)횴_MySQL(w)](mi)L(fng)(wn)@(g)UrM(jn)Йzyr(sh)MySQL(w)Shutdown
԰rc.local憢(dng)MySQL(w)ǰ
[ -x /tmp/mysql.sock ] && /pathtochk/myisamchk -of /DATA_DIR/*/*.MYI
е/tmp/mysql.sockMySQLO (tng)SockļλʹRPMbÑ(h)ԓ/var/lib/mysql /mysql.sockʹԴabt/tmp/mysql.sockԸԼČ(sh)HrM(jn)׃pathtochkt myisamchkڵλDATA_DIRMySQLŵλ

P(gun)~MySQL Errno:145 MySQL Errno:126

һƪMySQLֹͣ͆(dng)(w)
һƪһ(y)

ղ
ھ(xin)ԃ(xn)
0