Stellar Knowledge Base

How to repair all MySQL databases in your system?

Author : Creative Team Updated on May 5, 2016

Before using Stellar Phoenix Database Repair for MySQL, you need to consider the following things:

 The location of 'ibdata' file should be exactly the same as that of MySQL database. 
 There should be enough free space on the destination drive to store all the recovered MySQL databases. 
 For selecting MySQL databases from the default location, you should have MySQL installed in the system.

Additionally, your system should meet the following requirements:

 Processor: Pentium 4 PC 
 Operating System: Windows 2000/XP/2003/Vista/Windows 7 
 Memory: Minimum 1GB (2 GB Recommended) 
 Hard Disk : 50 MB of free space 
 MySQL Version: 3.x/4.x/5.x/6.x

Follow the series of steps given below to repair all corrupt databases stored at the default location of MySQL:

 Download & Install Stellar Phoenix Database Repair for MySQL. The main interface is displayed along with a dialog box. 
 In the dialog box, select  Repair corrupt database(s) stored at default location of MySQL. Click 'OK'.
 A list of all databases stored at the default location of MySQL will be displayed. Select the databases you need to repair and click 'OK'. 
 A tree structure of all selected databases appears in the left pane. You select any database object to see its preview in the right pane. 
 Select the databases or individual components that you need to repair and click 'Start Repair' icon on the tool bar. 
 A dialog box appears asking you the required user login information. Provide your user name, host name, and password. Click 'OK'. 
 You can view the log of the recovery process in the 'Messagelog' pane. 
 When the process is completed, a dialog box appears displaying the message Repair process finished successfully.


User Comments