[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.

[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]

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.

[Author]

Posts