{"id":34,"date":"2015-07-04T08:03:00","date_gmt":"2015-07-04T08:03:00","guid":{"rendered":"https:\/\/www.tech-and-dev.com\/blog\/2015\/07\/04\/how-to-fix-innodb-enabled-but-not-starting\/"},"modified":"2021-02-22T01:04:12","modified_gmt":"2021-02-22T01:04:12","slug":"how-to-fix-innodb-enabled-but-not-starting","status":"publish","type":"post","link":"https:\/\/www.tech-and-dev.com\/blog\/2015\/07\/how-to-fix-innodb-enabled-but-not-starting.html","title":{"rendered":"How To Fix: InnoDB Enabled But Not Starting"},"content":{"rendered":"
\n
\"InnoDB<\/a><\/div>\n

This is for CentOS, but it should work on Debian\/Ubuntu as well. There are two reasons why InnoDB would not start:<\/p>\n

    \n
  1. It’s not enabled in my.cnf<\/li>\n
  2. The log files are corrupted<\/li>\n<\/ol>\n

    <\/a><\/p>\n

    1- Enabling InnoDB From my.cnf<\/h2>\n

    Open my.cnf<\/p>\n

    vi \/etc\/my.cnf<\/pre>\n
    Find and Delete –skip-innodb<\/b><\/i>
    \nand save my.cnf<\/p>\n
    Restart MySQL<\/p>\n
    \/etc\/init.d\/mysql restart<\/pre>\n
     <\/p>\n
    2- Re-create The Log Files<\/h2>\n
    Sometimes InnoDB won’t start even if it’s enabled from my.cnf. Most of the times, the reason is because the log files are corrupted.<\/div>\n
    <\/div>\n
    When these log files are corrupted, MySQL will skip InnoDB storage engine and will not start it.<\/div>\n
    <\/div>\n
    To fix this, MySQL has to be stopped, the log files has to be removed, and MySQL should be restarted. This will re-create the log files and start InnoDB storage engine.<\/div>\n
     <\/p>\n
    #Stopping MySQL\r\n\/etc\/init.d\/mysql stop\r\n#Renaming Log Files to keep them as a backup\r\nmv \/var\/lib\/mysql\/ib_logfile0 \/var\/lib\/mysql\/ib_logfile0.bak\r\nmv \/var\/lib\/mysql\/ib_logfile1 \/var\/lib\/mysql\/ib_logfile1.bak\r\n#Restarting MySQL\r\n\/etc\/init.d\/mysql start<\/pre>\n
    Any Questions? Please let me know below!<\/b><\/p>\n
     <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
    This is for CentOS, but it should work on Debian\/Ubuntu as well. There are two reasons why InnoDB would not start: It’s not enabled in my.cnf The log files are corrupted 1- Enabling InnoDB From my.cnf Open my.cnf vi \/etc\/my.cnf Find and Delete –skip-innodb and save my.cnf Restart MySQL \/etc\/init.d\/mysql restart   2- Re-create The […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[46,6,45,7],"tags":[],"class_list":["post-34","post","type-post","status-publish","format-standard","hentry","category-innodb","category-linux","category-mysql","category-ssh"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/posts\/34","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/comments?post=34"}],"version-history":[{"count":1,"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/posts\/34\/revisions"}],"predecessor-version":[{"id":318,"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/posts\/34\/revisions\/318"}],"wp:attachment":[{"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/media?parent=34"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/categories?post=34"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/tags?post=34"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}