mysql打开表报错err 1030 - got error 1877 'Unknown error 1877' from storage engine InnoDB

参考解决链接

https://www.cnblogs.com/caijh/p/7244915.html

查看日志文件位置

show variables like '%error%';

根据错误日志分析，删除log_file文件

cd /server/mysql/data
rm ib_logfile0
rm ib_logfile1

修改my.ini文件

innodb_buffer_pool_size        = 256M
innodb_log_file_size           = 256M
innodb_thread_concurrency      = 16
innodb_flush_log_at_trx_commit = 2
innodb_force_recovery = 6
innodb_purge_threads = 1

重启数据库