MYSQL starts only with innodb_force_recovery. How to repair the database access?

Discussion in 'Server Operation' started by Nakamuta, Jun 13, 2020.

  1. Nakamuta

    Nakamuta New Member

    Debian 9 - ISPConfig3 - MYSQL - Postfix - Phpmyadmin error
    I please TILL BREHM, the Super Moderator, and anyone who knows any possible solution to help me to cope with a problem.
    I've got unexpectedly MYSQL not working. In a while I've found out #mysqld innodb_force_recovery=4, which started my web server, but I can't login into neither ISPConfig3 nor Wordpress panel for my sites nor Roundcube because after fullfilling login forms I'm being thrown back to the same forms nor Phpmyadmin which is not found. I've read hundreds of articles according to my understanding of this MYSQL status, I've done so much tests and careful corrections in configuration with no satisfaction. I have to care for all the data on my server and keep it safe, as the site is devoted for SEO. What is the direction to think of: 1) corrupted databases? OR 2) bad configuration? I'm lost. Any help will be highly appreciated.
    My currently in work links:
    • http port 80
    • http port 80
      and login forms:
    • https port 8080
    • https port 8081 (not found)
    Current logs are as follows:
    [email protected]:/var/log# uname -a
    [email protected]:/var/log# mysql -V
    [email protected]:/var/lib/mysql# service mysql status
    [email protected]:/var/log# tail syslog
    [email protected]:/var/log/mysql# tail error.log
    [email protected]:/var/log# df -h
    [email protected]:/var/log# free -h
    [email protected]:/var/log# mysql -u root -p
    [email protected]:/var/log# service postfix status
    Thanks in advance! Danke sehr! Спасибо!
    Last edited: Jun 13, 2020
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    You should have posted on ISPConfig 3 forum, since you seem to be running ISPConfig on that host.
    Start with this, so basic things are checked and shown:
    Is this a recently installed system? What happened before mysql stopped working?
    You could try Internet Search Engines with the error messages in logs:
    Unknown/unsupported storage engine: InnoDB
    Your posts become more readable if you:
    • put LANG=C before commands that produde non-english text, like LANG=C df -h
    • paste the output in CODE tags instead of QUOTE.
    See how much better this is:
    $ free -h
                  total        used        free      shared  buff/cache   available
    Mem:          7,7Gi       5,8Gi       556Mi       883Mi       1,3Gi       757Mi
    Swap:            0B          0B          0B
    I would also try starting mysql on the command line, that way error messages are shown immediately:
    systemctl stop mysql
    systemctl start mysql
    Usual things to do when database does not work:
    • check databases, they may be broken. PHPMyadmin is easy way to do this
    • has configuration in /etc/mysql been changed?
    • can the database storage directory/disk be written to?
    • is disk full? (you checked this)
    • is memory full (you checked this)
    • read the docs
    • Use Internet Search Engines with error messages

Share This Page