mysqlphpmyadmin

Recovering mysql database from data folder backup


I have uninstalled the old XAMPP and deleted all of the content of d:\xampp folder and installed the new one. When I copy my backup folder (with the name of my database, containing all .frm and .opt files) to the D:\xampp\mysql\data, the database shows in the list in phpmyadmin but it has no tables and data. What I've done wrong?


Solution

  • I've searched a lot. There's a few other files that are needed for recovery. I think it's impossible to recover tables from the .frm files alone. I've re-created my database.