How to repair all MySQL databases in your system?

 


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?

Yes No

Category: MYSQL Database Repair

Last updated on December 24, 2013 with 1961 views

0 User Comments

There are no comments yet...Kick things off by filling out the form below.

Leave a Comment













 

Stellar Phoenix & Stellar Data Recovery are Registered Trademarks of Stellar Information Technology Pvt. Ltd.
© Copyright 2014 Stellar Information Technology Pvt. Ltd. All Trademarks Acknowledged.