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?
-
This question has nothing to do with sw development, this is purely admin stuff.– ShadowCommented Feb 23, 2017 at 10:50
-
possible dulicate of : stackoverflow.com/questions/9041976/…– Arsalan MithaniCommented Feb 23, 2017 at 10:51
-
2Possible duplicate of Recovering mysql database from data folder backup– Arsalan MithaniCommented Feb 23, 2017 at 10:51
-
dba.stackexchange.com/questions/71596/…– Peter RCommented Feb 23, 2017 at 12:26
Add a comment
|
1 Answer
[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;
