Announcement

Collapse
No announcement yet.

Default storage engine (InnoDB) is not available

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Default storage engine (InnoDB) is not available

    Hello,

    On your windows server if the MYSQL service is stopped and giving the following error in the eventviewer logs, then please refer to the steps given below to resolve the issue:


    Default storage engine (InnoDB) is not available
    1. On the Windows server, go to the path "%Plesk_dir%\Databases\MySQL\data"

    2. Search for the below files and delete or rename it:
    _ib_logfile0
    _ib_logfile1

    3. Once the 2nd step has been followed, restart the MYSQL service.


    Regards,
    Euk:Mary
    Support Department

  • #2
    Re: Default storage engine (InnoDB) is not available

    As per your suggestion it looks like if the innodb log file size specified in my.cnf does not match with the size of the existing log files on the disk, then this error message occurs. Am I right? Or there are some other reasons?

    Comment


    • #3
      Re: Default storage engine (InnoDB) is not available

      Originally posted by Irene9001 View Post
      As per your suggestion it looks like if the innodb log file size specified in my.cnf does not match with the size of the existing log files on the disk, then this error message occurs. Am I right? Or there are some other reasons?
      The problem is most probably a non-matching log file size, mysql expects the innodb log files to be exactly the size that is specified in the config file.
      "It Takes 20 Years To Build A Reputation And Five Minutes To Ruin It. If You Think About That, You'll Do Things Differently. "

      Comment

      Working...
      X