CODEWITHSUNDEEP
mysql
sanjihan
sanjihan

Reputation: 5992

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

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         |

Upvotes: 1

Views: 4074

Answers (1)

Evert
Evert

Reputation: 99523

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?

Upvotes: 1

Related Questions