Re: How to determine if table is locked or corrupted
I am not running linux so cannot grep the file, but I did check it out with notepad (the users table is small) and while most of the characters were gibberish, I was able to find InnoDB and didn't find MyISAM.
show engines returned InnoDB with support DEFAULT and MyISAM with support YES
show create table green.user returned "Table green.users doesn't exist"
Subject
Views
Written By
Posted
4628
June 29, 2008 02:12PM
2052
June 30, 2008 07:07AM
1927
June 30, 2008 08:27AM
1859
June 30, 2008 09:56AM
1808
June 30, 2008 10:11AM
2094
June 30, 2008 10:27AM
Re: How to determine if table is locked or corrupted
1731
June 30, 2008 10:44AM
1767
July 01, 2008 01:52AM
1834
July 01, 2008 09:27AM
1758
July 02, 2008 02:19AM
2073
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.