How to fix error message “Unsupported Extension Used For Table” in MySQL Database
Published by Jacob Martin on June 17, 2015
Many MySQL database users are upgrading MySQL tables to the latest version to take benefits of the new privileges added to the new version. The mysql_upgrade is the utility that is available for the upgradation of MySQL tables. Though the upgradation has lots of advantages but it can also led to partial or complete loss of data from the tables.
When you face such situation then backup allow to you retrieve the lost data. But what if you do not have any backup or if it fails to recover the data, then at such cases you will need to repair the corrupted or damaged table(s). To repair corrupt table(s) you will need a professional MySQL database repair tool.
For example – take a practical situation, where you upgraded your MySQL database application from version 4.0.13 to version 4.0.14. Once the upgradation completes, you found that some of your critical tables are damaged. Furthermore, when you try to open those tables, you get the below error messages:
“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#…….”
After you encounter the above error messages the data stored in MySQL tables becomes inaccessible.
Reason behind the corruption of MySQL tables
The main reason behind the corruption of MySQL tables is due to interrupted or inappropriate upgradation of MySQL database.
Solutions
To repair and restore damaged MySQL tables, you can follow the below mentioned steps:
Step 1 – Use command Check Table tablename to check and analyze the damage in MySQL table.
Step 2 – Then run command Repair Table tablename to repair MySQL table.
Step 3 – You can also run the command REPAIR TABLE TABLENAME USE_FRM to repair the MySQL Table corruption. Though, this will not be helpful as it will only display the blank table.
Recommended Solution
Nevertheless, if any of the above mentioned methods fails to restore your corrupted tables, then you can use the professional MySQL Database repair tool. This tool has the advance algorithm that scans your entire MySQL database and repair and retrieve the data saved in MySQL tables. It comes with graphical user interface along with self description user guide and hence you can easily operate it without having any technical knowledge.
This tool support both (MyISAM and InnoDB) MySQL database storage engines. It repair and restore al components of MySQL such as tables, primary key(s) and relations. It is compatible with latest MySQL 5.x. The tool is designed for almost all versions of Windows including Windows Vista, XP, 2003 and 2000.
Steps to fix error message “Unsupported Extension Used For Table” in MySQL Database
Step 1: Download, install and launch the MySQl Database repair tool.
Step 2: Click ‘Select’ button to find and add corrupt MySQL database to the application and then select OK. Here you have the option of ‘Repair corrupt database which is stored at default location of MySQL’ and ‘Manual option to selct your database from default location’.
Step 3: After the scanning process you can now see the preview of the file in the left panel of the software.
Step 4: Now you can start the reairing process, just click on Repair button. A dialoguie box will appear. Click Yes.
Step 5: After successful completion of the process, a message box is displayed as ‘repair process finished successfully’. Click ‘OK’ to close the message box.
412 Total Views 2 Views Today