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

User · Answer

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"

User · Answer

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

User · Answer

If you have copied  amp  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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

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

Examples related to mysql

Examples related to windows