Re: How to determine if table is locked or corrupted
Is you system Linux?
If you do something like:
# strings green/member.frm | grep InnoDB
# strings green/member.frm | grep MyISAM
I hope you get a hit on just the first? I also hope you have *just* the .frm, no .MYI or .MYD filed?
Can you also try a SHOW ENGINES? We want the line:
| InnoDB | DEFAULT |
Or at least:
| InnoDB | YES |
Also, if you do a SHOW CREATE TABLE green.users, what do you get? Does it include the correct engine type?
Ben
Subject
Views
Written By
Posted
4822
June 29, 2008 02:12PM
2128
June 30, 2008 07:07AM
2007
June 30, 2008 08:27AM
1952
June 30, 2008 09:56AM
1886
June 30, 2008 10:11AM
Re: How to determine if table is locked or corrupted
2195
June 30, 2008 10:27AM
1808
June 30, 2008 10:44AM
1851
July 01, 2008 01:52AM
1912
July 01, 2008 09:27AM
1831
July 02, 2008 02:19AM
2159
June 30, 2008 09:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.