Vi /etc/my.cof 增加一行 innodb_force_recovery= 1
mysql非正常关机,无法启动!
Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibd
1. 进入mysql/data 目录
2. 把下面的文件删除
.......frm
.......ibd
重启mysql服务
alter table 表名 modify column 列名 varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL;
libnuma.so.1()(64bit) is needed by MySQL-server-5.6.27-1.el6.x86_64
libnuma.so.1(libnuma_1.1)(64bit) is needed by MySQL-server-5.6.27-1.el6.x86_64
libnuma.so.1(libnuma_1.2)(64bit) is needed by MySQL-server-5.6.27-1.el6.x86_64
下载地址:
http://mirror.centos.org/centos/6/os/x86_64/Packages/numactl-2.0.9-2.el6.x86_64.rpm