Received the error again this morning;
I was able to copy an older copy of <>.frm file into
tbl_status.frm (via Sinisa's response), and the problems
went away; all data appears to be intact.
[Largest *.MYD files is 186 mbytes & *.MYI is 32 mbytes.
Note that all database directories & files reside on an
NFS automounted file-system, and not a local disk.]
Then tried to reproduce the problem interactively.
mysql> ALTER TABLE tbl_status RENAME tbl_status_bac;
Query OK, 0 rows affected (0.02 sec)
mysql> ALTER TABLE tbl_status_bac RENAME tbl_status;
ERROR 1033: Incorrect information in file: './ts1/tbl_status_bac.frm'
Hmmm, so I restored the above <>.frm file again.
Then shutdown the server:
$ ./bin/mysqladmin -u ...... -p........ shutdown
Tried to restart, and now cannot restart the server:
$ ./bin/safe_mysqld &
Starting mysqld daemon with databases from ...
010330 10:18:14 mysqld ended
$ less var/p
010330 10:18:14 mysqld started
010330 10:18:14 /fs5/b/spicano/dev/local/mysql/libexec/mysqld:
Incorrect information in file: './mysql/host.frm'
010330 10:18:14 /fs5/b/spicano/dev/local/mysql/libexec/mysqld: Normal
shutdown
010330 10:18:14 /fs5/b/spicano/dev/local/mysql/libexec/mysqld:
Shutdown Complete
010330 10:18:14 mysqld ended
Might the NFS dependence be a problem?
Silvio
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
