MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
Posted by: EE Durham
Date: February 22, 2013 01:21PM

First off, please re-read the error message that you posted - looks like you have some invalid entries in your my.cnf that you need to remove :)
EXAMPLE:
"2013-02-06 11:38:09 2507 [Warning] /usr/sbin/mysqld: ignoring option '--innodb-doublewrite' due to invalid value 'OFF'"
More info is available here:
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html

Next, after fixing your my.cnf, you can try stopping the mysql service, and then physically moving your ib_logfile# files to a backup location, and then restarting the mysql service. Doing so will cause the mysql service to rebuild the ib_logfile files and will often resolve the issue that you're encountering. Please do post whether this resolves your issue :)

Good luck!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
45785
Jyothi hc
February 06, 2013 01:47AM
Re: InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
22890
EE Durham
February 22, 2013 01:21PM
Re: InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
35856
Matt Miller
February 24, 2013 09:15AM
Re: InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
10971
George Brooks
April 01, 2013 09:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.