When there is a potential risk of hardware or system crash, it is advisable to perform recovery on a different system that is running on the same platform. The user is required to copy the database from one system to another and perform recovery using Stellar Repair for MySQL.
The following things should be taken into consideration before starting with the recovery procedure:
- The system on which you are performing recovery should have MySQL application installed.
- The destination drive should have sufficient free space for storing all recovered MySQL databases.
Now, to perform MySQL database recovery, follow these steps:
- First, copy all database folders and ibdata1 that you want to recover from the following location: C:\Program Files\MySQL\MySQL Server 8.0\data
- After copying the folders, paste them to a drive on a different Windows PC where you need to perform recovery.
- Now, run Stellar Repair for MySQL. The main interface of the software appears along with a dialog box.
- In the dialog box, select the folder containing database(s) and click OK. If ibdata1 is not present in the selected folder, you will be prompted to specify the path of this file.
- The next screen shows a list of all MySQL databases in the system. Select the databases you need to recover and click OK.
- All databases with their respective components are displayed in a tree structure in the left pane.
- You can select any object to see its preview in the right pane.
- Select the databases you want to recover and then click Start Repair icon on the tool bar.
- Provide the user login information of your MySQL database.
- The 'Messagelog' pane shows the log of the recovery process.
- After completion of the process, you receive the following message: Saving process completed
- Now, stop MySQL server in the source system.
- Copy and paste all recovered databases to the following location in the source system:
C:\Program Files\MySQL\MySQL Server 8.0\data
- Start the MySQL server.