Stellar Knowledge Base

How to repair all MySQL databases in your system?

 Modified on: June 19, 2020 |    13601 views

Before using Stellar Repair 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 Class
  • Operating System: Windows 10 , 8.1, 8, 7, & Vista and Windows Server 2012 / 2008 / 2003
  • Memory: Minimum 2GB (4 GB Recommended) 
  • Hard Disk : 250 MB of free space 
  • MySQL Version: 3.x/4.x/5.x/6.x/8.x

Follow the series of steps given below to repair all corrupt databases stored at the default location of MySQL:

  • Download & Install Stellar Repair for MySQL. The main interface is displayed along with a dialog box.
  • There are two options to select MySQL database: MySQL 6.x and below and, MySQL 8.x.
  • Click 'OK' to start the repairing process.
  • Check the preview of database objects: Tables, Views, Triggers and Keys.
  • To save the repaired database, click Save
  • Select appropriate option to save the repaired database.
  • To connect with the server, you to need to enter Username, HostName and password.
  • Click Save
  • After completion of the saving process, the software will promot a success message 'Saving process completed'


4 User Comments


what if the repair tool does not pre-visualize the data from a selected table in the breakdown structur on the left? If i select the next table, the tool will display the structure an the data. Both in the same DB.

Best regards,



Philipp Horka



Hi Philipp,

Application works on preview basis. It will save the tables data as per the preview. For any table if application is not showing data in preview then it means no data is there to save.

In case you still have any queries then connect with our expert by using the below link:

Stellar Data Recovery

What happens if one of the fields is blob and you don't preview it, you only get , if you export that field when saving?




Manish Pant


The software saves the data and recovers all objects exactly in the same way as it shows in the preview.
Regarding the blob data type, please let us know how it was showing up in your original database.

Further, we have also replied to you on the ongoing case.

Feel free to contact us for any further assistance.

Stellar Data Recovery


User Comments




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 Choose Stellar?

  • 0M+


  • 0+

    Years of Excellence

  • 0+

    R&D Engineers

  • 0+


  • 0+


  • 0+

    Awards Received