Welcome Guest. Please Login or Register  
Client Area  |  Softaculous Cloud  |  Calendar  |  Quick Links  |  
   


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
sdowns
May 14, 2014, 7:45 am | Post: 20
Group: Member
Post Group: Newbie
Posts: 6
Status:
Right, I've restored my AMPPS installation back to 2.3, prior to the 2.4 upgrade. I can now run my local website again.

However when I look at the mysql error log I'm still seeing these errors.

2014-05-14 08:23:30 3098 [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-14 08:23:30 3098 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2014-05-14 08:23:30 3098 [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.
2014-05-14 08:23:30 3098 [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.
2014-05-14 08:23:30 3098 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.

In fact these errors have been occurring since I first installed AMPPS 2.2 back in January.

Checking the database named 'mysql', the following tables appear in the list of tables but if I try to view them, my SQL client (Sequel Pro) says they do not exist.

innodb_index_stats, innodb_table_stats, slave_master_info, slave_relay_log_info and slave_worker_info.

How do I recreate these tables and does it matter?
IP: --   


Threads
 thokkalodi   MySQL not starting up, MySQL not starting on Mac OSX Mountain Lion (30 Replies, Read 380947 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
3 guests, 0 users.


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

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