Step 1: Install and Run Tool
Start the SysinfoTools MySQL Database Recovery Tool on your computer as an administrator.
Step 2: Open MySQL Files
Click on the Open button to browse the MySQL database files from your system to add.
Step 3: Add MySQL File
Use the browse (...) button of the opening tab to add MySQL files for the recovery.
Step 4: Set File Paths
You can also set the path for the Temporary File and Log File if required and click OK.
Step 5: Add Ibdata1 File
If your folder does not contain the Ibdata1 File and you want to add that one. Please, click on the Yes button.
Step 6: Select Ibdata1 File
Browse the file on your system, select it, and click the Open button to add it to the software.
Step 7: Scanning Files
The software starts the scanning process and it gets completed within a few seconds. Click OK.
Step 8: Preview and Select Files
Select the folders in the preview panel to recover and save. You have an option to view the database objects like Tables, Keys, Table Properties, Data Types, Views, Triggers, etc.
Step 9: Save MySQL Data File
Now, click on the Save MySQL Data button to choose the saving mode for your database files.
Step 10: Options to Save
The software shows you two options: Save in Database or Save as Script. You can choose either one of them.
Step 11: Save into MySQL Database
Opt for the Save in Database option and enter the Server, Port, User, and Password. Click the Test Connection button.
Step 12: Connection Established
Once done, you will find a pop-up showing Connection is successful. Click Ok. Again tap OK to start the process.
Step 13: Process Completes
Finally, you will find a pop-up showing the message: Saving process completed successfully. Click OK.
Step 14: Save MySQL As Script
Opt for the Save as Script option and click on the Browse button to select the saving folder and click OK.
Step 15: Script Creation
Finally, your Script was created successfully at the chosen location. Click OK.