MySQL is the world's most popular open source relational database management system (RDBMS). It uses a special purpose query language called the Structured Query Language (SQL) to manage data. The two most common search engine used by MySQL database is MyISAM and InnoDB. However, the default storage engine used by MySQL database is the MyISAM. The choice of the search engine totally depends upon the size of the database.
While working with such a database, the tables are not accessible at times. There are various reasons for an inaccessible database. Some of them are as mentioned below.
There are three different files that are created when a table is created under MySQL.
- FRM files are created to store table format
- MYD (MyData) files are created to store the data
- MYI (MyIndex) files are created to store the index
Corruption in any of these files could lead to inaccessibility of the database.
- Multiple instances of MySQL running
- Change in the settings of InnoDB log
- Invisible MySQL host tables
- Malfunctioning of the auto_increment count in MyISAM
- Multiple connections that can be handled by the database
- Concurrent writes to InnoDB table make them corrupt
Most of the above mentioned reasons can be fixed by simply restarting the database. However, you can also try various My SQL commands to repair the database. For example, if the corruption is associated with My ISAM table, you can connect to the database and use the following command.
There are various other commands depending upon the issue. Alternatively, you can make use of any professional repair tool, in case the command does not work.
Stellar Phoenix Database Repair for MySQL
is a trusted and reliable solution to repair corrupt or inaccessible MySQL databases. It repairs InnoDB and MyISAM tables of MySQL database and recovers inaccessible objects like keys, triggers, table, views, etc. The process to repair the database is very simple, and can be done by following the below mentioned steps.
- Launch 'Stellar Phoenix Database Repair for MySQL' application.
- The interface appears up, giving you instructions of how to select corrupt database location, repair the file, and to stop the repair process.
- From the top left side of the screen, click on 'Select' button.
- The next screen gives you an option to either select 'Repair corrupt database(s) stored at default location of MySQL' or Manual selection of database(s) to repair.
- Choose the 'Repair corrupt database(s) stored at default location of MySQL' option and click OK. This starts the scanning process of the database.
- Once the scanning process is complete, the database components are displayed in a tree like structure in the left pane of the screen.
- You can select an item to preview it on the main interface.
- Select one or more database items and click 'Repair' button in the File menu from the top left side of the interface.
- The Stellar Repair Phoenix Database Repair for MySQL dialog box appears saying that Repair process finished successfully.
- Click Yes.
- Click OK, after the successful completion of the process. This would close the message box.
The above-mentioned steps are applicable in case of selecting corrupt MySQL database from a default location. However, in order to manually select the database, choose the 'Manual selection of database(s) to repair' option. Then follow the below mentioned steps.
- Click Browse
- Browse for Folder dialog box opens
- Look for the folder that contains databases
- Select and Click OK
- Follow the remaining steps as followed in automatic selection of the database