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

Table List

forums › forums › SQLyog › Using SQLyog › Table List

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 4, 2006 at 2:00 pm #22220
      peterlaursen
      Participant

      what does this SQL returns

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

      this is the query that SQLyog sends in order to distinguish between VIEWS and TABLES ('show tables' don't). If you cannot get such data when querying Information_Schema something is wrong with the server!

    • September 4, 2006 at 5:14 pm #22221
      Striton
      Member

      Thank you so much! The resulting error message took me right where the problem was. It turned out to be a permission problem with some obscure database I had manually backed up and never chown'd from root to mysql. Thanks again!

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.