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
4619
June 29, 2008 02:12PM
2047
June 30, 2008 07:07AM
1924
June 30, 2008 08:27AM
1855
June 30, 2008 09:56AM
1805
June 30, 2008 10:11AM
Re: How to determine if table is locked or corrupted
2090
June 30, 2008 10:27AM
1728
June 30, 2008 10:44AM
1763
July 01, 2008 01:52AM
1830
July 01, 2008 09:27AM
1754
July 02, 2008 02:19AM
2069
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.