WampServer

The first part I copied from someone else on this forum, cause i have the same error, but I couldn't find ANY answers on the internet..

----

i have wamp2.2 . It was working perfect and now it has started showing error.
Local host and all other works perfectly

When i try to access phpmyadmin it shows an error

Error

MySQL said: Documentation
#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).


apache - error log

Error

MySQL said: Documentation
#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 wamp server icon stays orange the whole time, mysql wont start. I think the problem could be find in de wamp/bin/mysql folder. Cause when I installed xampp and I copied only the mysql folder from wamp to xampp the same error occurs.

Please help me, or tell me how I can export my databases without using phpmyadmin.

Thanks!

WAMP and XAMPP are basically the same thing.

So they both installed Apache and MySQL onto your system.

Make sure XAMPP's MySQL and Apache are not running when you want to run WAMP's Apache and MySQL, or they will interfeer with each other and you will get unpredictable results.

Your problem is you probably have XAMMP's MySQL running so WAMP's MySQL wont run

Thanks for your answer. But thats not the problem. When the error showed up the first time i didnt have xampp istalled.. But i did delete it a few hours ago also..

Have you still got the problem?

Also when you say deleted XAMPP, do you mean uninstall or just delete the xampp folders????



Edited 1 time(s). Last edit at 06/20/2013 05:12PM by RiggsFolly.

Still the same problem. I did really uninstall it. I've been searching online for about two days and I tried absolutely everything.

I am Dutch and therefor my laptop is installed in Dutch too, but maybe you can try to help me by using teamviewer?,

Here you can see a piece of my mysql log:


130620 17:11:22 [Note] Plugin 'FEDERATED' is disabled.
130620 17:11:23 InnoDB: The InnoDB memory heap is disabled
130620 17:11:23 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130620 17:11:23 InnoDB: Compressed tables use zlib 1.2.3
130620 17:11:24 InnoDB: Initializing buffer pool, size = 128.0M
130620 17:11:24 InnoDB: Completed initialization of buffer pool
130620 17:11:24 InnoDB: highest supported file format is Barracuda.
130620 17:11:36 InnoDB: Waiting for the background threads to start
130620 17:11:37 InnoDB: 1.1.8 started; log sequence number 19810968
130620 17:11:37 [ERROR] I/O error reading the header from the binary log, errno=175, io cache code=0
130620 17:11:37 [ERROR] I/O error reading the header from the binary log
130620 17:11:37 [ERROR] Can't init tc log
130620 17:11:37 [ERROR] Aborting

130620 17:11:37 InnoDB: Starting shutdown...
130620 17:11:37 InnoDB: Shutdown completed; log sequence number 19810968
130620 17:11:37 [Note] wampmysqld: Shutdown complete

130620 17:12:35 [Note] Plugin 'FEDERATED' is disabled.
130620 17:12:35 InnoDB: The InnoDB memory heap is disabled
130620 17:12:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130620 17:12:35 InnoDB: Compressed tables use zlib 1.2.3
130620 17:12:35 InnoDB: Initializing buffer pool, size = 128.0M
130620 17:12:35 InnoDB: Completed initialization of buffer pool
130620 17:12:35 InnoDB: highest supported file format is Barracuda.
130620 17:12:50 InnoDB: Waiting for the background threads to start
130620 17:12:51 InnoDB: 1.1.8 started; log sequence number 19810968
130620 17:12:51 [ERROR] I/O error reading the header from the binary log, errno=175, io cache code=0
130620 17:12:51 [ERROR] I/O error reading the header from the binary log
130620 17:12:51 [ERROR] Can't init tc log
130620 17:12:51 [ERROR] Aborting

130620 17:12:51 InnoDB: Starting shutdown...
130620 17:12:53 InnoDB: Shutdown completed; log sequence number 19810968
130620 17:12:53 [Note] wampmysqld: Shutdown complete

130620 17:19:06 [Note] Plugin 'FEDERATED' is disabled.
130620 17:19:06 InnoDB: The InnoDB memory heap is disabled
130620 17:19:06 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130620 17:19:06 InnoDB: Compressed tables use zlib 1.2.3
130620 17:19:06 InnoDB: Initializing buffer pool, size = 128.0M
130620 17:19:06 InnoDB: Completed initialization of buffer pool
130620 17:19:06 InnoDB: highest supported file format is Barracuda.
130620 17:19:07 InnoDB: Waiting for the background threads to start
130620 17:19:08 InnoDB: 1.1.8 started; log sequence number 19810968
130620 17:19:08 [ERROR] I/O error reading the header from the binary log, errno=175, io cache code=0
130620 17:19:08 [ERROR] I/O error reading the header from the binary log
130620 17:19:08 [ERROR] Can't init tc log
130620 17:19:08 [ERROR] Aborting

130620 17:19:08 InnoDB: Starting shutdown...
130620 17:19:08 InnoDB: Shutdown completed; log sequence number 19810968
130620 17:19:08 [Note] wampmysqld: Shutdown complete

Do you have you database backed up?

It looks like you have got the innodb log files out of step, probably by having 2 mysql's running and not sure which was doing what.

Try deleting the ib_logfile0 and ib_logfile1 from c:\wamp\bin\mysql\mysql5.x.y\data and then restart mysql.

I would then do a RESET MASTER and restore your databases.