I have reinstall Windows on my System.I forget to export databases.Now i have .frm and .ibd files in my xampp folder how can i recover my database From these Files?
Asked
Active
Viewed 2,909 times
1
-
This question has nothing to do with sw development, this is purely admin stuff. – Shadow Feb 23 '17 at 10:50
-
possible dulicate of : http://stackoverflow.com/questions/9041976/recovering-mysql-database-from-data-folder-backup – Feb 23 '17 at 10:51
-
2Possible duplicate of Recovering mysql database from data folder backup – Feb 23 '17 at 10:51
-
http://dba.stackexchange.com/questions/71596/restoring-mysql-tables-from-ibd-frm-and-mysqllogbin-files – Peter R Feb 23 '17 at 12:26
1 Answers
1
[mysqld] innodb_file_per_table=1 innodb_force_recovery=5 --This will make MySQL skip a lot of checks on your data --create a dummy database, with dummy tables that have the same names as the --ones you wish to restore. -- stop mysql instance --copy over your .frm files now --start mysql mysql> use recover; mysql> flush tables; mysql> exit;
Peter R
- 76
- 1
- 1
- 6