Resolve Error "Unsupported Extension Used For Table" in MySQL


Upgradation of MySQL database sometimes leads with the corruption in the database. Most of the time upgrading of MySQL database through utility called mysql upgrade. Upgradation sometimes results with partial or incomplete up gradation and loss of data from the stored database.

After the incomplete up gradation some of the table get corrupted and whenever you try to access those table you encounter with the error message ( Error Message "Unsupported Extension Used For Table" in MySQL Database) which is displayed below

"e-systemusr/local/mysql/bin# ./myisamchk -a
/usr/local/mysql/var/centralf/postscobe1.MYI

myisamchk: error: 138 when opening MyISAM-table
'/usr/local/mysql/var/centralf/postscobe1.MYI'

e-systemusr/local/mysql/bin#......."

If you are getting this error message and not able to understand, then remember that this is the indication of the corruption in the table. After this, table become inaccessible and you are not able to access data stored in your table. Due to this you can loss your data.

To resolve this Error Message "Unsupported Extension Used for Table" in MySQL Database , here are some solutions.

First of all check your table about the corruption with the below command--

Check Table tablename

After checking if you find that corruption then try to repair MySQL table with the below command

Repair Table tablename

Or by running the following command:

REPAIR TABLE TABLENAME USE_FRM

Though, it won't be useful here, as it will show the tables as empty.

If all the above measures fall short of repairing the corrupted tables, then you can use the professional MySQL repair table to repair corrupted table. This tool is designed with the advanced program which completely repairs and restores the data stored in the MySQL tables. It has user friendly interface with the self-descriptive which need not any technical knowledge to use it. The software supports both (MyISAM and InnoDB) MySQL database storage engines. It repairs MySQL components like tables, primary key(s) and relations. The software is compatible with MySQL 5.x. This is compatible with Windows (Windows Vista, XP, 2003 and 2000).