Mysql - How to restore mysql database from frm files, Xampp restore mysql database from frm format

How to restore mysql database from frm files

Many time when you use xampp, you will be having a qustion on restoring mysql database from you can restore mysql databases from .frm file. You can follow the below steps to restore the database.

1) Copy your database folders from the data folder("C:\\xampp\mysql\data")
2) Paste the database into your new xampp server under data folder("C:\\xampp\mysql\data")
3) Now, if you run phpmyadmin, you will be able to see your databases with none of the tables.
4) .frm files will contain only the table structure and not the data.
5) Now, stop MySQL service
6) Copy "ibdata1" file from your old mysql/data folder and paste it the new mysql/data folder.
    Note: if you need, you can rename the old file "ibdata1" and then paste the copied one.
7) Start MySQL service.
8) Finally, run phpmyadmin, you will be able to see the database with the all the tables.

The topic on Mysql - How to restore mysql database from frm files is posted by - Math

Hope you have enjoyed, Mysql - How to restore mysql database from frm filesThanks for your time