加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > MySql教程 > 正文

Mysql学习一次非法关机导致mysql数据表损坏的实例解决

发布时间:2020-12-12 02:43:45 所属栏目:MySql教程 来源:网络整理
导读:《Mysql学习一次非法关机导致mysql数据表损坏的实例解决》要点: 本文介绍了Mysql学习一次非法关机导致mysql数据表损坏的实例解决,希望对您有用。如果有疑问,可以联系我们。 排查修复数据表的经过: MYSQL学习 1、拜访网页,提示错误,连接不到数据库. MYSQL

《Mysql学习一次非法关机导致mysql数据表损坏的实例解决》要点:
本文介绍了Mysql学习一次非法关机导致mysql数据表损坏的实例解决,希望对您有用。如果有疑问,可以联系我们。

排查修复数据表的经过:MYSQL学习

1、拜访网页,提示错误,连接不到数据库.MYSQL学习

2、启动mysql服务,卸载和关闭rpm安装的mysql服务

(昨天安装postfix好像yum安装了mysql),用netstat -anp |grep mysqld 命令查看mysql服务没有起来,用mysql -uroot -p也连接不到服务器.MYSQL学习

3、查看错误提示:

110726 17:02:23 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.?
110726 17:02:23 [ERROR] /usr/local/mysql/libexec/mysqld: Table './mysql/host' is marked as crashed and last (automatic?) repair failed?
110726 17:02:23 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/host' is marked as crashed and last (automatic?) repair failed 110726 17:02:23 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended?
110726 17:24:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql?
110726 17:24:31 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
发现提示数据库表损坏.(./mysql/host)MYSQL学习

4、修复数据库表

cd /var/lib/mysql/mysql?
myisamchk -of host.MYI?
- recovering (with keycache) MyISAM-table 'host.MYI'?
Data records: 0?
表host.MYI修复成功.MYSQL学习

5、再次启动服务,查看服务是否启动,登录mysql,还是不行.所以再次查看错误日志.

/usr/local/mysql/libexec/mysqld: Table './mysql/plugin' is marked as crashed and last (automatic?) repair failed?
/usr/local/mysql/libexec/mysqld: Table 'plugin' is marked as crashed and last (automatic?) repair failed?
110726 17:24:31 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.?
110726 17:24:31 [ERROR] /usr/local/mysql/libexec/mysqld: Table './mysql/user' is marked as crashed and last (automatic?) repair failed?
110726 17:24:31 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and last (automatic?) repair failed 110726 17:24:31 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended?
110726 17:27:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql?
110726 17:27:13 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.MYSQL学习

6、又发现./mysql/user表损坏.

[root@localhost mysql]# myisamchk -of user.MYI?
- recovering (with keycache) MyISAM-table 'user.MYI'?
Data records: 6MYSQL学习

7、表修复成功,但是还是启动不了服务,继续看错误日志.

/usr/local/mysql/libexec/mysqld: Table './mysql/plugin' is marked as crashed and last (automatic?) repair failed?
/usr/local/mysql/libexec/mysqld: Table 'plugin' is marked as crashed and last (automatic?) repair failed?
110726 17:27:13 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.?
110726 17:27:13 [ERROR] /usr/local/mysql/libexec/mysqld: Table './mysql/db' is marked as crashed and last (automatic?) repair failed?
110726 17:27:13 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/db' is marked as crashed and last (automatic?) repair failed?
110726 17:27:13 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid endedMYSQL学习

8、最后一个错误,是./mysql/db表还没有修复好继续修复./mysql/db表.MYSQL学习

9、执行下面的命令修复./mysql/db表:

[root@localhost mysql]# myisamchk -of db.MYI?
- recovering (with keycache) MyISAM-table 'db.MYI'?
Data records: 0?
Data records: 2MYSQL学习

10、最后启动mysql服务.

/usr/local/mysql/bin/mysqld_safe &MYSQL学习

11、查看服务是否在运行.

[root@localhost ~]# netstat -anp | grep mysqld?
tcp0? 0??
0.0.0.0:3306?
0.0.0.0:*?? LISTEN
4360/mysqld??
unix? 2? [ ACC ] STREAM LISTENING 14172
4360/mysqld /tmp/mysql.sock
这时发现服务已运行.MYSQL学习

12、登录mysql试试.

[root@localhost ~]# mysql -uroot -p123456?
Welcome to the MySQL monitor.? Commands end with ; or g.?
Your MySQL connection id is 35?
Server version: 5.1.55-log Source distribution?
Copyright (c) 2000,2010,Oracle and/or its affiliates. All rights reserved.?
This software comes with ABSOLUTELY NO WARRANTY. This is free software,?
and you are welcome to modify and redistribute it under the GPL v2 license?
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.?
mysql>?
可以登录.MYSQL学习

13、打开网页,已经可以正常拜访了,说明MySQL数据库的数据表修复成功.MYSQL学习

编程之家PHP培训学院每天发布《Mysql学习一次非法关机导致mysql数据表损坏的实例解决》等实战技能,PHP、MYSQL、LINUX、APP、JS,CSS全面培养人才。

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读