Is it possible to recover MySQL database created on LINUX using Recovery software?

 

Yes, it is very much possible to recover any corrupt MYSQL database with the help of Stellar MySQL Database Recovery software

Stellar Phoenix MySQL Database Recovery is a powerful utility to repair severely corrupt MySQL database engine files (InnoDB and MyISAM) and restore them back. The software allows you to copy your damaged MySQL database from the LINUX system to any Windows Operating system based computer and recover the database by manually selecting the database files.

 Below steps can guide you through the repair and recovery process

Steps to recover MySQL database created on LINUXFrom your LINUX system, copy the MYSQL database folders and the 'ibdata1' file from the location, '\var\lib\MySQL'. Paste the files onto your Windows drive

Note: Before performing the recovery operation, ensure that MySQL application must have been installed in the Windows system from which you are going to recover the database. Also, there must be equal amount of free space in the drive, in which you are going to recover the MySQL database.

-> Run Stellar Phoenix MySQL Database Recovery and choose the option, 'Manual selection of database(s) for recovery'. Click 'Browse' and select the folder containing the corrupt MySQL database. Click 'OK' to continue.

-> If the selected folder contains the 'ibdata' file for the corresponding MySQL database, then the software shows the list of all databases present in the folder, or else, another dialog box prompts to provide the 'ibdata' file path. Browse to select the 'ibdata' file and click 'OK'.

-> The software lists all the MySQL databases. Check-mark the databases, you want to recover and click 'OK'.

-> All the components of the selected database get listed in a tree structure. Click any component from the left pane of the interface to view the content. You can repair the entire database or any particular component. Check mark as per your requirement and click the 'Repair' button from the tool bar.

-> The 'MySQL Recovery' dialog box opens, prompting for the Login information of the MySQL database. Provide the needed information and click 'OK'.

-> On successful completion of the repair process, a process completion message is displayed. Click 'OK' to close the dialog box.

-> The recovered data is saved in a new folder, 'Recovered_Database Name' at the location of the selected database file.

-> Copy the file back to '\var\lib\MySQL' of your LINUX system and use.

 

 

Was this article helpful?

Yes No

Category: MYSQL Database Repair

Last updated on December 24, 2013 with 2234 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.