- Rating
- (0)
- (1)
- (0)
- (0)
- (0)
MySQL repair database tool
The order of actions for repairing tables, views, keys, indexes, and other objects from damaged MySQL databases of InnoDB or MyISAM versions:
- Download, install and open Repair Toolbox for MySQL: https://www.repairtoolbox.com/download/MySqlRepairToolboxInstall.exe
- Select the folder with the MySQL database files.
- From the list, select a damaged database.
- Enter a new database name.
- Select a save method.
- Click on the Recover button.
How to repair a damaged MySQL database
MySQL repair program for fixing MyISAM and InnoDB databases in Windows.
The main features of the MySQL database repair tool include:
- repair corrupted databases from MyISAM, InnoDB database engines
- support Unicode data repair
- repair tables and data from recovered tables
- repair view
- recovering primary indexes and foreign keys
- restoring simple index keys
- preview of recovered data
- preview of recovered structures (as SQL scripts for the creation of objects)
- selective data saving for objects, structures and data
- direct export recovered data into MySQL database
- save recovered data as scripts on HDD
Requirements
- Windows 98/Me/2000/XP/Vista/7/8/10/11 or
- Windows Server 2003/2008/2012/2016 and above
Note:
- Get acquainted with the professional software team development of Repair Toolbox for MySQL and feel the difference from other freeware or open source solutions, distributed under a GNU General Public License (GPL). The Repairtoolbox.com project requires donations from the users of Repair Toolbox for MySQL in order to remove all of the restrictions of the free version. However, it is not required for the evaluation of its data restoration engine, so you can continue testing its features.
- MySQL is the registered trademark of Oracle.
How it Works?
-
Download software from website.Download
-
Start Install software:
- Press on downloaded installation file in browser
- Select a downloaded installation file in Windows Explorer and press Enter or double click on it.
-
Please confirm warning message.
-
Run installation wizard.
-
Run program:
- Double click on icon on desktop
- or
- Select from main menu: Start | Programs | Repair Toolbox for MySQL | Repair Toolbox for MySQL.
-
Please select root folder with a damaged MySQL database files on first page of repair wizard in Repair Toolbox for MySQL.
-
Please select database for recovery from a dropdown list.
-
Press on Next button.
-
Program will read and analyze a damaged file a several minutes. Later you can see:
- Tables (records and structure as SQL script)
- Views (as SQL script)
-
Please check tables and view for saving on next steps.
-
Press on Next button.
-
Please type name of new database for export of recovered data.
-
Please select a type of saving:
- as SQL scripts
- direct export into database
-
Please select path to save a recovered data for variant 13.1. Or please type server, user name and password for variant 13.2.
-
Press on Recover button.
-
On last page shows a detailed log of recovery process.
Errors
MySQL Repair Tool helps to fix errors:
- Error: Table 't' is marked as crashed and should be repaired.
- Open the table failed: Can't open the file: '× × ×. MYI' (err no: 145).
- ERROR 1016: Can't open the file: 'childX.InnoDB'.
- InnoDB: Cannot find the table “table1/table2” from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables?"
- 127 = Record-file has crashed
- 134 = Record was already deleted (or record file crashed)
- 144 = Table has crashed and the last repair failed
- 145 = Table was marked as crashed and should be repaired
Screenshots
Video Manual
Real customer reviews from TrustPilot
Customer's reviews and ratings
Looks good.
But part of data was lost.
Backup help to save other 5% of data.