blocks|key|1502704|text|我也遇到过同样的问题，并使用下面的步骤进行了排序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1502705|1502706|转到MySQL配置文件(我在C:\xampp\mysql\bin\my.ini)|ordered-list-item|offset|length|style|CODE|1502707|Check的文件中找到行innodb_data_file_path+=+ibdata1:10M:autoextend|1502708|Next检查C:/xampp/mysql/data/|1502709|If文件下是否存在ibdata1文件不存在从位置C:\xampp\mysql\backup\ibdata1|1502710|复制ibdata1文件|1502711|希望能对某些人有所帮助。|1502712|entityMap^0|0|0|E|P|0|C|1A|0|6|K|0|9|7|O|T|0|2|7|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|X|8|@$F|Y|G|Z|H|I]]|9|@]|A|$]]|$1|J|3|K|5|E|7|10|8|@$F|11|G|12|H|I]]|9|@]|A|$]]|$1|L|3|M|5|E|7|13|8|@$F|14|G|15|H|I]]|9|@]|A|$]]|$1|N|3|O|5|E|7|16|8|@$F|17|G|18|H|I]|$F|19|G|1A|H|I]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1B|8|@$F|1C|G|1D|H|I]]|9|@]|A|$]]|$1|R|3|S|5|6|7|1E|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|U|$]]

I have faced same issue and sorted using below step.

<ol>
<li>Go to MySQL config file (my file at <code>C:\xampp\mysql\bin\my.ini</code>)</li>
<li>Check for the line <code>innodb_data_file_path = ibdata1:10M:autoextend</code></li>
<li>Next check the <code>ibdata1</code> file exist under <code>C:/xampp/mysql/data/</code></li>
<li>If file does not exist copy the <code>ibdata1</code> file from location <code>C:\xampp\mysql\backup\ibdata1</code></li>
</ol>

hope it helps to someone.

blocks|key|5287582|text|将ib_logfileXX和ibdata数据文件从旧的mysql+/文件夹复制到新的mysql数据文件夹，就可以解决这个问题。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|5287583|entityMap^0|1|C|E|K|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

Copy the ib_logfileXX and ibdata 
file from old mysql/data folder to the new mysql data folder and it will fix the issue

blocks|key|5287714|text|如果你已经将文件从旧的备份文件夹复制并粘贴到新的文件夹中，那么这很简单。只需将旧的ibdata1复制到新的your中。你可以在\xampp\mysql\data上找到它|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5287715|entityMap^0|15|7|1R|H|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

If you have copied &amp; Pasted files from an old backup folder to new then its simple. 
Just copy the old <code>ibdata1</code> into your new one. You can find it from <code>\xampp\mysql\data</code>

blocks|key|1760319|text|不复制ibdata1文件|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1760320|当我从backups文件夹中取出所有文件时，就会发生这种情况。但不要复制名为ibdata1的文件。|1760321|entityMap^0|3|7|0|12|7|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

<h1>Don't copy <code>ibdata1</code> file</h1>
This occurred with me when i take all files form backups folder. but don't copy file called <code>ibdata1</code>.

blocks|key|1760164|text|我也遇到了同样的问题，但复制xampp\mysql\data\ibdata1并没有解决我的问题，因为我安装了新版本的xampp，如果你升级你的xampp首先从所有的htdocs和mysql文件夹进行备份，在我的情况下，我只是备份所有的xampp到新的文件夹，如old-xampp，然后安装新的xampp，然后你需要做以下步骤才能启动新的xampp服务器：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1760165|1760166|从新的安装位置备份phpmyadmin文件夹和ibdata1此位置xampp\mysql\data.|ordered-list-item|1760167|Then转到旧的xampp文件夹old-xampp\mysql\data并从旧的location.|1760168|Then复制ibdata1文件和phpmyadmin打开新的xampp文件夹xampp\mysql\data并将它们传递到此处。|1760169|H118启动xampp服务器。<代码>H219<代码>G220|1760170|entityMap^0|E|O|2A|6|2H|5|3M|9|0|0|9|A|N|7|X|G|0|G|K|0|6|7|G|A|12|G|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]|$9|U|A|V|B|C]|$9|W|A|X|B|C]|$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|10|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|11|8|@$9|12|A|13|B|C]|$9|14|A|15|B|C]|$9|16|A|17|B|C]]|D|@]|E|$]]|$1|J|3|K|5|I|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|L|3|M|5|I|7|1B|8|@$9|1C|A|1D|B|C]|$9|1E|A|1F|B|C]|$9|1G|A|1H|B|C]]|D|@]|E|$]]|$1|N|3|O|5|6|7|1I|8|@]|D|@]|E|$]]|$1|P|3|-4|5|6|7|1J|8|@]|D|@]|E|$]]]|Q|$]]

I have faced same issue but copying the <code>xampp\mysql\data\ibdata1</code> was not solved my problem, because I install new version of xampp, if you upgrading your xampp first make backup from all <code>htdocs</code> and <code>mysql</code> folder, in my case I just backup the all xampp to the new folder like <code>old-xampp</code> then install new xampp and then you need do the following steps before starting your new xampp servers: 

<ol>
<li>Backup the <code>phpmyadmin</code> folder and <code>ibdata1</code> from your new installation form this location <code>xampp\mysql\data</code>.</li>
<li>Then Go to your old xampp folder <code>old-xampp\mysql\data</code> and copy the <code>ibdata1</code> file and <code>phpmyadmin</code> from old location.</li>
<li>Then open your new xampp folder <code>xampp\mysql\data</code> and past them there.</li>
<li>Start the xampp servers.</li>
</ol>

blocks|key|3870338|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3870339|停止mysql|ordered-list-item|3870340|将xampp\mysql\data\ib*从旧服务器复制到新服务器|3870341|启动mysql|3870342|3870343|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|K|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|L|7|@]|8|@]|9|$]]|$1|D|3|E|4|C|6|M|7|@]|8|@]|9|$]]|$1|F|3|G|4|C|6|N|7|@]|8|@]|9|$]]|$1|H|3|-4|4|5|6|O|7|@]|8|@]|9|$]]|$1|I|3|-4|4|5|6|P|7|@]|8|@]|9|$]]]|J|$]]

<ol>
<li>stop mysql</li>
<li>copy xampp\mysql\data\ib* from old server to new server</li>
<li>start mysql</li>
</ol>

blocks|key|1760308|text|好的，第一步，您可以从旧的xampp+xampp\+mysql+\data\ibdata1复制，第二步粘贴到新的xampp+xampp\mysql\data\ibdata1，然后打开您的xampp控制器，停止mysql并重新启动。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1760309|我试过了，这对我很有效。|1760310|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

ok step one you can copy from your old xampp xampp\mysql\data\ibdata1 and step two paste to your xampp new xampp\mysql\data\ibdata1 ,
and than open your xampp controller and stop mysql and start again.
i tried this and is work for me

blocks|key|3870519|text|我之前移动了mysql目录，忘记了更改对\mysql\bin\my.ini中旧位置的所有引用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3870520|更改以下三行：|3870521|datadir+=+"/programs/xampp/mysql/data"
innodb_data_home_dir+=+"/programs/xampp/mysql/data"
innodb_log_group_home_dir+=+"/programs/xampp/mysql/data"|code-block|syntax|javascript|3870522|将"/programs/xampp/mysql/data“更改为新位置此位置已添加注释，但我仍对其进行了更改|3870523|#innodb_log_arch_dir+=+"/programs/xampp/mysql/data"|3870524|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I had previously moved my mysql directory and forgot to change ALL references to the old location in \mysql\bin\my.ini.

change these three lines: 

<pre><code>datadir = "/programs/xampp/mysql/data"
innodb_data_home_dir = "/programs/xampp/mysql/data"
innodb_log_group_home_dir = "/programs/xampp/mysql/data"
</code></pre>

Change "/programs/xampp/mysql/data" to new location
this one was commented but I changed it anyways

<pre><code>#innodb_log_arch_dir = "/programs/xampp/mysql/data"
</code></pre>

blocks|key|5287507|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5287508|将backups文件夹的内容复制到data文件夹。这对我很有效。|unordered-list-item|offset|length|style|CODE|5287509|之后，您必须重新配置现有数据库的innodb文件|5287510|5287511|entityMap^0|0|1|7|H|4|0|0|0^^$0|@$1|2|3|-4|4|5|6|M|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|N|7|@$D|O|E|P|F|G]|$D|Q|E|R|F|G]]|8|@]|9|$]]|$1|H|3|I|4|C|6|S|7|@]|8|@]|9|$]]|$1|J|3|-4|4|5|6|T|7|@]|8|@]|9|$]]|$1|K|3|-4|4|5|6|U|7|@]|8|@]|9|$]]]|L|$]]

<ul>
<li>Copy the content of <code>backups</code> folder into <code>data</code> folder. This worked for me. </li>
<li>After this you have to reconfigure innodb files of your existent databases</li>
</ul>

blocks|key|5287597|text|我的mac也有同样的问题。我运行的是5.3.0版本。我删除了该版本并安装了7.2.1版本。在此之后，它在我的情况下工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5287598|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I also had same issue on my mac. I was running 5.3.0 version. I removed that version and installed 7.2.1 version. After this it is working in my case.

blocks|key|1760123|text|我也有同样的问题。我有我的C:\xampp\mysql\data文件夹的备份。但将其与新安装的xampp集成存在问题。因此，我找到了C:\xampp\mysql\bin\my.ini文件，并将innodb_data_home_dir+=+"C:/xampp/mysql/data"定向到我备份的数据文件夹中，它可以完美地工作。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1760124|entityMap^0|D|J|1B|5|1U|P|2O|18|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|G|$]]

I had the same issue. I had a backup of my <code>C:\xampp\mysql\data</code> folder. But integrating it with the newly installed <code>xampp</code> had issues. So I located the <code>C:\xampp\mysql\bin\my.ini</code> file and directed <code>innodb_data_home_dir = "C:/xampp/mysql/data"</code> to my backed-up data folder and it worked flawlessly.

blocks|key|5287701|text|对于我来说，我从xampp\mysql\中删除了整个data文件夹(并进行了备份)，并在这里粘贴了前一个文件夹的data文件夹，这解决了我的问题…|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5287702|entityMap^0|8|C|Q|4|1K|4|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

For me I removed whole <code>data</code> folder ( and took a backup ) from <code>xampp\mysql\</code> and pasted <code>data</code> folder of previous one here which solved my problem...

blocks|key|1502801|text|上面的解决方案对我都不起作用。将旧的mysql/data目录粘贴到新的xampp后，检查ibdata1是否拥有当前用户所需的所有权限，否则请尝试授予这些权限。然后你的phpmyadmin中的“空会话数据”解决了我的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1502802|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

None of the above solution works for me. After pasting your old mysql/data directory to your new xampp, Check if ibdata1 has all the permissions required by the current user otherwise try to grant the permissions. Then &quot;Empty Session Data&quot; in your phpmyadmin, solved my problem.

Xampp error after moving xampp folder:

<a href="https://i.stack.imgur.com/Fwc8O.png" rel="noreferrer"><img src="https://i.stack.imgur.com/Fwc8O.png" alt="enter image description here"></a>

Apache is running fine:

<a href="https://i.stack.imgur.com/DEy9P.png" rel="noreferrer"><img src="https://i.stack.imgur.com/DEy9P.png" alt="enter image description here"></a>

as given below image i'm sucess to run apache but unable to run mysql if in case i moved and run xampp both apache and mysql but its shows error which is fresh and it show the error like "Table doesn't exist in engine" #1932 as given up image. please solve the issue anyone help pls

Xampp-mysql - "Table doesn't exist in engine" #1932

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

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

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

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

社区新版编辑器体验调研

移动Xampp文件夹后出现xampp错误：​​Apache运行得很好：​​如下图所示，我成功地运行了apache，但如果我移动并运行了apache和mysql的xampp，则无法运行mysql，但它显示错误，这是最新的，它显示错误，如“表不存在于引擎”#1932作为放弃的图像。请大家帮我解决这个问题

问Xampp-mysql -“引擎中不存在表”#1932
EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Xampp-mysql -“引擎中不存在表”#1932EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Xampp-mysql -“引擎中不存在表”#1932
EN