Cannot See Tables And Views

[gobi]

Not sure if I am doing something wrong or if this is a bug.

I recently upgraded my database to MySQL v5.0.15. As such, I wish to use a gui that supports this version. I downloaded SQLyog free version 5 but cannot see any of my tables and views. Yet, I am able to see all my tables and views using another gui such as Navicat 7.0.8 or a previous version of SQLyog. When I click on View, I get a dialog popping up saying:

Error No. 1018

Can't read dir of './test/' (errno: 13)

[Ritesh]

The error means that the underlying table is corrupted.

If you check the views from other GUIs you will get the same error.

[gobi]

Ritesh wrote on Nov 7 2005, 02:37 PM:

The error means that the underlying table is corrupted.

If you check the views from other GUIs you will get the same error.

[post=”7839″]<{POST_SNAPBACK}>[/post]

Actually, no, I don't. I am trying NaviCat v7.0.8 and it is working fine. I can see my all my tables and views.

[Ritesh]

I am not sure about Navicat but we execute the following query to get the VIEW info:

Code:

select `TABLE_NAME` from `INFORMATION_SCHEMA`.`VIEWS` where `TABLE_SCHEMA` = 'yourdb'

Do you get an error while executing the above query?

[gobi]

Ritesh wrote on Nov 7 2005, 02:50 PM:

I am not sure about Navicat but we execute the following query to get the VIEW info:

Code:

select `TABLE_NAME` from `INFORMATION_SCHEMA`.`VIEWS` where `TABLE_SCHEMA` = 'yourdb'

Do you get an error while executing the above query?

[post=”7841″]<{POST_SNAPBACK}>[/post]

I tried your statement using mysql (client, not the gui) and I get the same error:

Can't read dir of './test/' (errno: 13)

However, I can execute “connect mydb” and Select from my views. Do you know what is causing this error?

[gobi]

I did a google on errno 13 and discovered that it is a permission error on the db, 'test'. Since this is just a dummy db, I removed it and I can now see all my tables and views. Thanks for your help.

[peterlaursen]

@gobi

could you possibly find that link again?

It could be of interest for our FAQ!

[Author]

Posts