innodb_force_recovery =<\/span> 1<\/span><\/pre><\/div><\/div>\nThen save the file<\/p>\n
Restart mysqld by using the following command:<\/p>\n
<\/a>Source code<\/a><\/td> <\/a> <\/a> <\/a> <\/td><\/tr><\/table><\/div>service mysqld restart<\/pre><\/div><\/div>\nIt should now work. If the server started with OK then it worked.<\/p>\n
Go back and disable the innodb recovery by either removing the line or just adding a # at the front.<\/p>\n
Hopefully this has fixed your issue.<\/p>\n<\/a><\/p>\n
RESOURCES<\/div>Here’s a list of resources that you might find useful:<\/p>\nMore information about innodb force recovery: Click here<\/a><\/p>\n<\/div><\/div>\n
 <\/p>\n
 <\/p>\n
DO YOU LIKE WHAT YOU'VE READ?<\/div>Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!\r\n\r\n
\n\n\nName<\/label>\n<\/div>\nEmail<\/label>\n<\/div>\n\n<\/div>\n<\/form>\n<\/div>\n<\/p>\r\n\r\n<\/div><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"My VPS server experienced an issue with mySQL server and thought I’d better document how to resolve it in case it happens again. The symptoms An Error message saying unable to connect to the database comes up when trying to access websites using WordPress Manually starting the mysqld came back with “Failed”- using the command […]<\/p>\n","protected":false},"author":1,"featured_media":3571,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[1640,747,174,51],"class_list":["post-3540","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-back","tag-mysql","tag-recovery","tag-work"],"_links":{"self":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/3540","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/comments?post=3540"}],"version-history":[{"count":7,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/3540\/revisions"}],"predecessor-version":[{"id":28034,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/posts\/3540\/revisions\/28034"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/media\/3571"}],"wp:attachment":[{"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/media?parent=3540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/categories?post=3540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.businesslegions.com\/blog\/wp-json\/wp\/v2\/tags?post=3540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}