Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : MySQL not starting up


Poll
Poll Question : g
solucion mysql para ampps (0) (0%)
w (0) (0%)
w (0) (0%)
w (0) (0%)
w (0) (0%)
w (0) (0%)
w (0) (0%)
w (0) (0%)
w (0) (0%)
w (0) (0%)

Total Votes : 0


1


Threaded Mode | Print  

 MySQL not starting up, MySQL not starting on Mac OSX Mountain Lion (30 Replies, Read 287799 times)
thokkalodi
Group: Member
Post Group: Newbie
Posts: 15
Status:
Hello,
I'm using AMPPS 2 on Mac OS X Mountain Lion 10.8.3.

Everything was working fine until yesterday. But today I'm trying to start MySQL and it doesn't start up. Apache starts up fine.
I looked up the error Log Files and these are the messages that I found

Code

130502 10:47:03 InnoDB: The InnoDB memory heap is disabled
130502 10:47:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130502 10:47:03 InnoDB: Compressed tables use zlib 1.2.3
130502 10:47:03 InnoDB: Initializing buffer pool, size = 128.0M
130502 10:47:03 InnoDB: Completed initialization of buffer pool
130502 10:47:03 InnoDB: highest supported file format is Barracuda.
130502 10:47:03  InnoDB: Waiting for the background threads to start
130502 10:47:04 InnoDB: 1.1.8 started; log sequence number 1438711997
/Applications/AMPPS/mysql/bin/mysqld: File './mysql-bin.000108' not found (Errcode: 2)
130502 10:47:04 [ERROR] Failed to open log (file './mysql-bin.000108', errno 2)
130502 10:47:04 [ERROR] Could not open log file
130502 10:47:04 [ERROR] Can't init tc log
130502 10:47:04 [ERROR] Aborting

130502 10:47:04  InnoDB: Starting shutdown...
130502 10:47:05  InnoDB: Shutdown completed; log sequence number 1438711997
130502 10:47:05 [Note] /Applications/AMPPS/mysql/bin/mysqld: Shutdown complete
IP: --   

MySQL not starting up
tidus
Group: Member
Post Group: Super Member
Posts: 1121
Status:
Hi,

Delete all the files from /Applications/AMPPS/var/ like mysql-bin.*,  mysql-bin.index, ib*, etc and try starting the mysql server. DONT REMOVE ANY FOLDER.


-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook :  http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack
IP: --   

MySQL not starting up
thokkalodi
Group: Member
Post Group: Newbie
Posts: 15
Status:
Wow that was quick!
Thanks that worked :) .

Once again thanks for the quick reply.
IP: --   

MySQL issue A connection attempt failed
fillcraft
Group: Member
Post Group: Newbie
Posts: 3
Status:
I tried to find the solution first, nothing worked for me.

Problem:

I had wamp and ammps installed on same PC, Windows Ultimate 7 SP1. My Antivirus is Avast internet seurity 2014.
I deleted wamp from my system without uninstalling it.
My ammps stoped working phpmyadmin shows following error

#2002
- A connection attempt failed because the connected party did not
properly respond after a period of time, or established connection
failed because connected host has failed to respond.

The server is not responding (or the local server's socket is not correctly configured).

MySQL error log

2013-10-29 10:10:41 1228 [Note] Plugin 'FEDERATED' is disabled.
2013-10-29 10:10:41 1228 [Note] InnoDB: The InnoDB memory heap is disabled
2013-10-29 10:10:41 1228 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-10-29 10:10:41 1228 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-10-29 10:10:41 1228 [Note] InnoDB: Not using CPU crc32 instructions
2013-10-29 10:10:41 1228 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-10-29 10:10:42 1228 [Note] InnoDB: Completed initialization of buffer pool
2013-10-29 10:10:42 1228 [Note] InnoDB: The first specified data file .\ibdata1 did not exist: a new database to be created!
2013-10-29 10:10:42 1228 [Note] InnoDB: Setting file .\ibdata1 size to 12 MB
2013-10-29 10:10:42 1228 [Note] InnoDB: Database physically writes the file full: wait...
2013-10-29 10:10:43 1228 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB
2013-10-29 10:10:49 1228 [Note] InnoDB: Setting log file .\ib_logfile1 size to 48 MB
2013-10-29 10:10:52 1228 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2013-10-29 10:10:52 1228 [Warning] InnoDB: New log files created, LSN=45781
2013-10-29 10:10:52 1228 [Note] InnoDB: Doublewrite buffer not found: creating new
2013-10-29 10:10:52 1228 [Note] InnoDB: Doublewrite buffer created
2013-10-29 10:10:52 1228 [Note] InnoDB: 128 rollback segment(s) are active.
2013-10-29 10:10:54 1228 [Warning] InnoDB: Creating foreign key constraint system tables.
2013-10-29 10:10:54 1228 [Note] InnoDB: Foreign key constraint system tables created
2013-10-29 10:10:54 1228 [Note] InnoDB: Creating tablespace and datafile system tables.
2013-10-29 10:10:54 1228 [Note] InnoDB: Tablespace and datafile system tables created.
2013-10-29 10:10:54 1228 [Note] InnoDB: Waiting for purge to start
2013-10-29 10:10:54 1228 [Note] InnoDB: 5.6.14 started; log sequence number 0
2013-10-29 10:10:54 1228 [Note] Server hostname (bind-address): '*'; port: 3306
2013-10-29 10:10:54 1228 [Note] IPv6 is available.
2013-10-29 10:10:54 1228 [Note]  - '::' resolves to '::';
2013-10-29 10:10:54 1228 [Note] Server socket created on IP: '::'.
2013-10-29
10:10:56 1228 [Warning] InnoDB: Cannot open table
mysql/slave_master_info from the internal data dictionary of InnoDB
though the .frm file for the table exists. See
http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for
how you can resolve the problem.
2013-10-29 10:10:56 1228 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2013-10-29
10:10:56 1228 [Warning] InnoDB: Cannot open table
mysql/slave_worker_info from the internal data dictionary of InnoDB
though the .frm file for the table exists. See
http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for
how you can resolve the problem.
2013-10-29 10:10:56 1228 [Warning]
InnoDB: Cannot open table mysql/slave_relay_log_info from the internal
data dictionary of InnoDB though the .frm file for the table exists. See
http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for
how you can resolve the problem.
2013-10-29 10:10:56 1228 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2013-10-29 10:10:57 1228 [Note] Event Scheduler: Loaded 0 events
2013-10-29 10:10:57 1228 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.14-log'  socket: ''  port: 3306  MySQL Community Server (GPL)

Solutions I adopted:
1. what ever I found online, did not work.
2. Restored the wamp and properly uninstalled it, then uninstalled ammps.
and reinstalled ammps.

Conclusion:
Mysql
is not working for me. I also noticed when I tried to stop the mysql
from UI it does not stop either, when I close the ammp mysqld.exe still
remain in task manager
IP: --   

MySQL not starting up
ddpkwisc
Group: Member
Post Group: Newbie
Posts: 1
Status:
I encountered the same problem as thokkalodi (the person originally posting the problem). The only difference is that I am using AMPPS on Windows 7. I noticed the problem after updating AMPPS.

As recommended above by tidus, I located the following directory:

path/to/Ampps/mysql/data

then I removed the following files:

ib_logfile0
ib_logfile1
ib_logfile101
mysql-bin.000001
mysql-bin.000002
mysql-bin.000003
mysql-bin.000004
mysql-bin.index

Then I restarted AMPPS, and it worked fine.

In other words, it appears this post also contains the solution for Windows users too.

Thanks!

IP: --   

MySQL not starting up
fillcraft
Group: Member
Post Group: Newbie
Posts: 3
Status:
Quote From : ddpkwisc November 24, 2013, 9:19 pm
I encountered the same problem as thokkalodi (the person originally posting the problem). The only difference is that I am using AMPPS on Windows 7. I noticed the problem after updating AMPPS.

As recommended above by tidus, I located the following directory:

path/to/Ampps/mysql/data

then I removed the following files:

ib_logfile0
ib_logfile1
ib_logfile101
mysql-bin.000001
mysql-bin.000002
mysql-bin.000003
mysql-bin.000004
mysql-bin.index

Then I restarted AMPPS, and it worked fine.

In other words, it appears this post also contains the solution for Windows users too.

Thanks!



I tried to follow this process but nothing worked for me. any other solution please
IP: --   

MySQL not starting up
ketan
Group: Member
Post Group: Working Member
Posts: 241
Status:
Hi,

Which OS you are using?
Please attach the complete MySQL error logs here.

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

MySQL not starting up
ChronicD
Group: Member
Post Group: Newbie
Posts: 4
Status:
Quote From : fillcraft December 11, 2013, 1:50 pm
Quote From : ddpkwisc November 24, 2013, 9:19 pm
I encountered the same problem as thokkalodi (the person originally posting the problem). The only difference is that I am using AMPPS on Windows 7. I noticed the problem after updating AMPPS.

As recommended above by tidus, I located the following directory:

path/to/Ampps/mysql/data

then I removed the following files:

ib_logfile0
ib_logfile1
ib_logfile101
mysql-bin.000001
mysql-bin.000002
mysql-bin.000003
mysql-bin.000004
mysql-bin.index

Then I restarted AMPPS, and it worked fine.

In other words, it appears this post also contains the solution for Windows users too.

Thanks!



I tried to follow this process but nothing worked for me. any other solution please


I folowed these instructions on windows 7 and it worked like a charm.

Specifically I navigated to path/to/Ampps/mysql/data

and created a folder called backup and pout everything in it that wasn't a folder

badabing badaboom hey presto it worked

IP: --   

MySQL not starting up
tidus
Group: Member
Post Group: Super Member
Posts: 1121
Status:
Hi,

This reply is for users who are being redirected on this post on search.

Please do not delete anything without taking backup.

And deleting ibdata*, ib_log*, etc files from mysql data directory is not a fix for every problem. Please open a ticket, if you are not able to start MySQL.


-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook :  http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack
IP: --   

MySQL not starting up
ChronicD
Group: Member
Post Group: Newbie
Posts: 4
Status:
Quote From : ChronicD December 29, 2013, 10:40 pm


I folowed these instructions on windows 7 and it worked like a charm.

Specifically I navigated to path/to/Ampps/mysql/data

and created a folder called backup and pout everything in it that wasn't a folder

badabing badaboom hey presto it worked



I just wanted to amend this by stating it doesn't work

Once the files have been moved/deleted Ampps remakes them (very cool). The result is akin to having a brand new mysql server launch i.e. any databases you had are gone.

Open a ticket :)

So Its NOT A FIX
IP: --   

MySQL not starting up
bluesky_c3
Group: Member
Post Group: Newbie
Posts: 10
Status:
I am encountering the same problem, suddenly MySQL won't start.

The error log contains more than 2000 words so I can't paste it here.

What should I do?
IP: --   

MySQL not starting up
tidus
Group: Member
Post Group: Super Member
Posts: 1121
Status:
Hi,

You can use http://pastebin.com to create the links for your mysql log and provide us the link at support@ampps.com or open a ticket at http://www.ampps.com/support


-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook :  http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack
IP: --   

MySQL not starting up
bluesky_c3
Group: Member
Post Group: Newbie
Posts: 10
Status:
This is the error log file link:

http://pastebin.com/5cu89jtQ

Appreciate your help!
IP: --   

MySQL not starting up
tidus
Group: Member
Post Group: Super Member
Posts: 1121
Status:
Hi,

Please take necessary backup before proceeding further.

  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.

You might want to fix the privileges of tables in wp182 database.

Also you can try following this post:
http://www.softaculous.com/board/index.php?tid=4584


-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook :  http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack
IP: --   

MySQL not starting up
bluesky_c3
Group: Member
Post Group: Newbie
Posts: 10
Status:
It is working now, thanks for your help.

There was something I should to know to do to avoid this situation in the future?
IP: --   

« Previous    Next »

Threaded Mode | Print  

1


Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 19, 2024, 8:46 am.

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