Stellar Knowledge Base

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

 Modified on: April 21, 2022 |    32476 views

Yes, it is very much possible to recover any corrupt MySQL database with the help of Stellar 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 select MySQL database
  • 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.
  • Save the repaired database.
  • 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

verfy04

 

 

Stellar Repair for MySQL Stellar Repair for MySQL is a competent tool that fixes MySQL database corruption and performs safe restoration of all inaccessible objects, including primary keys, views, triggers, etc.

Learn More red arrow

 

Related Articles

 

WHY STELLAR® IS GLOBAL LEADER

Why Choose Stellar?

  • 0M+

    Customers

  • 0+

    Years of Excellence

  • 0+

    R&D Engineers

  • 0+

    Countries

  • 0+

    PARTNERS

  • 0+

    Awards Received