[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.
     
    dayjahone, Oct 6, 2016
    #1
  2. dayjahone

    dayjahone Member

    When I do cat /var/log/mysql.err, there is nothing there.
     
    dayjahone, Oct 6, 2016
    #2
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    check mysql.log and syslog.
     
    till, Oct 6, 2016
    #3
  4. dayjahone

    dayjahone Member

    mysql.log is empty. syslog just has a lot of messages about not being able to connect.
     
    dayjahone, Oct 6, 2016
    #4
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    restart mysql again and then check the syslog right after that.
     
    till, Oct 6, 2016
    #5
  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...
     
    dayjahone, Oct 7, 2016
    #6
  7. dayjahone

    dayjahone Member

    Can anyone help with this?
     
    dayjahone, Oct 11, 2016
    #7
  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.
     
    till, Oct 11, 2016
    #8
  9. dayjahone

    dayjahone Member

    It still fails. I added it directly under [mysqld].
     
    dayjahone, Oct 13, 2016
    #9
  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]
     
    dayjahone, Oct 15, 2016
    #10

Share This Page