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

Check whether you have any luck with this [post](http://stackoverflow.com/a/33925030/5850835) and this [post](http://stackoverflow.com/a/25040628/5850835) — Thush-Fdo, Aug 04 '16 at 09:07

score 67 · Answer 1 · answered Feb 07 '18 at 04:42

67

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

answered Feb 07 '18 at 04:42

Nava Bogatee

1,465
13
15

1

That worked for me. I installed new version of XAMPP and moved mysql/data and htdocs form the old one to newest one. after this problem appears until I followed your instructions. Thanks :) – Zuhair Taha Apr 15 '18 at 11:59
3

I did that but the problem still exists – PHPFan Jan 11 '21 at 08:33
1

Thanks a lot, that helps – Marius Illmann Nov 23 '21 at 20:30
1

omg thanks man, after 1 day try several ways. Big thanks, brother!! – plonknimbuzz Feb 12 '22 at 15:09
1

Still works for upgrade from mysql5.7.14 to mariadb10.6.5 – Pamira Oct 06 '22 at 18:09
What if you deleted the ib_logfileXX files by mistake. – Miki Apr 19 '23 at 15:45

score 55 · Answer 2 · answered Jun 28 '17 at 09:54

55

I have faced same issue and sorted using below step.

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

hope it helps to someone.

answered Jun 28 '17 at 09:54

Rohan Patil

1,865
1
23
36

9

Copying ibdata1 solved the issue for me, but now I get other errors in phpmyadmin. "Table 'phpmyadmin.pma__tracking' doesn't exist in engine". – mike_freegan Aug 04 '19 at 16:08
1

This crashed my phpmyadmin using xampp. when i start mysql it's not going start – Rakesh Sharma Mar 25 '20 at 05:36
file exist in my case but error also exist in phpmyadmin and php site – Heemanshu Bhalla Sep 21 '22 at 13:21
1

I often see this problem. Copy backup folder and rename as data and after replace the old ibdata1 100% fixed my mysql problem – Yağmur Kopar Jan 07 '23 at 16:00

Jay Momaya · Answer 3 · 2022-05-10T05:24:56.930

13

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.

edited May 10 '22 at 05:24

answered May 29 '20 at 06:38

Jay Momaya

1,831
19
32

Abd Abughazaleh · Answer 4 · 2022-12-21T18:57:32.440

9

Don't copy `ibdata1` file

This occurred to me when I take all files from the backups folder. There is a file you should not copy with other folders and files, called ibdata1.

edited Dec 21 '22 at 18:57

answered Nov 07 '21 at 11:03

Abd Abughazaleh

4,615
3
44
53

This means we cannot copy the table folder only for backup or other purposes. It needs to be copied all data folder instead. – GeneCode Nov 22 '21 at 09:39

score 8 · Answer 5 · answered Oct 05 '19 at 18:08

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:

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

score 8 · Answer 6 · edited Jun 13 '22 at 17:05

8

You could:

Rename data folder to data-old
Create new folder and set name to data
Copy backup folder in data folder
Copy ibdata1 in data-old to data folder
Restart MySQL and Apache

After solving the problems, get output power from the database

edited Jun 13 '22 at 17:05

Waldi

39,242
6
30
78

answered Jun 10 '22 at 11:36

abolfazl maherani

119
1
3

copying ibdata1 from old folder bring the problem back. if i delete this file then run mysql it is created automaticall and problem is solved. – MindRoasterMir Dec 03 '22 at 17:53

score 7 · Answer 7 · answered May 28 '19 at 04:26

7

stop mysql
copy xampp\mysql\data\ib* from old server to new server
start mysql

answered May 28 '19 at 04:26

kan

71
1
1

score 2 · Answer 8 · answered Jun 12 '20 at 15:03

2

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"

answered Jun 12 '20 at 15:03

Zurupupz

335
2
12

Also check @Jay Momaya's answer, happenned to me again and that solved it too – Zurupupz Feb 27 '21 at 16:24
This is the perfect solution – Pooja Aug 25 '21 at 07:22

score 2 · Answer 9 · answered Sep 29 '21 at 08:53

2

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

answered Sep 29 '21 at 08:53

Taufik Hasan A

176
1
3

score 2 · Answer 10 · answered Sep 09 '22 at 10:37

2

100% working solution

Stop MySQL and Apache and quit Xampp.
Make a backup of the "data" folder.

C:\xampp\mysql\data

Copy all the files from this folder

C:\xampp\mysql\backup 4. Paste and replace to

C:\xampp\mysql\data

answered Sep 09 '22 at 10:37

Ahsan Najam

155
1
8

score 1 · Answer 11 · answered Sep 27 '22 at 09:44

Instructions for Ubuntu users:

Copy a database (e.g. from the external disk backup).

sudo cp -r /media/some_user/mysql/some_database/ /opt/lampp/var/mysql/

NOTE: from this moment on, the database already appears in PHPMyAdmin, but if you click on it, the tables still do not appear

Change the owner to mysql (because when copying the owner it was changed to root)

sudo chown -R mysql:mysql some_database/

NOTE: from this moment the name of the tables appears but you can't see their structure or data - it shows the error "#1932 - Table 'some_database.some_table' doesn't exist in engine"

Copy the ibdata1 file and also change the owner.

sudo mv ibdata1 ibdata1_old

sudo cp /media/some_user/mysql/ibdata1 /opt/lampp/var/mysql/

sudo chown -R mysql:mysql ibdata1
Restart XAMPP

sudo /opt/lampp/lampp restart

Legend, Thank you man, saved my day!! i copied the old ibdata1 to mysql in the new installation folder and made it owner and it worked. — zakaria kasmi, Dec 24 '22 at 04:48

score 0 · Answer 12 · edited Dec 28 '16 at 04:42

0

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

edited Dec 28 '16 at 04:42

Nagama Inamdar

2,851
22
39
48

answered Dec 28 '16 at 03:47

lsfiege

17
4

8

Welcome to Stackoverflow. Would you mind extending your answer little bit more, for fellow programmers, to understand how it helped to solve the problem. – Nagama Inamdar Dec 28 '16 at 04:42
2

Can you explain your second point? Because first point worked for me and now I lost all the data. I can see the list of tables but when I click on any, says table does not exists in the engine. – Vipul Hadiya Sep 11 '19 at 06:32
@VipulHadiya did you find any solution? I am currently stuck with the same problem as yours. – Raju Ahmed Sep 15 '20 at 12:03
@RajuAhmed No, fortunately, I had backup of every single database so I have deleted them all and imported all SQL one by one. – Vipul Hadiya Sep 15 '20 at 16:06
@VipulHadiya Yes - this is, also, the best solution I have found also but very time consuming. Having gone through this about 3 times in the past few years. I'm looking for an explanation of how the tables get deleted in the first place and whether there are maintenance steps I can take to prevent that. – FeralReason Jun 24 '22 at 18:38

score 0 · Answer 13 · edited Aug 16 '19 at 10:17

0

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.

edited Aug 16 '19 at 10:17

milanbalazs

4,811
4
23
45

answered Aug 16 '19 at 08:46

Abu Mutea

1
1

score 0 · Answer 14 · answered May 19 '21 at 20:33

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 "Empty Session Data" in your phpmyadmin, solved my problem.

Jopsy · Answer 15 · 2022-03-21T11:41:12.247

If you have tried all the above answers and yet failed, first try to fix your db by running this command,

mysqlcheck --repair my_db_name -u root -p

And then if issue fixed,

If not fixed and you have a backup of the table with you and not able to import it to the PHPMyAdmin, do the following.

1. Go to xampp\mysql\data\database_folder

2. Delete the files (with extension .frm and .ibd) starting with your table name. Eg: my_table.frm, my_table.ibd

3. Import your table

It worked for me.

score 0 · Answer 16 · answered Jan 04 '23 at 09:30

I found the following answer at https://stackoverflow.com/a/66804621 helpful

If you are just moving your DB from one folder to another folder, but your InnoDB tables no longer work, because they can't be found and the error message "Table does not exist in the engine" is displayed, then these pair of SQL statements can be as quick as helpful:

ALTER TABLE __yourtable_name__ DISCARD TABLESPACE ;

ALTER TABLE __yourtable_name__ IMPORT TABLESPACE ;

In pratice, the .IDB file is detached from .FRM file and then bound again, so that table contents turn into readable.

It worked in my case. Hope yours too.

score 0 · Answer 17 · answered Apr 04 '23 at 16:04

Try these steps

stop mysql and apache server
copy backup folder
copy database folders from data folder to backup copy folder
delete ibdata1 from backup copy folder
copy ibdata1 from data folder to backup copy folder
delete data folder
rename backup copy folder to data folder
restart the xampp server

Muhammad Bilal · Answer 18 · 2021-05-27T13:36:49.943

-2

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

edited May 27 '21 at 13:36

answered Feb 04 '20 at 13:14

Muhammad Bilal

497
1
5
12

3

Your solution delete my entire database table – STA Mar 20 '21 at 13:42
1

Please before you do this, backup the content of the data folder somewhere. Mysql creates folders that keeps files needed by your databases to work. – Cyril Ikelie Jul 29 '22 at 13:05

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

18 Answers18

Don't copy `ibdata1` file

100% working solution

Linked

Related

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

18 Answers18

Don't copy ibdata1 file

100% working solution

Linked

Related

Don't copy `ibdata1` file