Stellar Knowledge Base

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

May 5, 2016     19390 views     0     0

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

It 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 based computer and recover the database by manually selecting the database files.

 Below steps can guide you through the repair and recovery process

From 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 the software and choose '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.


User Comments



Related Articles