Unsupported Screen Size: The viewport size is too small for the theme to render properly.

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

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

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • September 5, 2006 at 12:10 am #22239
      peterlaursen
      Participant

      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.

    • September 8, 2006 at 5:27 pm #22240
      Wes Robinson
      Member

      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?

    • September 9, 2006 at 12:06 am #22241
      peterlaursen
      Participant

      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
Viewing 2 reply threads
  • You must be logged in to reply to this topic.