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


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


Was this article helpful?

Yes No

Category: MYSQL Database Repair

Last updated on June 1, 2015 with 8815 views

0 User Comments

There are no comments yet...Kick things off by filling out the form below.

Leave a Comment