How to repair all MySQL databases in your system?
- Author : Creative Team on September 12, 2011
Before using Stellar Phoenix Database Recovery 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:
Start Stellar Phoenix Database Recovery 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.
Was this article helpful?