Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : mySQL doesn't start



Threaded Mode | Print  

 mySQL doesn't start, Apache starts but not MySQL (5 Replies, Read 4861 times)
sluiting
Group: Member
Post Group: Working Member
Posts: 100
Status:
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
IP: --   

mySQL doesn't start
ketan
Group: Member
Post Group: Working Member
Posts: 241
Status:
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+
IP: --   

mySQL doesn't start
sluiting
Group: Member
Post Group: Working Member
Posts: 100
Status:
Here's the error log. I reinstalled it and it worked until I shut down and restarted my machine. I am using Win7
IP: --   

mySQL doesn't start
sluiting
Group: Member
Post Group: Working Member
Posts: 100
Status:
Wouldn't take ythe extension as an attachment. Here is the log file as a txt file.
IP: --   

mySQL doesn't start
ketan
Group: Member
Post Group: Working Member
Posts: 241
Status:
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+
IP: --   

mySQL doesn't start
sluiting
Group: Member
Post Group: Working Member
Posts: 100
Status:
That did it. What do you think it is?
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 28, 2024, 11:03 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.025