This is my table format... when I upgraded, I got errors telling my that I
had in invalid key file, and that I should try to repair it. isamchk
didn't report any errors, and when I converted the database formats to the
new MyISAM format everything worked.
mysql> explain daily;
+---------+------------------+------+-----+------------+-------+---------------------------------+
| Field | Type | Null | Key | Default | Extra |
Privileges |
+---------+------------------+------+-----+------------+-------+---------------------------------+
| account | char(6) | | PRI | | |
select,insert,update,references |
| date | date | | PRI | 0000-00-00 | |
select,insert,update,references |
| site | char(2) | | PRI | | |
select,insert,update,references |
| program | char(20) | | PRI | | |
select,insert,update,references |
| raw | int(10) unsigned | | | 0 | |
select,insert,update,references |
| uniques | int(10) unsigned | | | 0 | |
select,insert,update,references |
| sales | int(10) unsigned | | | 0 | |
select,insert,update,references |
+---------+------------------+------+-----+------------+-------+---------------------------------+
7 rows in set (0.00 sec)
mysql> show index from daily;
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
Cardinality | Sub_part | Packed | Comment |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+---------+
| daily | 1 | date_idx | 1 | date | A |
NULL | NULL | NULL | NULL |
| daily | 1 | site_idx | 1 | site | A |
NULL | NULL | NULL | NULL |
| daily | 1 | prog_idx | 1 | program | A |
NULL | NULL | NULL | NULL |
| daily | 0 | account | 1 | account | A |
NULL | NULL | NULL | NULL |
| daily | 0 | account | 2 | date | A |
NULL | NULL | NULL | NULL |
| daily | 0 | account | 3 | site | A |
NULL | NULL | NULL | NULL |
| daily | 0 | account | 4 | program | A |
73 | NULL | NULL | NULL |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+---------+
7 rows in set (0.00 sec)
---
tani hosokawa
river styx internet
