逐梦论坛 - Powered by Discuz! Board

标题: [软件故障] ERROR 1030 (HY000) at line 31: Got error 168 from storage engine [打印本页]

作者: shillan 时间: 2018-3-2 15:43 标题: ERROR 1030 (HY000) at line 31: Got error 168 from storage engine

现象：MySQL数据库在cmd下使用命令进行.sql导入时提示：

C:\Program Files\MySQL\bin>mysql -u root -p密码数据库名 <D:\bak.sql
mysql: [Warning] Using a password on the command line interface can be insecure.

ERROR 1030 (HY000) at line 31: Got error 168 from storage engine

或者提示某些表已存在。

解决：删除数据库所在文件夹下的
ib_buffer_pool
ib_logfile0
ib_logfile1
ibdata1
ibtmp1
机器名.pid
文件，再重新导入即可。

欢迎光临逐梦论坛 (http://temp2023.zhumeng.org/)