Can't Read Dir Of './lost+found/' (errno: 13)

[Wes Robinson]

I use SQLyog Enterprise 5.18 to work with a database stored on a MySQL server I do not control. The server was recently upgraded to MySQL 5.0.22. Since the upgrade, SQLyog no longer shows my tables and views. I receive the error message “Can't read dir of './lost+found/' (errno: 13)” if I try to list my views. If I execute this query:

select `TABLE_NAME` from `INFORMATION_SCHEMA`.`VIEWS`; where `TABLE_SCHEMA` = 'wrobinso';

I receive this error:

Error Code : 1018

Can't read dir of './lost+found/' (errno: 13)

(391 ms taken)

When I use the MySQL query browser, I am able to see the list of my tables.

With SQLyog, I can run queries against my database and edit the results, without any problem.

Is there something I can change in SQLyog, or do I need to get in touch with the group in charge of this MySQL server? If so, what should I tell them (it's Purdue University's MySQL server)

[peterlaursen]

Looks like same thing as here:

http://www.webyog.com/forums//index.php?sh…amp;#entry10966

This query:

select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'your database' and `TABLE_TYPE` = 'BASE TABLE'

is what SQLyog sends to 'fill out' the Object Browser with tables. I think it does not return anything either?

(replace 'BASE TABLE' with 'VIEW' and you have what is needed to show Views).

You should absolutely not need to read the Ex2fs/Ext3fs 'Lost+found' folder! This folder is used only by a file system utility (similar to 'checkdsk' on Windows) to recover files that have been lost.

I think you should tell the sysadmin the examples of queries that you should be able to get result from and te error messages that you get.

[Wes Robinson]

OK, cool, the sysadmin was able to fix it. Just out of curiosity, why does SQLyog query the Information_Schema instead of doing SHOW FULL TABLES?

[peterlaursen]

We started querying I_S with SQLyog ver. 5 when we introduced support for VIEWS,

.. WHERE .. `TABLE_TYPE` = 'BASE TABLE'

and

.. WHERE … `TABLE_TYPE` = 'VIEW'

lists the TABLES AND VIEWS respectively.

[Author]

Posts