Stellar Knowledge Base

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

Author : Creative Team Updated on May 5, 2016

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 Phoenix Database 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.

Additionally, the system on which you are performing recovery should meet the following requirements:

-> Processor: Pentium 4 PC
-> Operating System: Windows 2000/XP/2003/Vista/Windows 7
-> Memory: Minimum 1GB (2 GB Recommended)
-> Hard Disk : 50 MB of free space
-> MySQL Version: 3.x/4.x/5.x/6.x

Now, to perform MySQL database recovery, follow the series of steps given below:

-> First, copy all database folders and ibdata1 that you want to recover from the following location:
C:\Program Files\MySQL\MySQL Server 6.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 Phoenix Database Repair for MySQL. The main interface of the software appears along with a dialog box.
-> In the dialog box, select Manual selection of database(s) for recovery and click Browse.
-> 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:

Repair process finished successfully

-> 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 6.0\data
-> Start the MySQL server.


2 User Comments


Chris Miramon
May 5, 2016 01:52 am

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...

Amit Pandey
May 5, 2016 02:57 am

Hi Chris,

Are you getting any error message?

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



User Comments