MySQL InnoDB数据库还原 [英] MySQL InnoDB database restore

问题描述

我必须还原一个在MySQL 5.0中无意中被删除的数据库.从检查备份文件来看，我似乎只有.FRM文件来保存数据库数据.

I have to restore a database that has been inadvertently DROPped in MySQL 5.0. From checking the backup files, I only seem to have .FRM files to hold the database data.

任何人都可以建议这是我从备份执行数据库还原/导入所需的全部，还是我还需要处理其他文件?

Can anyone advise whether this is all I need to perform a database restore/import from the backup, or are there other files I should have to hand to complete this?

推荐答案

.frm文件不是数据文件，它们仅存储数据字典信息"(请参见此处.

.frm files are not the data files, they just store the "data dictionary information" (see MySQL manual). InnoDB stores its data in ib_logfile* files. That's what you need in order to do a backup/restore. For more details see here.

这篇关于MySQL InnoDB数据库还原的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！