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

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

提问by Yagya Bashyal

Xampp error after moving xampp folder:

移动 xampp 文件夹后 Xampp 错误：

Apache is running fine:

Apache 运行良好：

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 apache 和 mysql，我可以成功运行 apache 但无法运行 mysql 但它显示错误，这是新的，它显示错误，如“引擎中不存在表”第1932章 放弃形象 请解决这个问题任何人都请帮忙

回答by Rohan Patil

I have faced same issue and sorted using below step.

我遇到了同样的问题并使用以下步骤进行了排序。

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

1. 转到 MySQL 配置文件（我的文件位于C:\xampp\mysql\bin\my.ini）
2. 检查线路 innodb_data_file_path = ibdata1:10M:autoextend
3. 接下来检查ibdata1文件是否存在于C:/xampp/mysql/data/
4. 如果文件不存在，ibdata1则从位置复制文件C:\xampp\mysql\backup\ibdata1

hope it helps to someone.

希望它对某人有所帮助。

回答by Nava Bogatee

Copy the ib_logfileXXand ibdatafile from old mysql/data folder to the new mysql data folder and it will fix the issue

将ib_logfileXX和ibdata文件从旧的 mysql/data 文件夹复制到新的 mysql 数据文件夹，它将解决问题

回答by Alireza Nazari

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

我遇到了同样的问题，但复制xampp\mysql\data\ibdata1并没有解决我的问题，因为我安装了新版本的 xampp，如果你升级你的 xampp 首先从所有htdocs和mysql文件夹进行备份，在我的情况下，我只是像old-xampp那时一样将所有 xampp 备份到新文件夹安装新的 xampp，然后您需要在启动新的 xampp 服务器之前执行以下步骤：

1. Backup the phpmyadminfolder and ibdata1from your new installation form this location xampp\mysql\data.
2. Then Go to your old xampp folder old-xampp\mysql\dataand copy the ibdata1file and phpmyadminfrom old location.
3. Then open your new xampp folder xampp\mysql\dataand past them there.
4. Start the xampp servers.

1. 从这个位置备份phpmyadmin文件夹和ibdata1新安装xampp\mysql\data。
2. 然后转到旧的 xampp 文件夹并从旧位置old-xampp\mysql\data复制ibdata1文件phpmyadmin。
3. 然后打开您的新 xampp 文件夹xampp\mysql\data并将它们放在那里。
4. 启动 xampp 服务器。

回答by kan

1. stop mysql
2. copy xampp\mysql\data\ib* from old server to new server
3. start mysql

1. 停止mysql
2. 将 xampp\mysql\data\ib* 从旧服务器复制到新服务器
3. 启动mysql

回答by Abu Mutea

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

我遇到过同样的问题。我有我的C:\xampp\mysql\data文件夹的备份。但是将它与新安装的集成xampp有问题。因此，我找到了该C:\xampp\mysql\bin\my.ini文件并将其定向innodb_data_home_dir = "C:/xampp/mysql/data"到我的备份数据文件夹，并且它完美无缺地工作。

回答by Muhammad Bilal

For me I removed whole datafolder from xampp\mysql\and pasted datafolder of previous one here which solved my problem...

对我来说，我data从这里删除了整个文件夹xampp\mysql\并粘贴data了上一个文件夹，这解决了我的问题......

回答by Jay Momaya

If you have copied & Pasted files from an old backup folder to new then its simple. Just copy the old ibdata1into your new one. You can find it from \xampp\mysql\data

如果您已将旧备份文件夹中的文件复制并粘贴到新文件夹中，那么它很简单。只需将旧的复制ibdata1到新的中即可。你可以从\xampp\mysql\data

回答by amol

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.

我的 mac 也有同样的问题。我正在运行 5.3.0 版本。我删除了那个版本并安装了 7.2.1 版本。在此之后，它在我的情况下有效。

回答by lsfiege

• Copy the content of backupsfolder into datafolder. This worked for me.
• After this you have to reconfigure innodb files of your existent databases

• 将backups文件data夹的内容复制到文件夹中。这对我有用。
• 在此之后，您必须重新配置现有数据库的 innodb 文件