[debian-mysql] Bug#411672: mysql-server-5.0: Incorrect file format 'host'

Danai SAE-HAN (韓達耐) danai.sae-han at edpnet.be
Fri Jul 6 08:22:41 UTC 2007 

On 06-07-07 08:36, sean finney wrote:
>
>> Isn't there some tool with which I could fix this "host" privilege table?
> 
> have you tried manually running mysql_fix_privilege_tables ?

Indeed I have, but it can't connect to /var/run/mysqld/mysqld.sock because I
can't start mysqld. :/

I think most tools to fix tables require mysqld to run, so I'm in a pretty
difficult situation.

Here's the content of /var/lib/mysql/mysql:

totaal 716
drwxr-xr-x 2 mysql mysql   4096 2007-07-06 00:27 .
drwxr-xr-x 4 mysql mysql    155 2007-07-06 00:49 ..
-rw-rw---- 1 mysql mysql   8820 2007-06-09 19:25 columns_priv.frm
-rw-rw---- 1 mysql mysql      0 2007-06-09 19:25 columns_priv.MYD
-rw-rw---- 1 mysql mysql   1024 2007-06-09 19:25 columns_priv.MYI
-rw-rw---- 1 mysql mysql   9494 2007-06-09 19:25 db.frm
-rw-rw---- 1 mysql mysql   1314 2007-06-09 19:25 db.MYD
-rw-rw---- 1 mysql mysql   4096 2007-06-09 19:25 db.MYI
-rw-rw---- 1 mysql mysql   8665 2007-06-09 19:25 func.frm
-rw-rw---- 1 mysql mysql      0 2007-06-09 19:25 func.MYD
-rw-rw---- 1 mysql mysql   1024 2007-06-09 19:25 func.MYI
-rw-rw---- 1 mysql mysql   8700 2006-07-09 23:52 help_category.frm
-rw-rw---- 1 mysql mysql  20916 2007-07-06 00:27 help_category.MYD
-rw-rw---- 1 mysql mysql   3072 2007-07-06 00:27 help_category.MYI
-rw-rw---- 1 mysql mysql   8612 2006-07-09 23:52 help_keyword.frm
-rw-rw---- 1 mysql mysql  75845 2007-07-06 00:27 help_keyword.MYD
-rw-rw---- 1 mysql mysql  13312 2007-07-06 00:27 help_keyword.MYI
-rw-rw---- 1 mysql mysql   8630 2006-07-09 23:52 help_relation.frm
-rw-rw---- 1 mysql mysql   6723 2007-07-06 00:27 help_relation.MYD
-rw-rw---- 1 mysql mysql  13312 2007-07-06 00:27 help_relation.MYI
-rw-rw---- 1 mysql mysql   8770 2006-07-09 23:52 help_topic.frm
-rw-rw---- 1 mysql mysql 332964 2007-07-06 00:27 help_topic.MYD
-rw-rw---- 1 mysql mysql  15360 2007-07-06 00:27 help_topic.MYI
-rw-rw---- 1 mysql mysql   9416 2007-06-09 19:25 host.frm
-rw-rw---- 1 mysql mysql      0 2007-06-09 19:25 host.MYD
-rw-rw---- 1 mysql mysql   1024 2007-06-09 19:25 host.MYI
-rw-rw---- 1 mysql mysql   9691 2007-06-09 19:25 proc.frm
-rw-rw---- 1 mysql mysql      0 2007-06-09 19:25 proc.MYD
-rw-rw---- 1 mysql mysql   1024 2007-06-09 19:25 proc.MYI
-rw-rw---- 1 mysql mysql   8875 2007-06-09 19:25 procs_priv.frm
-rw-rw---- 1 mysql mysql      0 2007-06-09 19:25 procs_priv.MYD
-rw-rw---- 1 mysql mysql   1024 2007-06-09 19:25 procs_priv.MYI
-rw-rw---- 1 mysql mysql   8947 2007-06-09 19:25 tables_priv.frm
-rw-rw---- 1 mysql mysql      0 2007-06-09 19:25 tables_priv.MYD
-rw-rw---- 1 mysql mysql   1024 2007-06-09 19:25 tables_priv.MYI
-rw-rw---- 1 mysql mysql   8636 2007-04-06 00:13 time_zone.frm
-rw-rw---- 1 mysql mysql   8624 2006-07-09 23:52 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql      0 2007-07-06 00:27 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql   1024 2007-07-06 00:27 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql      0 2007-07-06 00:27 time_zone.MYD
-rw-rw---- 1 mysql mysql   1024 2007-07-06 00:27 time_zone.MYI
-rw-rw---- 1 mysql mysql   8606 2006-07-09 23:52 time_zone_name.frm
-rw-rw---- 1 mysql mysql      0 2007-07-06 00:27 time_zone_name.MYD
-rw-rw---- 1 mysql mysql   1024 2007-07-06 00:27 time_zone_name.MYI
-rw-rw---- 1 mysql mysql   8686 2006-07-09 23:52 time_zone_transition.frm
-rw-rw---- 1 mysql mysql      0 2007-07-06 00:27 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql   1024 2007-07-06 00:27 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql   8748 2006-07-09 23:52 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql      0 2007-07-06 00:27 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql   1024 2007-07-06 00:27 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql  10330 2007-06-09 19:25 user.frm
-rw-rw---- 1 mysql mysql    600 2007-06-09 19:25 user.MYD
-rw-rw---- 1 mysql mysql   2048 2007-06-09 19:25 user.MYI

# grep -i host *
Binair bestand columns_priv.frm komt overeen
Binair bestand db.frm komt overeen
Binair bestand help_keyword.MYD komt overeen
Binair bestand help_keyword.MYI komt overeen
Binair bestand help_topic.MYD komt overeen
Binair bestand help_topic.MYI komt overeen
Binair bestand host.frm komt overeen
Binair bestand procs_priv.frm komt overeen
Binair bestand tables_priv.frm komt overeen
Binair bestand user.frm komt overeen


This is the output of my syslog:

Jul  6 10:18:01 danai mysqld_safe[13766]: started
Jul  6 10:18:02 danai mysqld[13769]: InnoDB: Warning: we did not need to do
crash recovery, but log scan
Jul  6 10:18:02 danai mysqld[13769]: InnoDB: progressed past the checkpoint
lsn 0 43630235 up to lsn 0 43630245
Jul  6 10:18:02 danai mysqld[13769]: 070706 10:18:02  InnoDB: Started; log
sequence number 0 43630235
Jul  6 10:18:02 danai mysqld[13769]: 070706 10:18:02 [Note] Recovering after a
crash using /var/log/mysql/mysql-bin
Jul  6 10:18:02 danai mysqld[13769]: 070706 10:18:02 [Note] Starting crash
recovery...
Jul  6 10:18:02 danai mysqld[13769]: 070706 10:18:02 [Note] Crash recovery
finished.
Jul  6 10:18:03 danai mysqld[13769]: 070706 10:18:03 [ERROR] Fatal error:
Can't open and lock privilege tables: Incorrect file format 'host'
Jul  6 10:18:03 danai mysqld_safe[13789]: ended
Jul  6 10:18:16 danai /etc/init.d/mysql[13918]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul  6 10:18:16 danai /etc/init.d/mysql[13918]: ^G/usr/bin/mysqladmin: connect
to server at 'localhost' failed
Jul  6 10:18:16 danai /etc/init.d/mysql[13918]: error: 'Can't connect to local
MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul  6 10:18:16 danai /etc/init.d/mysql[13918]: Check that mysqld is running
and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul  6 10:18:16 danai /etc/init.d/mysql[13918]:


Best regards


-- 
Danai SAE-HAN (韓達耐)
--
題目:《臨安春雨初霽》
作者:陸游（１１２５－１２１０）

世味年來薄似紗，誰令騎馬客京華。
小樓一夜聽春雨，深巷明朝賣杏花。
矮紙斜行閑作草，晴窗細乳戲分茶。
素衣莫起風塵嘆，猶及清明可到家。

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 252 bytes
Desc: OpenPGP digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20070706/8bdc1797/attachment-0001.pgp

More information about the pkg-mysql-maint mailing list