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

Tables Not Listed In Object Browser Since Mysql Upgrade

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Tables Not Listed In Object Browser Since Mysql Upgrade

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • December 21, 2006 at 4:46 pm #10097
      Sarah
      Member

      Ever since my web host upgraded their version of MySQL (to version 5.1.11 beta – don't ask me why), my database tables no longer appear listed in the Object Browser. I emailed their support and was told to upgrade SQLYog to the latest version, but I've done that and it didn't help. Any suggestions?

      TIA

    • December 22, 2006 at 5:34 am #23129
      peterlaursen
      Participant

      We have had this issue a couple of times before.  It occurs because of a privilege issue (privileges to the `Information_Schema` table) on the server.  Basically ist is because of a mistake by Sysadmins when upgrading MySQL.

      SQLyog sends the query:

      Code:
      select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = '***' and `TABLE_TYPE` = 'BASE TABLE'

      What happens if you write that query yourself? You SHOULD be able to get result from the objects that are yours!!

      However also read this:

      http://www.webyog.com/forums//index.php?sh…view=getnewpost

      .. from next release we we not query information schema when there are other ways to get the information.

    • December 22, 2006 at 2:54 pm #23130
      peterlaursen
      Participant

      SQLyog 5.22 RC1 is now released.

       

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.