Softaculous

Topic : mySQL doesn't start

Posted By: sluiting on September 22, 2014, 4:26 pm

Hi,

Apache starts but mySQL doesn't. Any ideas on what to do?

Error log:

2014-09-22 09:46:20 6752 [Warning] You need to use --log-bin to make --binlog-format work.
2014-09-22 09:46:20 6752 [Note] Plugin 'FEDERATED' is disabled.
2014-09-22 09:46:20 6752 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-09-22 09:46:20 6752 [Note] InnoDB: The InnoDB memory heap is disabled
2014-09-22 09:46:20 6752 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-09-22 09:46:20 6752 [Note] InnoDB: Memory barrier is not used
2014-09-22 09:46:20 6752 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-09-22 09:46:20 6752 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-22 09:46:20 6752 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-09-22 09:46:20 6752 [Note] InnoDB: Completed initialization of buffer pool
2014-09-22 09:46:20 6752 [Note] InnoDB: Highest supported file format is Barracuda.
2014-09-22 09:46:20 6752 [Note] InnoDB: The log sequence numbers 1600637 and 1600637 in ibdata files do not match the log

Posted By: ketan on September 23, 2014, 6:24 am | Post: 1

Hi,

Which OS version you are using?
Could you please attach the complete MySQL error logs here? Alternately you can email the complete logs at support@ampps.com

-----------------------
Follow AMPPS on,
Twitter
Facebook
Google+

Posted By: sluiting on September 24, 2014, 7:57 pm | Post: 2

Here's the error log. I reinstalled it and it worked until I shut down and restarted my machine. I am using Win7

Posted By: sluiting on September 24, 2014, 7:58 pm | Post: 3

Wouldn't take ythe extension as an attachment. Here is the log file as a txt file.

Posted By: ketan on September 25, 2014, 6:16 am | Post: 4

Hi,

1. Open Ampps Application -> MySQL Tab -> Configuration.

2. In [mysqld] section, add the following line:
innodb_force_recovery = 1

3. Save the file and try starting MySQL

4. Remove that line which you just added and Save.

Please let us know if you still facing the problem.

-----------------------
Follow AMPPS on,
Twitter
Facebook
Google+

Posted By: sluiting on September 25, 2014, 12:19 pm | Post: 5

That did it. What do you think it is?