Re: do frm files have the schema for the table?
Hello. Yes, it works only for MyISAM. You've began a new thread, and haven't specified that this one is related to the previous. So I've decided they were independent. Possibly you could obtain schema information using different levels of innodb_force_recovery. See: http://dev.mysql.com/doc/mysql/en/forcing-recovery.html Jason Pyeron <[EMAIL PROTECTED]> wrote: > 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. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: do frm files have the schema for the table?
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]
Re: do frm files have the schema for the table?
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 Jason Pyeron <[EMAIL PROTECTED]> wrote: > > I am willing to give up on my data recovery efforts if I can just get the > schema from the dead tables, any suggestions? > > Sincerely, > > Jason Pyeron > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
do frm files have the schema for the table?
I am willing to give up on my data recovery efforts if I can just get the schema from the dead tables, any suggestions? Sincerely, Jason Pyeron -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - 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]
