Seth Seeger wrote:
Hello,
I'm having trouble copying a database from MySQL 4.1.22 to 5.1.19-
beta. Both are FreeBSD i386-based machines. I have run the following
commands:
mysqlcheck --check-upgrade --all-databases --auto-repair
mysql_fix_privilege_tables
Both executed with no problems. (mysqlcheck reported "OK" for all
tables.) When I try to access any of the tables, I get this:
mysql> select * from users;
ERROR 1034 (HY000): Incorrect key file for table 'users'; try to repair it
So I tried to repair it:
mysql> repair table users;
+----------------------------+--------+----------
+--------------------------------------------------------+
| Table | Op | Msg_type |
Msg_text |
+----------------------------+--------+----------
+--------------------------------------------------------+
| seth_icsx_mands_live.users | repair | error | Incorrect key file
for table 'users'; try to repair it |
+----------------------------+--------+----------
+--------------------------------------------------------+
1 row in set, 1 warning (0.10 sec)
Running "repair table users" doesn't seem to have any effect on it
because the problem persists. I have tried to run mysql_upgrade, with
no success:
# mysql_upgrade --basedir=/usr/local --datadir=/var/db --verbose
Looking for 'mysql' in: mysql
FATAL ERROR: Can't find 'mysql'
I have tried it with all different combinations for the two directory
options with no luck. All tables are MyISAM.
Can anyone shed some light on what I'm supposed to do?
Thanks,
Seth
Shut the server down and run myisamchk on users.MYI
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]