Page 1 of 1

MySQL dose not start !!!

PostPosted: 07. August 2013 20:25
by ibrahimdaas
Hi
I have a proplem with my local server
I used to open it normally ... today I try to open it , I start Apache normally and it turned green as normal , but when I try to press the Mysql start button it did not turn green and did not work and keep giving me : "Attempting to start MySQL service...." and Mysql dose not start ... what can I do ? shall I reinstall every thing or what I can do ?


•My OS version : Windows 7 Home Premium SP1 64-bit

•My XAMPP version (version number 1.8.1 .... the type (full, exe)

• installation path is c:/xampp

•informations about changes in the config files if any done/ nothing have done ... I used to work normally then this peoplem came

•full contents of your XAMPP control panel log window
===============================
the Control Panel is look like this ; -

11:26:45 PM [main] Initializing Control Panel
11:26:45 PM [main] Windows Version: Windows 7 Home Premium SP1 64-bit
11:26:45 PM [main] XAMPP Version: 1.8.1
11:26:45 PM [main] Control Panel Version: 3.1.0 3.1.0 [ Compiled: September 20th 2012 ]
11:26:45 PM [main] Running with Administrator rights - good!
11:26:45 PM [main] XAMPP Installation Directory: "c:\xampp\"
11:26:45 PM [main] Checking for prerequisites
11:26:45 PM [main] All prerequisites found
11:26:45 PM [main] Initializing Modules
11:26:45 PM [main] Enabling autostart for module "Apache"
11:26:45 PM [main] Enabling autostart for module "MySQL"
11:26:45 PM [main] Starting Check-Timer
11:26:45 PM [main] Control Panel Ready
11:26:46 PM [Apache] Autostart active: starting...
11:26:46 PM [Apache] Attempting to start Apache service...
11:26:57 PM [mysql] Autostart active: starting...
11:26:57 PM [mysql] Attempting to start MySQL service...
11:26:58 PM [Apache] Status change detected: running

===============================

mysql_error.log file is look like this :

130426 2:18:53 [Note] Plugin 'FEDERATED' is disabled.
130426 2:18:53 InnoDB: The InnoDB memory heap is disabled
130426 2:18:53 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130426 2:18:53 InnoDB: Compressed tables use zlib 1.2.3
130426 2:18:53 InnoDB: Initializing buffer pool, size = 16.0M
130426 2:18:53 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
130426 2:18:53 InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130426 2:18:54 InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130426 2:18:54 InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
130510 15:48:18 [Note] Event Scheduler: Purging the queue. 0 events
130510 15:48:18 InnoDB: Starting shutdown...
130510 15:48:19 InnoDB: Shutdown completed; log sequence number 8907989
130510 15:48:19 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete
130621 1:47:21 [Note] Server socket created on IP: '0.0.0.0'.
130621 1:47:31 [Note] Event Scheduler: Loaded 0 events
130621 1:47:31 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
130621 2:33:56 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown
.....etc could not paste all the log file because it is too long ....

Re: MySQL dose not start !!!

PostPosted: 07. August 2013 20:37
by Nobbie
Rather poor information - but - possibly same problem as here: viewtopic.php?f=16&t=61387

Read carefully and follow the supplied link to MySQL Bugs Database. Good luck!

Re: MySQL dose not start !!!

PostPosted: 07. August 2013 20:48
by ibrahimdaas
Thanks for your replay .. that link did not work for me ... what kind of extra information you think I should provide ? because I REALLY NEW TO ALL THIS

Re: MySQL dose not start !!!

PostPosted: 07. August 2013 20:59
by Altrea
ibrahimdaas wrote:what kind of extra information you think I should provide ?

maybe you should start with this missing important information:
ibrahimdaas wrote:.....etc could not paste all the log file because it is too long ....

Re: MySQL dose not start !!!

PostPosted: 07. August 2013 21:17
by Nobbie
ibrahimdaas wrote:Thanks for your replay .. that link did not work for me ... what kind of extra information you think I should provide ? because I REALLY NEW TO ALL THIS


Do you have a wordpress installation (or similar)?

Re: MySQL dose not start !!!

PostPosted: 08. August 2013 18:39
by ibrahimdaas
Yeas .. I have a wordpress... I removed now all the XAMPP program and will instal the latest one (xampp-win32-1.8.3-0-VC11-installer) I need to setup a word press site , do you recommend to instal (bitnami-wordpress-3.6-0-module-windows-installer) ?