List:General Discussion« Previous MessageNext Message »
From:xiangdongzou Date:August 15 2014 3:00pm
Subject: 回复: Incorrect Infomation in tables priv.frm
View as plain text  
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:xiangdongzou@stripped



发件人:John McIntyre <joh98.mac@stripped>
发送时间:2014-08-15 20:31
主题:Incorrect Infomation in tables_priv.frm
收件人:"mysql"<mysql@stripped>
抄送:

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 …   

(root@stripped [(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. 
Thread
Incorrect Infomation in tables_priv.frmJohn McIntyre15 Aug 2014
  • 回复: Incorrect Infomation in tables priv.frmxiangdongzou15 Aug 2014