WampServer

Hi
I have a bit of a problem with mysql on wampserver, everything has been working fine for the last year, however today when i started the wampserver the icon stayed orange, and the mysql would not start.

I can access localhost but if I goto phpmyadmin I get the following message:


#2002 - No connection could be made because the target machine actively refused it.

The server is not responding (or the local server's socket is not correctly configured).

The log file gives thh following message:


140214 22:16:15 [Note] Plugin 'FEDERATED' is disabled.
140214 22:16:15 InnoDB: The InnoDB memory heap is disabled
140214 22:16:15 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140214 22:16:15 InnoDB: Compressed tables use zlib 1.2.3
140214 22:16:15 InnoDB: Initializing buffer pool, size = 128.0M
140214 22:16:15 InnoDB: Completed initialization of buffer pool
140214 22:16:15 InnoDB: highest supported file format is Barracuda.
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: [dev.mysql.com]
140214 22:16:15 [ERROR] Plugin 'InnoDB' init function returned error.
140214 22:16:15 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140214 22:16:15 [ERROR] Unknown/unsupported storage engine: InnoDB
140214 22:16:15 [ERROR] Aborting

140214 22:16:15 [Note] wampmysqld: Shutdown complete




I've seen several other people with teh same issue and followed various solutions but have had no luck resolving this.

I am not using port 80 because I have skype and dropbox installed but this has never been an issue before and it has always worked fine.

This is running on Windows 8.0
Wamp Server version 2.2
Apache version 2.2.22
MySQL version 5.5.24
PHP version 5.3.13

I did have a malware scan run today and it deleted a few files so not sure if something was deleted.

can anyone help me please. Not too sure what to do, cant risk reinstalling as I have some jobs that are not backup up anywhere and cant really lose them.

thanks in advance for any advice and help

Are you using any innodb database?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hi
Not that I know of. It's just a standard wampserver installation

I host just wordpress installations and couple of HTML. Nothing else.

Thanks

Then try this

delete these files from \wamp\bin\mysql\mysqlx.y.z\data\

ibdate1
ib_logfile0
ib_logfile1

This will delete all the innodb databases and logfiles, mysql should restart and rebuild them as empty databases.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hi

Thanks again for the reply, its getting somewhere

So I cut the 3 files and pasted them into a temp directory, loaded wampserver, and everything loaded, however every site i was going to just kept going to the wordpress installation page.

I closed wampserver and pasted back in the file ibdata1 (its just over 100mb), then restarted wampserver, everything loaded ok.

howver the error log shows something strange:



140215 23:23:23 [Note] Plugin 'FEDERATED' is disabled.
140215 23:23:23 InnoDB: The InnoDB memory heap is disabled
140215 23:23:23 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140215 23:23:23 InnoDB: Compressed tables use zlib 1.2.3
140215 23:23:23 InnoDB: Initializing buffer pool, size = 128.0M
140215 23:23:23 InnoDB: Completed initialization of buffer pool
140215 23:23:23 InnoDB: highest supported file format is Barracuda.
140215 23:23:23 InnoDB: Error: page 7 log sequence number 457282377
InnoDB: is in the future! Current system log sequence number 1755105.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: [dev.mysql.com]
InnoDB: for more information.
140215 23:23:23 InnoDB: Error: page 1 log sequence number 457282592
InnoDB: is in the future! Current system log sequence number 1755105.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: [dev.mysql.com]
InnoDB: for more information.


with the last 6 lines repeated about 100 times with different page number and different sequence numbers.

If I was to backup all the databases now, and delete everything off the wampserver, then delete them files should it resolve the problem? or is there a simpler way?

or even just install a newer version of mysql, i'm currently using 5.5.24 and checked the website earlier but there is only 5.1 on the website.

thanks again for the help

very much appreciated

I was thinking i was going to have a very stressful monday

Well paste back all 3 files, they are a set. I guess you did have a n innodb database.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

I tried pasting back all 3 but then it stops working again.

I think you have lost those databases. You may need to remove those files again and restore the databases, or re-create them.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Thanks for all the advice. Think I may try snd backup what I can and delete all wampserver websites. Then delete then files and let it recreate them.

While I'm doing this can you advise if there is a link for a newer version of MySQL for wampserver. The ones on the wampserver website are very out of date

Thanks again