用myisamchk修复数据库时报错

xueradium

myisamchk:error unknown variable read_buffer=2m

licess

/etc/my.cnf 里找你添加的read_buffer在那个段里或贴一下/etc/my.cnf

apmsoso

licess 发表于 2017-1-15 10:35
/etc/my.cnf 里找你添加的read_buffer在那个段里或贴一下/etc/my.cnf

[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 4M
read_buffer = 2M
write_buffer = 2M

请帮忙看看，我也遇到了这个问题
mysql> FLUSH   PRIVILEGES;
ERROR 1194 (HY000): Table 'user' is marked as crashed and should be repaired


补充内容 (2019-7-10 15:29):
是mysql 5.7

licess

apmsoso 发表于 2019-7-10 11:44
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 4M

phpmyadmin 里修复或者使用 mysqlcheck -u root -p mysql 命令修复试试