4

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?

qadenza
  • 9,025
  • 18
  • 73
  • 126
  • 1
    Possible duplicate of [phpMyAdmin error: Table doesn't exist in engine](https://stackoverflow.com/questions/33964892/phpmyadmin-error-table-doesnt-exist-in-engine) – cwallenpoole Jul 04 '17 at 05:11
  • @cwallenpoole, no, it's not duplicated. windows vs ubuntu, system table vs user table. I cannot take ubuntu solution. – qadenza Jul 04 '17 at 05: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 Jul 04 '17 at 12:23

2 Answers2

5

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

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

Tomm
  • 1,021
  • 2
  • 14
  • 34
Kennedy Maikuma
  • 79
  • 1
  • 5
  • 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 ? – Prometheus Nov 14 '18 at 14:36
  • 1
    Honestly I havnt done it before but a quick google search took me to this https://dba.stackexchange.com/questions/93507/alter-all-tables-discard-tablespace 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 Nov 14 '18 at 14:53
  • Hope it helps . – Kennedy Maikuma Nov 14 '18 at 15:10
  • When I run that script, I get another error: `#1030 - Got error 194 "Tablespace is missing for a table" from storage engine InnoDB` – Serge Kishiko Apr 16 '20 at 04:49
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

SherylHohman
  • 16,580
  • 17
  • 88
  • 94
  • there is no `/* Server parameters */` line in my `config.inc.php.` Search in notepad++. – qadenza Jul 04 '17 at 05:27
  • If you dont have "Server parameters" then you must have "Servers configuration" –  Jul 04 '17 at 05:29