mysql 配置文件中由于 innodb_force_recovery = 1 引起的用户不能够不能修改数据

mysql 配置文件中由于 innodb_force_recovery = 1 引起的用户不能够不能修改数据的问题:

mysql console报错:“ERROR 1030 (HY000): Got error -1 from storage engine”

mysql 错误日志文件中:
120615 10:36:45 [Note] Start binlog_dump to slave_server(3113306), pos(mysql-bin.000026, 196)
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_… is removed.
|2|left
此条目发表在MySQL分类目录。将固定链接加入收藏夹。

发表评论

电子邮件地址不会被公开。 必填项已用*标注