Enrico Boldori / Wiki

« Go back ⤓ Download

MySQL - Innodb error - Attempted to open a previously opened tablespace.txt

Questo errore può verificarsi a seguito dello spegnimento forzato di un server.
Soluzione: https://stackoverflow.com/questions/33829888/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