I have installed Xampp 1.8.1 on Windows 7 and my apache and mysql are apparently running fine. But after running for one or two days, mysql suddenly stops working. But at the xampp control panel, it is still showing green on the mysql item. I can fix this just by stopping and restarting mysql from the xampp control panel. Then it will again work fine and the situation will occur again in a day or two and I have to keep doing this (stopping mysql and restarting). How can I fix this problem permanently.
mysql error log is given below...
130804 12:49:09 [Note] Plugin 'FEDERATED' is disabled.
130804 12:49:09 InnoDB: The InnoDB memory heap is disabled
130804 12:49:09 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130804 12:49:09 InnoDB: Compressed tables use zlib 1.2.3
130804 12:49:09 InnoDB: Initializing buffer pool, size = 16.0M
130804 12:49:09 InnoDB: Completed initialization of buffer pool
130804 12:49:09 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130804 12:49:09 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130804 12:49:14 InnoDB: Waiting for the background threads to start
130804 12:49:15 InnoDB: 1.1.8 started; log sequence number 1595675
130804 12:49:15 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130804 12:49:15 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130804 12:49:15 [Note] Server socket created on IP: '0.0.0.0'.
130804 12:49:16 [Note] Event Scheduler: Loaded 0 events
130804 12:49:16 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
130805 17:45:20 [Note] Plugin 'FEDERATED' is disabled.
130805 17:45:20 InnoDB: The InnoDB memory heap is disabled
130805 17:45:20 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130805 17:45:20 InnoDB: Compressed tables use zlib 1.2.3
130805 17:45:20 InnoDB: Initializing buffer pool, size = 16.0M
130805 17:45:20 InnoDB: Completed initialization of buffer pool
130805 17:45:20 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130805 17:45:20 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130805 17:45:20 InnoDB: Waiting for the background threads to start
130805 17:45:21 InnoDB: 1.1.8 started; log sequence number 1595675
130805 17:45:21 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130805 17:45:21 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130805 17:45:21 [Note] Server socket created on IP: '0.0.0.0'.
130805 17:45:21 [Note] Event Scheduler: Loaded 0 events
130805 17:45:21 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
The Xampp control panel log is here...
12:49:06 PM [main] Initializing Control Panel
12:49:06 PM [main] Windows Version: Windows 7 Ultimate 64-bit
12:49:06 PM [main] XAMPP Version: 1.8.1
12:49:06 PM [main] Control Panel Version: 3.1.0 3.1.0 [ Compiled: September 20th 2012 ]
12:49:06 PM [main] Running with Administrator rights - good!
12:49:06 PM [main] XAMPP Installation Directory: "c:\xampp\"
12:49:06 PM [main] Checking for prerequisites
12:49:07 PM [main] All prerequisites found
12:49:07 PM [main] Initializing Modules
12:49:07 PM [main] Enabling autostart for module "Apache"
12:49:07 PM [main] Enabling autostart for module "MySQL"
12:49:07 PM [main] Enabling autostart for module "FileZilla"
12:49:07 PM [main] Starting Check-Timer
12:49:07 PM [main] Control Panel Ready
12:49:08 PM [Apache] Autostart active: starting...
12:49:08 PM [Apache] Attempting to start Apache app...
12:49:08 PM [mysql] Autostart active: starting...
12:49:08 PM [mysql] Attempting to start MySQL app...
12:49:08 PM [filezilla] Autostart active: starting...
12:49:08 PM [filezilla] Attempting to start FileZilla app...
12:49:09 PM [Apache] Status change detected: running
12:49:09 PM [mysql] Status change detected: running
12:49:09 PM [filezilla] Status change detected: running
5:45:18 PM [mysql] Attempting to stop MySQL (PID: 3484)
5:45:18 PM [mysql] Status change detected: stopped
5:45:20 PM [mysql] Attempting to start MySQL app...
5:45:20 PM [mysql] Status change detected: running
I tried to click on the red cross beside mysql to run it as a service, the problem still remains. Thanks in advance for your help.