InnoDB: Attempted to open a previously opened tablespace
I had the same problem. I tried all the solution others has proposed, and unfortunately nothing worked.
After spending hours on searching for the solution in Google I finally found this
- 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.
I got the same error. These are the steps I followed.
Took the backup of \xampp\mysql\data
Removed all the files and folders from data folder except
mysqlQuit and started the XAMPP again.
Move the databases from
datafolder one by one.
try to rename /Applications/XAMPP/xamppfiles/var/mysql/ib_logfile0 to /Applications/XAMPP/xamppfiles/var/mysql/ib_logfile0.bkp
and /Applications/XAMPP/xamppfiles/var/mysql/ib_logfile1 to /Applications/XAMPP/xamppfiles/var/mysql/ib_logfile1.bkp