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

Question

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

Answer 1

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.

Answer 2

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

Answer 3

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 And restart your mysql.