Table does not exist in engine #1932 – MySQL

I have faced the same issue and sorted using the 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 exists under C:/xampp/mysql/data/
  • If the file does not exist copy the ibdata1 file from location C:\xampp\mysql\backup\ibdata1

hope it helps someone.

Was this post helpful?
Let us know if you liked the post. That’s the only way we can improve.
Yes0
No3
Harinder Singh

Harinder Singh

My name is Harinder Singh and I specialize in Software industry. I consider myself as a life learner. I love learning new concepts, embracing new ideas and reading and searching for innovation.