EasyPHP-DevServer 13.1 "Unexpected end of mysql"
Every time I install EasyPHP 13.1VC9 it works for a few days and then at random points when I go to turn it on I get this error and I am unable to start MySQL. I have tried running as Admin, and I have tried editing the permissions. Also, when I go to access MYSQL through PHPadmin I get the following error:
#2002 - No connection could be made because the target machine actively refused it.
This is what the log files say:
2013-06-12 23:47:18 4148 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_index_stats uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd. Cannot open tablespace userauth/userinfo which uses space ID: 2 at filepath: .\userauth\userinfo.ibd
InnoDB: Error: could not open single-table tablespace file .\userauth\userinfo.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
Answer
This is a bug with MySQL 5.6.11 - The EasyPHP website says to upgrade to MySQL 5.6.12 to fix this, but I've encountered the same exact issue regardless.
Through some tracking down, I ran across that it's due to shutting down / restarting your computer while EasyPHP is still running (via their Facebook page).
A working solution seems to be the following (source):
- Exit EasyPHP Server
- Delete all ibd files resides in your mysql/data directory.
- Restart the server, make sure it starts (but your MySQL will not be functioning correctly and thus the sites won't display correctly in most cases as there is no database available).
- Stop/Exit the EasyPHP Server
- Copy all the backup ibd files to its respective locations.
- Restart EasyPHP Server.