blocks|key|10467|text|要将数据库恢复到XAMPP，需要以下内容：-.frm、.ibd文件和ibdata1可以在mysql/data文件夹中找到|type|unstyled|depth|inlineStyleRanges|entityRanges|data|10468|步骤|10469|安装新XAMPP|unordered-list-item|10470|在mysql/data中替换ibdata1|10471|复制要还原.frm和.ibd的数据库文件夹，并粘贴到mysql/data中|10472|运行mysql和Viola，它可以工作！|10473|如果出现#1932错误，只需从xampp/phpMyAdmin/sql导入create_tables.sql，就可以解决这个问题。|blockquote|10474|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|T|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|O|7|X|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|Q|$]]

To restore your database to XAMPP these are the things you need:
 -.frm , .ibd files , and ibdata1 can be found in mysql/data folder

Steps

<ul>
<li>Install New XAMPP</li>
<li>Replace ibdata1 in mysql/data</li>
<li>Copy the folders of the database you want to restore [.frm and .ibd]
and paste in mysql/data</li>
<li>Run the mysql and Viola it works!</li>
</ul>

<blockquote>
 If there is an #1932 error occur, just import the create_tables.sql
 from xampp/phpMyAdmin/sql and this solves the problem.
</blockquote>

blocks|key|10439|text|您无法复制包含InnoDB表的数据库文件夹，因为InnoDB存储引擎在InnoDB表的物理文件(frm和.ibd)和数据字典之间保持着共生关系。|type|blockquote|depth|inlineStyleRanges|entityRanges|data|10440|参考资料：https://dba.stackexchange.com/questions/82093/moving-binary-database-folder-is-causing-issues-with-innodb-tables|unstyled|offset|length|10441|您可以尝试(InnoDB部件)：https://dba.stackexchange.com/questions/57120/recover-mysql-database-from-data-folder-without-ibdata1-from-ibd-files/57157#57157|10442|Recommendation：在您的情况下可能已经晚了，但是，在您转移到另一台服务器之前，最好将数据库导出到sql文件并从phpmyadmin、Mysql、SQLyog或终端导入它。|style|BOLD|10443|出口：|10444|mysqldump+-u+user+-p+password+database_name+>+database_name.sql|code-block|syntax|javascript|10445|Import|10446|mysql+-u+user+-p+password+database_name+<+database_name.sql|10447|entityMap|0|LINK|mutability|MUTABLE|url|https://dba.stackexchange.com/questions/82093/moving-binary-database-folder-is-causing-issues-with-innodb-tables|1|https://dba.stackexchange.com/questions/57120/recover-mysql-database-from-data-folder-without-ibdata1-from-ibd-files/57157#57157^0|0|5|34|0|0|G|3K|1|0|0|E|0|0|3|0|0|0|6|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|18|8|@]|9|@$E|19|F|1A|1|1B]]|A|$]]|$1|G|3|H|5|D|7|1C|8|@]|9|@$E|1D|F|1E|1|1F]]|A|$]]|$1|I|3|J|5|D|7|1G|8|@$E|1H|F|1I|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|1J|8|@$E|1K|F|1L|K|L]]|9|@]|A|$]]|$1|O|3|P|5|Q|7|1M|8|@]|9|@]|A|$R|S]]|$1|T|3|U|5|D|7|1N|8|@$E|1O|F|1P|K|L]]|9|@]|A|$]]|$1|V|3|W|5|Q|7|1Q|8|@]|9|@]|A|$R|S]]|$1|X|3|-4|5|D|7|1R|8|@]|9|@]|A|$]]]|Y|$Z|$5|10|11|12|A|$13|14]]|15|$5|10|11|12|A|$13|16]]]]

<blockquote>
 You cannot copy a database folder that has InnoDB tables because
 InnoDB storage engine maintains a symbiotic relationship between the
 InnoDB tables' physical files (frm and .ibd) and the data dictionary.
</blockquote>

Reference: <a href="https://dba.stackexchange.com/questions/82093/moving-binary-database-folder-is-causing-issues-with-innodb-tables">https://dba.stackexchange.com/questions/82093/moving-binary-database-folder-is-causing-issues-with-innodb-tables</a>

You can try (InnoDB part): <a href="https://dba.stackexchange.com/questions/57120/recover-mysql-database-from-data-folder-without-ibdata1-from-ibd-files/57157#57157">https://dba.stackexchange.com/questions/57120/recover-mysql-database-from-data-folder-without-ibdata1-from-ibd-files/57157#57157</a>

Recommendation: It might be late in your case, however, before you move to another server, it is a good idea to export your databases to a sql file and Import it from phpmyadmin, Mysql Workbech, SQLyog or terminal

Export:

<pre><code>mysqldump -u user -p password database_name &gt; database_name.sql
</code></pre>

Import

<pre><code>mysql -u user -p password database_name &lt; database_name.sql
</code></pre>

blocks|key|10492|text|继续到andread，并将这些文件复制并替换到新的xampp文件夹中。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|10493|来自\xampp\mysql\data\mysql|style|CODE|10494|文件:+proc.frm，proc.MAD，proc.MAI|10495|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/FKMsf.png^0|D|4|0|0|2|N|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@$A|W|B|X|F|G]]|9|@]|C|$]]|$1|H|3|I|5|6|7|Y|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]]]

Continue to andread answer also copy and replace <a href="https://i.stack.imgur.com/FKMsf.png" rel="nofollow noreferrer">these files</a> to the new xampp folder.

From <code>\xampp\mysql\data\mysql</code> 

Files : proc.frm, proc.MAD, proc.MAI

blocks|key|2356013|text|我得到了以下日志：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2356014|2020-02-11+14:26:06+0+[ERROR]+mysqld:+Table+'.\mysql\db'+is+marked+as+crashed+and+last+(automatic?)+repair+failed+2020-02-11+14:26:06+0+[ERROR]+Fatal+error:+Can't+open+and+lock+privilege+tables:+Table+'.\mysql\db'+is+marked+as+crashed+and+last+(automatic?)+repair+failed+2020-02-11+14:26:06+0+[ERROR]+Aborting|code-block|syntax|javascript|2356015|我所做的如下：|2356016|在另一个目录(例如C:\xampp_new)中安装了XAMPP的新实例|ordered-list-item|2356017|将三个db文件从新安装复制回旧安装：|2356018|blockquote|2356019|C:\xampp_new\mysql\data\mysql\db.frm到C:\xampp\mysql\data\mysql\db.frm|unordered-list-item|2356020|C:\xampp_new\mysql\data\mysql\db.MAD到C:\xampp\mysql\data\mysql\db.MAD|2356021|C:\xampp_new\mysql\data\mysql\db.MAI到C:\xampp\mysql\data\mysql\db.MAI|2356022|从XAMPP启动MySQL服务，然后运行良好。|2356023|我希望这也能为那些陷入这样一个错误的人提供有用的信息。|2356024|当你试图设置特权时要小心。|2356025|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|16|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|17|8|@]|9|@]|A|$]]|$1|L|3|M|5|K|7|18|8|@]|9|@]|A|$]]|$1|N|3|-4|5|O|7|19|8|@]|9|@]|A|$]]|$1|P|3|Q|5|R|7|1A|8|@]|9|@]|A|$]]|$1|S|3|T|5|R|7|1B|8|@]|9|@]|A|$]]|$1|U|3|V|5|R|7|1C|8|@]|9|@]|A|$]]|$1|W|3|X|5|K|7|1D|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1E|8|@]|9|@]|A|$]]|$1|10|3|11|5|O|7|1F|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|13|$]]

I got the following logs:

<pre><code>2020-02-11 14:26:06 0 [ERROR] mysqld: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed 2020-02-11 14:26:06 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed 2020-02-11 14:26:06 0 [ERROR] Aborting
</code></pre>

Well, what I did as follows:

<ol>
<li>Installed a new instance of XAMPP in a different directory (e.g.
C:\xampp_new)</li>
<li>Copied back the three db files from the new installation to the old one:</li>
</ol>

<blockquote>
 <ul>
 <li>C:\xampp_new\mysql\data\mysql\db.frm to C:\xampp\mysql\data\mysql\db.frm</li>
 <li>C:\xampp_new\mysql\data\mysql\db.MAD to C:\xampp\mysql\data\mysql\db.MAD</li>
 <li>C:\xampp_new\mysql\data\mysql\db.MAI to C:\xampp\mysql\data\mysql\db.MAI</li>
 </ul>
</blockquote>

<ol start="3">
<li>Started MySQL service from XAMPP then it worked well.</li>
</ol>

I hope it could also be useful information for those who steps into an error like this.

<blockquote>
 Be careful when you are trying to set privileges.
</blockquote>

I have a backup of the entire <code>xampp/mysql</code> folder. How can I use it to recover my old db on a fresh installation of XAMPP? 

Simply copying the old <code>xampp/mysql</code> folder to new xampp leads to mysql errors like:

<blockquote>
 InnoDB: Table veno/sls37_finder_links_termsc in the InnoDB data
 dictionary has tablespace id 1171, but tablespace with that id or name
 does not exist. Have you deleted or moved .ibd files? This may also be
 a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files
 MySQL automatically removed, but the table still exists in the InnoDB
 internal data dictionary.
</blockquote>

How to restore mysql database in XAMPP?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我备份了整个xampp/mysql文件夹。如何使用它在XAMPP的新安装上恢复我的旧数据库？简单地将旧的xampp/mysql文件夹复制到新xampp会导致mysql错误，如下所示：InnoDB: InnoDB数据字典中的表veno/sls37 37_finder_links_termsc具有表空间id 1171，但不存在具有该id或名称的表空间。您是否删除或移动了.ibd文件？这也可能是使用CR

问如何在XAMPP中恢复mysql数据库？
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在XAMPP中恢复mysql数据库？EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在XAMPP中恢复mysql数据库？
EN