[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

Discussion in 'Server Operation' started by dayjahone, Oct 6, 2016.

  1. dayjahone

    dayjahone Member

    Suddenly, mysql stopped working. When I try to start it, it tries, then fails. Any ideas on how to diagnose it?

    Thanks.
     
  2. dayjahone

    dayjahone Member

    When I do cat /var/log/mysql.err, there is nothing there.
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    check mysql.log and syslog.
     
  4. dayjahone

    dayjahone Member

    mysql.log is empty. syslog just has a lot of messages about not being able to connect.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    restart mysql again and then check the syslog right after that.
     
  6. dayjahone

    dayjahone Member

    Hi Till,

    OK, jackpot...
    I looked at http://dev.mysql.com/doc/mysql/en/crashing.html, but I wasn't sure where/how to execute the commands...
     
  7. dayjahone

    dayjahone Member

    Can anyone help with this?
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    First, make a backup of /var/lib/mysql directory.

    Then add:

    innodb_force_recovery = 1

    into the [mysqld] section of the file /etc/mysql/my.cnf and try to restart mysql.
     
  9. dayjahone

    dayjahone Member

    It still fails. I added it directly under [mysqld].
     
  10. dayjahone

    dayjahone Member

    Does anyone have any ideas? I didn't notice anything changed after adding innodb_force_recover = 1. I get the following on boot:
    [​IMG]
     

Share This Page