phpMyAdmin error 1932 - table doesn't exist in engine

Question

windows 7 - xampp

I have a database with 14 tables. I worked this days with all of them without problems untill this morning.

All tables are ok except table posts. When I click on it's name (left menu in phpMyAdmin) I got a message:

#1932... posts doesnt exist in engine

On stackoverflow there are six posts with simmilar title, but there is no solution for me.

For example this is about a system table phpmyadmin.pma and on ubuntu. I'm on windows and table posts is a user table.

Any help?

Possible duplicate of phpMyAdmin error: Table doesn't exist in engine — cwallenpoole
– cwallenpoole, Commented Jul 4, 2017 at 5:11
@cwallenpoole, no, it's not duplicated. windows vs ubuntu, system table vs user table. I cannot take ubuntu solution. — qadenza
– qadenza, Commented Jul 4, 2017 at 5:17
There seem to be quite a few answers to very similar questions. Have you tried all of them? Then why isn't that information in your post? — cwallenpoole
– cwallenpoole, Commented Jul 4, 2017 at 12:23

Tom · Accepted Answer · 2018-01-25 09:00:32Z

5

This worked for me when I was not able to repair the table

ALTER TABLE Tablename DISCARD TABLESPACE; ALTER TABLE Tablename IMPORT TABLESPACE;

edited Jan 25, 2018 at 9:00

Tom

1,0172 gold badges15 silver badges36 bronze badges

answered Jan 25, 2018 at 8:40

Kennedy Maikuma

791 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Prometheus Over a year ago

What if i have many tables that need the same procedure . Is there any way doing this or i have to execute the above queries for each table ?

Kennedy Maikuma Over a year ago

Honestly I havnt done it before but a quick google search took me to this dba.stackexchange.com/questions/93507/… If the tables are less you can do the answer above otherwise can try the shared link, Let me know how it goes.

Kennedy Maikuma Over a year ago

Hope it helps .

Serge Kishiko Over a year ago

When I run that script, I get another error: #1030 - Got error 194 "Tablespace is missing for a table" from storage engine InnoDB

SherylHohman · Accepted Answer · 2020-01-20 20:43:22Z

1

I got it working with some changes in xampp/phpmyadmin/config.inc.php:

Add a $i=1 after /* server parameters */

/* Server parameters */

$i = 1

AND fix tablespaces of phpMyAdmin as written in https://stackoverflow.com/a/11506495/2364405

edited Jan 20, 2020 at 20:43

SherylHohman

18.2k18 gold badges94 silver badges101 bronze badges

answered Jul 4, 2017 at 5:21

user2852575

2 Comments

qadenza Over a year ago

there is no /* Server parameters */ line in my config.inc.php. Search in notepad++.

user2852575 Over a year ago

If you dont have "Server parameters" then you must have "Servers configuration"

Collectives™ on Stack Overflow

phpMyAdmin error 1932 - table doesn't exist in engine

2 Answers 2

4 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related