Stellar Knowledge Base

When and How to recover MySQL databases on a different system running Windows?

 Modified on: May 16, 2019 |    22132 views

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:

  1. 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
  2. After copying the folders, paste them to a drive on a different Windows PC where you need to perform recovery.
  3. Now, run Stellar Repair for MySQL. The main interface of the software appears along with a dialog box.
  4. 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.
  5. The next screen shows a list of all MySQL databases in the system. Select the databases you need to recover and click OK.
  6. All databases with their respective components are displayed in a tree structure in the left pane.
  7. You can select any object to see its preview in the right pane.
  8. Select the databases you want to recover and then click Start Repair icon on the tool bar.
  9. Provide the user login information of your MySQL database.
  10. The 'Messagelog' pane shows the log of the recovery process.
  11. After completion of the process, you receive the following message: Saving process completed
  12. Now, stop MySQL server in the source system.
  13. Copy and paste all recovered databases to the following location in the source system:
    C:\Program Files\MySQL\MySQL Server 8.0\data
  14. Start the MySQL server.

 

2 User Comments

I repaired a corrupted database files with Innodb from a Linux system...I copied the files back into Linux MySQL but it's failing to start...

gravatar

Chris Miramon

Hi Chris,

Are you getting any error message?

MySQL records startup error into /var/log/syslog. Please check and share the error.

Thanks,

gravatar

Amit Pandey

 

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