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

Issues With Mysql 5.0

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Issues With Mysql 5.0

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • June 23, 2006 at 4:55 pm #9756
      cdecker
      Member

      I just recently upgraded to MySQL v5.0.20 and downloaded the most recent version of SQLYog. For some reason I can't see the tables. I'm assuming it has something to do with my upgrading of MySQL because I can connect to another MySQL 5.0 server without a problem.

      Has anyone else had a similar problem? If so, any luck fixing it?

      Thanks in advance

    • June 23, 2006 at 8:24 pm #21957
      peterlaursen
      Participant

      How did you upgrade? did you run the update scripts as the MySQL doducmentation describes it after the upgrade?

      When you click the + of a database SQLyog sends

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

      (bacause that is the way to distinguish betwenn tables and views)

      what hapens if you execute it as plain SQL? Looks like a defect information schema or a privilege issue.

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