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
4823
June 29, 2008 02:12PM
2131
June 30, 2008 07:07AM
2008
June 30, 2008 08:27AM
1954
June 30, 2008 09:56AM
1889
June 30, 2008 10:11AM
Re: How to determine if table is locked or corrupted
2198
June 30, 2008 10:27AM
1812
June 30, 2008 10:44AM
1852
July 01, 2008 01:52AM
1915
July 01, 2008 09:27AM
1833
July 02, 2008 02:19AM
2160
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.