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




Normal Mode | Print  

MySQL not starting up
tidus
Group: Member
Post Group: Super Member
Posts: 1121
Status:
Quote From : sdowns May 13, 2014, 12:41 pm
I'm getting the same error after upgrading to 2.4 on Mavericks 10.9.2.

2014-05-13 13:36:11 8225 [Note] Plugin 'FEDERATED' is disabled.
2014-05-13 13:36:11 8225 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-05-13 13:36:11 8225 [Note] InnoDB: The InnoDB memory heap is disabled
2014-05-13 13:36:11 8225 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-05-13 13:36:11 8225 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-05-13 13:36:11 8225 [Note] InnoDB: Not using CPU crc32 instructions
2014-05-13 13:36:11 8225 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-05-13 13:36:11 8225 [Note] InnoDB: Completed initialization of buffer pool
2014-05-13 13:36:11 8225 [Note] InnoDB: Highest supported file format is Barracuda.
2014-05-13 13:36:11 8225 [Note] InnoDB: 128 rollback segment(s) are active.
2014-05-13 13:36:11 8225 [Note] InnoDB: Waiting for purge to start
2014-05-13 13:36:11 8225 [Note] InnoDB: 5.6.17 started; log sequence number 1600627
2014-05-13 13:36:12 8225 [Note] Server hostname (bind-address): '*'; port: 3306
2014-05-13 13:36:12 8225 [Note] IPv6 is available.
2014-05-13 13:36:12 8225 [Note]  - '::' resolves to '::';
2014-05-13 13:36:12 8225 [Note] Server socket created on IP: '::'.
2014-05-13 13:36:12 8225 [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.
2014-05-13 13:36:12 8225 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2014-05-13 13:36:12 8225 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2014-05-13 13:36:12 8225 [Note] Event Scheduler: Loaded 0 events
2014-05-13 13:36:12 8225 [Note] /Applications/AMPPS/mysql/bin/mysqld: ready for connections.
Version: '5.6.17-log'  socket: '/Applications/AMPPS/mysql/tmp/mysql.sock'  port: 3306  Source distribution

I have tried the following from this post and the other post mentioned:

1. adding innodb_force_recovery = 1 to config file
2. backup and move log files and mysql-bin files from /ampss/var
3. backup and move innodb files from /ampps/var/mysql


Hi,

Is you MySQL server not working ? Because I cannot find the error in the logs. Please open a ticket, we will look into it.


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


Threads
 thokkalodi   MySQL not starting up, MySQL not starting on Mac OSX Mountain Lion (30 Replies, Read 380937 times)
    |--  tidus   Hi, Delete all...   on May 2, 2013, 5:57 am
    |--  thokkalodi   Wow that was...   on May 2, 2013, 6:07 am
    |--  fillcraft   I tried to...   on October 29, 2013, 6:07 am
    |--  ddpkwisc   I encountered the...   on November 24, 2013, 9:19 pm
    |--  fillcraft   I encountered the...   on December 11, 2013, 1:50 pm
    |--  ketan   Hi, Which OS...   on December 12, 2013, 6:50 am
    |--  ChronicD   I encountered the...   on December 29, 2013, 10:40 pm
    |--  tidus   Hi, This reply...   on March 25, 2014, 6:15 am
    |--  ChronicD    I folowed these...   on March 25, 2014, 7:22 pm
    |--  bluesky_c3   I am encountering...   on May 6, 2014, 6:41 am
    |--  tidus   Hi, You can...   on May 6, 2014, 6:58 am
    |--  bluesky_c3   This is the...   on May 6, 2014, 7:00 am
    |--  tidus   Hi, Please take...   on May 6, 2014, 7:11 am
    |--  bluesky_c3   It is working...   on May 6, 2014, 7:47 am
    |--  tidus   Hi, Close MySQL...   on May 6, 2014, 7:49 am
    |--  bluesky_c3   Allright, guys! I...   on May 6, 2014, 7:50 am
    |--  sdowns   I'm getting the...   on May 13, 2014, 12:41 pm
    |--  tidus   I'm getting the...   on May 13, 2014, 1:30 pm
    |--  sdowns   I can see...   on May 13, 2014, 10:32 pm
    |--  sdowns   Right, I've restored...   on May 14, 2014, 7:45 am
    |--  z0quete   hi everybody! i...   on August 17, 2014, 2:17 pm
    |--  z0quete   hi everybody! i...   on August 17, 2014, 5:07 pm
    |--  imike   Hey guys. So...   on August 20, 2014, 5:03 pm
    |--  imike   I should add...   on August 20, 2014, 8:13 pm
    |--  azarzag   I seem to...   on September 1, 2014, 2:23 pm
    |--  codebrono   HOLA AMIGOS TUVE...   on October 19, 2014, 9:11 am
    |--  knkr   MYSQL DB is...   on June 25, 2015, 5:19 pm
    |--  knkr   MYSQL DB is...   on June 25, 2015, 5:19 pm
    |--  faraweilyas   Hello, I'm using...   on August 19, 2021, 10:10 am
    |--  warvid   I am encountering...   on October 16, 2021, 9:02 am

« Previous    Next »

Normal Mode | Print  



Users viewing this topic
2 guests, 0 users.


All times are GMT. The time now is May 15, 2025, 4:52 pm.

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