Stellar Knowledge Base

How to repair all MySQL databases in your system?

 Modified on: June 19, 2020 |    13678 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

Hi,

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

gravatar

Philipp Horka

gravatar

Rajeev

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:

https://www.stellarinfo.com/support/

Regards,
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?

gravatar

Jorge

gravatar

Manish Pant

Hi,

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.

Regards,
Stellar Data Recovery

 

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