Stellar Repair for MySQL is advanced software that helps administrators repair a corrupt MySQL database created on Windows and Linux systems. The software can repair all database objects, including relations and tables, primary keys, unique keys, triggers, etc. It can also repair all the data types, excluding spatial data types.
After completing the database repair process, the software previews the repaired MySQL objects like tables, table properties, views, and triggers. It then allows saving the repaired database in various file formats, such as MySQL, MariaDB, CSV, HTML, and XLS.
The latest version 9.0 of the tool saves the repaired MySQL database file as a SQL Script. The script can be directly accessed via SQL Server Management Studio (SSMS). In addition, MariaDB 10.8 version support is available in the software. The software also provides an option to save the log report of the complete MySQL database repair process. The log report can be used to analyze the repairing procedure later. This report comprises details like the repair process's start time and end time, the name of the repaired database, etc.
Key features:
1)Fixes All Types of MySQL & MariaDB Database Corruption
The software can fix all corruption errors that render a MySQL or MariaDB database inaccessible. It helps resolve errors like 'Index file is crashed', 'Corruption in InnoDB tablespace', 'Error establishing a database connection', etc.
2. Repair MySQL InnoDB and MyISAM Tables
The software repairs tables of MySQL database engines including InnoDB (.frm, .ibdata, .idb) and MyISAM (.frm, .myd, .myi). It restores both InnoDB and MyISAM tables to their original, intact form, including table properties, keys, and relationship constraints of both MyISAM and InnoDB tables.
3. Repairs Multiple MySQL Databases Simultaneously
The software allows for repairing multiple MySQL databases simultaneously. This is a useful feature, as it helps administrators save time and reduce the hassle of selecting (and reselecting) different MySQL databases you want to repair.
4. Repair MySQL Database on Linux
The software supports repairing a MySQL database for different Linux distributions like CentOS, Red Hat Enterprise Linux, and Ubuntu-based systems. However, the software requires copying the corrupted MySQL database from the Linux system to a Windows system for the repair process.
5. Preview the Repaired Database
The software shows a preview of the repaired MySQL objects in a tree-like structure. The left pane of the preview window displays tables, views, triggers, etc. The right pane shows the contents of a selected object. In addition, a log report of the repair process is displayed in the bottom pane of the preview window.
6. Multiple File Saving Formats
After previewing and selecting the MySQL database objects you want to restore, the software allows saving the repaired database as a new MySQL or MariaDB database. You need to enter the MySQL server details to connect to the server and save the database. The MySQL repair tool also allows saving the repaired database in other file formats, such as SQL Script, CSV, HTML, or XLS.
7. Save Repaired Data as SQL Script
Stellar Repair for MySQL software provides an option to save the repaired MySQL data as a SQL Script. Further, it allows saving the SQL Script at the default or a new location. After saving the repaired data, the software opens the data in a new query window in SQL Server Management Studio (SSMS).
7. Generates & Saves Log Report
The software generates a detailed log report of the MySQL database repair process. The report comprises details of the repair process, including the start time and end time of the repair process, the name of the repaired database, and its tables, views, etc. You can view the log report for later analysis
System Requirements:
Processor: Intel compatible (x86, x64)
Operating System: Windows Server 2012 / 2008 / 2003 and Windows 11/10 / 8.1 / 8 / 7
Memory: 2 GB minimum (4 GB recommended)
Hard Disk: 500 MB of free space
Comments