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

Xampp error after moving xampp folder:

Apache is running fine:

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

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

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 ibdata1 file exist under C:/xampp/mysql/data/
4. If file does not exist copy the ibdata1 file from location C:\xampp\mysql\backup\ibdata1

hope it helps to someone.

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.

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

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:

datadir = "/programs/xampp/mysql/data"
innodb_data_home_dir = "/programs/xampp/mysql/data"
innodb_log_group_home_dir = "/programs/xampp/mysql/data"

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

#innodb_log_arch_dir = "/programs/xampp/mysql/data"

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

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

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

1. Backup the phpmyadmin folder and ibdata1 from your new installation form this location xampp\mysql\data.
2. Then Go to your old xampp folder old-xampp\mysql\data and copy the ibdata1 file and phpmyadmin from old location.
3. Then open your new xampp folder xampp\mysql\data and past them there.
4. Start the xampp servers.

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

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