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?


[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;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy