#1932 Table '***.***.***_***' doesn't exist in engine

Problems with the Windows version of XAMPP, questions, comments, and anything related.

#1932 Table '***.***.***_***' doesn't exist in engine

Postby Perrorist » 26. May 2021 07:12

I decided to replace my XAMPP folder with a new download so that I could get a later PHP version. Before doing that, I saved my htdocs and ./mysql/data sub-folders. After installing the latest version, I restored the subfolders, choosing not to overwrite new files with the same name.

When I went to run one of my sites by using localhost, I received the message "Error establishing a database connection."

Using phpmyadmin, I went to the database and got this message when I clicked a table: "#1932 - Table '***.***.***_options' doesn't exist in engine'. It was true for the other tables, too.

It looks like my replacement strategy didn't work as expected. I have quite a few databases and I'm wondering if and how it is possible to overcome this problem.
User avatar
Perrorist
 
Posts: 16
Joined: 02. January 2009 10:42
Location: Australia
XAMPP version: 7.3.28
Operating System: Windows 10 Pro x64

Re: #1932 Table '***.***.***_***' doesn't exist in engine

Postby Altrea » 26. May 2021 07:57

It does not work if xou don't overwrite files. MySQL/MariaDB saves InnoDB Databases in shared files like the ibdata1 file.
And it may or may not work if you overwrite the files, so be sure to keep your backup safe.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: #1932 Table '***.***.***_***' doesn't exist in engine

Postby Perrorist » 26. May 2021 08:58

Thanks. I overwrote the files this time, but is still didn't work. I may have to uninstall this new version and see what happens when I restore XAMPP from a backup.
User avatar
Perrorist
 
Posts: 16
Joined: 02. January 2009 10:42
Location: Australia
XAMPP version: 7.3.28
Operating System: Windows 10 Pro x64

Re: #1932 Table '***.***.***_***' doesn't exist in engine

Postby Perrorist » 27. May 2021 00:04

I finally figured it out. I still had mysql running when I copied the old files over the new ones. Once I stopped and restarted, the error disappeared.
User avatar
Perrorist
 
Posts: 16
Joined: 02. January 2009 10:42
Location: Australia
XAMPP version: 7.3.28
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 105 guests