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

  • PMagic
    replied
    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.

    Leave a comment:


  • Irene9001
    replied
    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?

    Leave a comment:

Working...
X