mySQL error: Table 'table' doesn't exist in engine

Question

Out of the sudden I am getting a weird error on my mysql database tables.

SELECT * FROM mytable

returns:

ERROR 1932 (42S02): Table 'mydb.mytable' doesn't exist in engine

I can confirm that the tables do indeed exist on local file system and show tables; does indeed return the tables I am interested in.

show tables;

+-----------------+
| Tables_in_mydb  |
+-----------------+
| presets         |
| mytable           |
+-----------------+

And the select:

select * from mytable;

Table 'mydb.mytable' doesn't exist in engine.

Error makes absolute no sense and I've been working with this tables a couple of days ago without any problems. I haven't moved the tables. What should I do?

Before that error above showed up I was getting an error:

Access denied for user 'root'@'localhost' (using password: YES),

but I successfully updated the password. I have no idea what triggered this error because I haven't played with passwords. However, when I tried to fix this error I have set permissions on /Applications/XAMPP/xamppfiles/var/mysql to read/write to everyone.

UPDATE:

show table status gives back a really weird outout:

    +-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+------------------------------------------------------+
    | Name            | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time | Check_time | Collation         | Checksum | Create_options | Comment                                              |
    +-----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+------------------------------------------------------+
    | preset          | NULL   |    NULL | NULL       | NULL |           NULL |        NULL |            NULL |         NULL |      NULL |           NULL | NULL                | NULL        | NULL       | NULL              |     NULL | NULL           | Table 'mydb.preset' doesn't exist in engine          |
    | mytable         | NULL   |    NULL | NULL       | NULL |           NULL |        NULL |            NULL |         NULL |      NULL |           NULL | NULL                | NULL        | NULL       | NULL              |     NULL | NULL           | Table 'mydb.mytable' doesn't exist in engine         |

Show us the code or the exact query you're running. Also: Have you selected a database? ie. USE `dbname` — Blue
– Blue, Commented Jan 25, 2018 at 20:38
just the most simple select * from table, where table is the name of the table. I have used USEbefore querying. — sanjihan
– sanjihan, Commented Jan 25, 2018 at 22:33

Evert · Accepted Answer · 2018-01-26 17:42:17Z

1

The SHOW TABLES result looks a little off. The box has a bit more space on the mytable line. Is it possible there's an invisible character in your tablename somehow? Maybe you created it wrong?

edited Jan 26, 2018 at 17:42

answered Jan 25, 2018 at 23:39

Evert

101k18 gold badges136 silver badges221 bronze badges

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

6 Comments

sanjihan Over a year ago

Ahh, that was an error in my head, when I was typing the question. Sorry about that. I edited the question with query and the direct response from mySQL

Evert Over a year ago

Updated my answer

sanjihan Over a year ago

no, I am just using replacement for my table names. I've been doing sql for years. This is not a syntax error

Evert Over a year ago

I didn't mean syntax error. The extra spacing in the table might indicate that there's a weird unicode character in the name

Evert Over a year ago

Did you manually change database names by moving files? Or did you migrate to a new server?

|

Collectives™ on Stack Overflow

mySQL error: Table 'table' doesn't exist in engine

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related