MYSQLCant open file: .MYI
2022-10-09 20:09:53 Դ ۣ0
ǵ͵mysqlɵģİ취Ҳmysql׳ֵģmysqlļʺܴҲܷ㣬ٴⷢİ취Ǿٷʶϵ磬رշʱֶرmysqlݿ⡣
濴⣺
Can’t open file: ‘×××.MYI’ (errno: 145)һݿļɵģɵԭݿļŲŲȥĽȻųԭ
ݿִʾ:
Invalid SQL: ……
ǵ͵mysqlɵģİ취Ҳmysql׳ֵģmysqlļʺܴҲܷ㣬ٴⷢİ취Ǿٷʶϵ磬رշʱֶرmysqlݿ⡣
濴⣺
Can’t open file: ‘×××.MYI’ (errno: 145)һݿļɵģɵԭݿļŲŲȥĽȻųԭ
ݿִʾ:
Invalid SQL: ……
MySQL !: 1016 (Can’t open file: ‘×××.MYI’ (errno: 145))
жַݿԶӻӵԶ̷棬ķϵͳպWindowsģôԣ
->cmd
Ȼmysql –h ַ –u û –p
Ȼ룬ݿ⣻
Use ݿƣ
Ȼ 룺reapair table ıƣسһ¾ͿˣοͼƬ£
ڶַֻPHP룬ôҲܼдһphpļݿ⣬δ룺
Reapair table ``
“select * ……”һmysqlҲǿԵģ
ַɼˣmyphpadminѡCan’t open file:ͬıи˵“ѡ”ѡ“”ͼ
okˡ
ݿһã㻹ܿƵĻMysqlԴmyisamchk.exe£
ǰmysqlֹͣ
WinзʽȻ뵽mysql/binĿ¼
ִmyisamchk -r ݿ·\*.MYI
Unixֱʹmyisamchk -r ݿĿ¼\*.MYI
ο
MysqlеʱΪԭݿϢ£
MySql: Can't open file: 'sdb_sessions.MYI'. (errno: 145)
For more information, see Help and Support Center at
ǿʹmysqlԴmysqlcheckеݿضݿ;
Żеݿ:
# mysqlcheck -A -o -r -p
Enter password:
guestbook.simpgb_avatars OK
guestbook.simpgb_bad_words OK
guestbook.simpgb_banlist OK
guestbook.simpgb_da
......
......
......
mysqlcheck/html/Program/Mssql/200711/130.html
ָݿ
# mysqlcheck -A -o -r Database_NAME -p
ֻǶijãmyisamchkisamchk
myisamchkMYISAM͵ݱisamchkISAM͵ݱҪͬһµϵͳʹMYISAMΪȱʡݱͣmyisamchkΪӽ˵ijݱʱʹã
myisamchk tablename.MYI
м⣬ҪĻʹã
myisamchk -of tablename.MYI
myisamchkϸ˵ԲμʹðҪעʱڽʱȷMySQLûзݱյڽмʱMySQLShutdown
rc.localMySQLǰ
[ -x /tmp/mysql.sock ] && /pathtochk/myisamchk -of /DA
е/tmp/mysql.sockMySQLSockļλãʹRPMװûӦ/var/lib/mysql /mysql.sockʹԴ밲װ/tmp/mysql.sockԸԼʵбpathtochk myisamchkڵλãDA