Here’s a uncomplicated fashion to restoring a MySQL database using solely the /data folder from an master MySQL installation. Rather than risking damaging the existing server, the database must hold upwards restored on a evolution or essay car NOT the actual server.
 Note |
|---|
| Restore the database on a evolution or essay car NOT the actual server. This article assumes you lot are comfortable amongst software solutions such equally XAMPP together with phpMyAdmin. |
- Find a essay or evolution car amongst Windows XP SP2 or higher.
- Download together with install a fresh re-create of XAMPP.
- Create an empty database using phpMyAdmin amongst the same refer equally your master database, (the 1 you’re trying to restore). For example, if your previous database was called ‘wordpress,’ inward phpMyAdmin, (under the ‘Create novel database’ text field), you lot would run across ‘wordpress.’ This volition practise a folder named wordpress inward “C:\xampp\mysql” inward XAMPP.
- At this indicate you’ll desire to plough off the MySQL service.
- Now, re-create the contents of your mysql database folder (not the entire folder) that contains the .frm files to the novel location.
- The side yesteryear side footstep is to re-create the ibdata1 file to the MySQL folder inward XAMPP
- Start the MySQL service again.
- Now you lot should hold upwards able to locate your database tables inward phpMyAdmin.
- At this indicate you’ll desire to export the database using phpMyAdmin.
- Be certain to cheque Add DROP TABLE, select SQL equally the export type, together with cheque the ‘Save equally file’ checkbox.
- The .sql file that volition hold upwards generated tin easily hold upwards imported into approximately other illustration of phpMyAdmin.
The novel database doesn’t demand to convey the same refer equally the previous database. Sometimes, you lot may hold upwards unable to role the previous database refer because the site may convey been moved to a shared hosting server, (with a pre-defined database name).
This illustration uses XAMPP together with phpMyAdmin. However, in that place are many other alternatives available that volition permit you lot to make the same tasks, together with there’s ever the ascendancy line. The virtually of import footstep is to but re-create the contents of the /data folder together with the ibdata1 file.
