Skip to content

Instantly share code, notes, and snippets.

@basoro

basoro/MySQL won't start

Created August 23, 2019 21:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save basoro/f1b0f3fc2261f7d2cc2117785f1d322a to your computer and use it in GitHub Desktop.
Save basoro/f1b0f3fc2261f7d2cc2117785f1d322a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MySQL won't start
InnoDB: Attempted to open a previously opened tablespace
Open my.ini (my.cnf on linux-based systems and Mac)
Look for [mysqld]
Just below [mysqld] insert innodb_force_recovery = 1
Start MySQL Service
Stop MySQL Service
Remove the line from my.ini (innodb_force_recovery = 1)
Start MySQL Service
Worked perfect in my case.
I hope this will solve your problem.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment