从数据文件夹备份中恢复mysql数据库 [英] Recovering mysql database from data folder backup

问题描述

我已经卸载了旧的XAMPP，并删除了d:\xampp folder的所有内容，并安装了新的XAMPP.当我将备份文件夹(具有我的数据库名称，包含所有.frm和.opt文件)复制到D:\xampp\mysql\data时，该数据库显示在phpmyadmin的列表中，但没有表和数据.我做错了什么?

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?

推荐答案

我进行了很多搜索.还有一些其他文件需要恢复.我认为仅从.frm文件中恢复表是不可能的.我已经重新创建了数据库.

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.

这篇关于从数据文件夹备份中恢复mysql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！