mysqldãèµ·åããªããªã£ãã¨ãã®å¯¾å¦æ¹æ³
ã¯ã©ã¦ãä¸ã§åããã¦ããmysqlã§create databaseã¨drop database ã®æä½ãç¹°ãè¿ãã¦ãããmysqlãç¡å¿çã«ãªã£ã¦ãã¾ã£ãã
CentOSããªãã¼ããã¦ã¿ããã©ããã¯ãmysqldãèµ·åããªãã
ããã£ã¦ã¿ããããã¡ãããããã
â«[手順] MySQL データベースでの InnoDB 破損を修復するには – ヘルプセンター
ããã¯ã¢ãããã¦ãmy.cnfãå¤æ´ãã¦ã復æ§ãããæ¹æ³ãããã
# mkdir /root/mysql_backup # cp -a /var/lib/mysql/* /root/mysql_backup/ # vi /etc/my.cnf [mysqld] innodb_force_recovery = 1
ãã®ãã¨ã§ mysqld ãèµ·åãããã£ã¦ãã¨ã ãã©ããã¯ãèµ·åããªãã
# /etc/rc.d/init.d/mysqld start MySQL Daemon failed to start. Starting mysqld:
ãããªãæ
å ±ããã¨ãã¦ãããã
ãã¡ãããããã
â« Resolved - MYSQL database is not starting since today morning | Plesk Forum
forcing InnoDB Recovery solution has not working for me. I have fixed the issue as follows:
1) remove the syslog entry under --> /etc/mysql/conf.d/mysqld_safe_syslog.cnf
2) backup & remove both ib_logfile0 & ib_logfile1 files under --> /var/lib/mysql
3) remov entry innodb_force_recovery = 1 from --> etc/mysql/my.cnf
4) command --> sudo service mysql start
5) server is starting and works fine again without loosing any data
1ã«ãããã¡ã¤ã«ã¯ãªãã£ãã®ã§ç¡è¦ã
2ã®ããã¯ã¢ããã¯ãã§ã«ãã£ã¦ããã追å 㧠ib_logfile[01] ãåé¤ããã
3ã®my.cnfã®ä¿®æ£ãããã»ã©è¿½å ãã1è¡ãåé¤ã
4ã§mysqldãèµ·åã
ãµã¯ãã¨èµ·åããï¼
ib_logfile[01]ãå£ãã¦ãããããã
åèµ·åå¾ãåé¤ãããã¡ã¤ã«ã¯å¾©æ´»ãã¦ãã
# ls -l /var/lib/mysql/ib_logfile* -rw-rw---- 1 mysql mysql 50331648 Aug 1 14:20 /var/lib/mysql/ib_logfile0 -rw-rw---- 1 mysql mysql 50331648 Aug 1 13:45 /var/lib/mysql/ib_logfile1