MySQL Forums
Forum List  »  InnoDB

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!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
21965
February 22, 2013 01:21PM


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.