DEAR john
You can try rename tables_priv.frm.then restart mysql instance.
If the mysql instance can restart sucessfully,you can export the production
database
by using mysqldump.
2014-08-15
I AM AN ORACLE FANS!
Skype:Frank.oracle
Email:[email protected]
发件人：John McIntyre <[email protected]>
发送时间：2014-08-15 20:31
主题：Incorrect Infomation in tables_priv.frm
收件人："mysql"<[email protected]>
抄送：
Hi,
I have MySQL 5.1.73 running on a CentOS 6.5 Linux system. Recently, I was
adding a couple of users, and when I tried to FLUSH PRIVILEGES, I got this …
([email protected] [(none)] 13:24:19 (1) $ FLUSH PRIVILEGES ;
ERROR 1033 (HY000): Incorrect information in file: './mysql/tables_priv.frm’
So I went to google, and realised that I’d probably upgraded without running
mysql_upgrade. So I try..
[~] john@server% (872) mysql_upgrade -u root -p mysql
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
0wn3lou4.oc_appconfig OK
0wn3lou4.oc_clndr_calendars OK
That for a lot of lines, and then …
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.innodb_index_stats
Error : Incorrect information in file: './mysql/innodb_index_stats.frm'
error : Corrupt
mysql.innodb_table_stats
Error : Incorrect information in file: './mysql/innodb_table_stats.frm'
error : Corrupt
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc
Error : Incorrect information in file: './mysql/proc.frm'
error : Corrupt
mysql.procs_priv
Error : Incorrect information in file: './mysql/procs_priv.frm'
error : Corrupt
mysql.proxies_priv
Error : Incorrect information in file: './mysql/proxies_priv.frm'
error : Corrupt
.. for loads of lines, and then …
ERROR 1033 (HY000) at line 659: Incorrect information in file:
'./mysql/event.frm'
ERROR 1033 (HY000) at line 661: Incorrect information in file:
'./mysql/event.frm'
ERROR 1033 (HY000) at line 663: Incorrect information in file:
'./mysql/event.frm'
ERROR 1033 (HY000) at line 666: Incorrect information in file:
'./mysql/event.frm'
ERROR 1033 (HY000) at line 669: Incorrect information in file:
'./mysql/event.frm'
ERROR 1033 (HY000) at line 672: Incorrect information in file:
'./mysql/event.frm'
ERROR 1033 (HY000) at line 675: Incorrect information in file:
'./mysql/event.frm'
ERROR 1033 (HY000) at line 678: Incorrect information in file:
'./mysql/event.frm'
ERROR 1033 (HY000) at line 681: Incorrect information in file:
'./mysql/event.frm'
ERROR 1033 (HY000) at line 684: Incorrect information in file:
'./mysql/event.frm'
ERROR 1033 (HY000) at line 686: Incorrect information in file:
'./mysql/event.frm'
ERROR 1033 (HY000) at line 714: Incorrect information in file:
'./mysql/tables_priv.frm'
FATAL ERROR: Upgrade failed
There are four databases on that server, two of them critical, production
databases. I can get around the privileges problem by stopping and starting
the database out of office hours, but even then, when I do …
140815 13:28:29 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
140815 13:28:29 InnoDB: Initializing buffer pool, size = 8.0M
140815 13:28:29 InnoDB: Completed initialization of buffer pool
140815 13:28:29 InnoDB: Started; log sequence number 4 2002382636
140815 13:28:29 [ERROR] /usr/libexec/mysqld: Incorrect information in file:
'./mysql/tables_priv.frm'
140815 13:28:29 [ERROR] /usr/libexec/mysqld: Incorrect information in file:
'./mysql/event.frm'
140815 13:28:29 [ERROR] Cannot open mysql.event
140815 13:28:29 [ERROR] Event Scheduler: An error occurred when initializing
system tables. Disabling the Event Scheduler.
140815 13:28:29 [Note] /usr/libexec/mysqld: ready for connections.
The user changes are taken into account, however.
Needless to say, mysql_dump doesn’t work either.
Any advice gratefully received.
John.
