Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

EasyPHP-DevServer 13.1 "Unexpected end of mysql"

Tags:

easyphp

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.
like image 220
the tao Avatar asked Jun 13 '13 06:06

the tao


1 Answers

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):

  1. Exit EasyPHP Server
  2. Delete all ibd files resides in your mysql/data directory.
  3. 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).
  4. Stop/Exit the EasyPHP Server
  5. Copy all the backup ibd files to its respective locations.
  6. Restart EasyPHP Server.
like image 118
kai_desu Avatar answered Feb 22 '23 17:02

kai_desu