Pete Letkeman wrote:Have you looked into running any of the MySQL tools to repair tables and databases such as this tool
From the command prompt you could run:
mysqlcheck --all-databases --auto-repair
You will fine mysqlcheck in the MySQL\bin directory.
There is also a chance that you are have not used the use database command.
Assuming that the name of the database is test and that the name of the table is named test_table what are the results when you try this?
SELECT * FROM test_table;
Alternatively you could run this command:
SELECT * FROM test.test_table;
tangara goh wrote:When I run a query to show all the tables in my database.
It shows the table name.
when I run a select * from tablename, it gives me error 1146.
But, when I tried to insert some dummy data, it said it does not exists.
So, I tried to drop the table. But, it doesn't work either cos it gives me error :1051 unknown table.
Jeanne Boyarsky wrote:Tangara,
Try to look if the table is in a schema. If it was created under one user/schema and you are trying to access it using another, you'd need to write schema.test_table.
tangara goh wrote:C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqlcheck --all-databases --auto-repair
mysqlcheck: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using password: NO) when trying to connect
Liutauras Vilda wrote:Could you please support these statements with some copied/pasted snippets?