On Tue, 5 Jul 2005, Gleb Paharenko wrote:
Hello.
As of MySQL 4.0.2 after REPAIR ... USE_FRM you should be able to get information
about table with SHOW CREATE TABLE, however some information could be lost.
See:
http://dev.mysql.com/doc/mysql/en/repair-table.html
but doesn't that only work with MyISAM tables?
from the web page:
REPAIR TABLE repairs a possibly corrupted table. By default, it has the
same effect as myisamchk --recover tbl_name. REPAIR TABLE works only on
MyISAM tables.
mysql> repair table files USE_FRM;
+-----------------+--------+----------+-----------------------------------------+
| Table | Op | Msg_type | Msg_text
|
+-----------------+--------+----------+-----------------------------------------+
| crisfield.files | repair | error | Can't open file: 'files.ibd' (errno: 1)
|
+-----------------+--------+----------+-----------------------------------------+
files.ibd does not exist on the system.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218 -
- -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you
have received it in error, purge the message from your system and
notify the sender immediately. Any other use of the email by you
is prohibited.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
