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 2 reply threads
  • Author
    Posts
    • September 4, 2006 at 7:40 am #9832
      Striton
      Member

      This is a pretty basic question but I'm somewhat confused. I'm connecting just fine to my database, but I am not getting a list of tables in the object browser. All I see are the Views, Stored Procs, and Functions tabs. In the help file it just keep saying to “select the table from the object browser” but there's nothing there. I'm using v5.18 on an fully patched XP pro machine connecting to a remote MySQL 5.0.22. Your help is appreciated.

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