SQLyog MySQL GUI 11.21 Released

Changes (as compared to 11.2) include:

* The interface for restoring connections from previous session introduced in 11.2 has been changed due to user requests. There is now no popup dialog at startup, but instead a setting in tools .. preferences .. ‘others’ tab.

Bug fixes:
* Fixed a rare crash in HTTP-tunnel typically happening when copying huge databases or tables. Exact details of this crash would depend on the environment.
* LOAD DATA LOCAL would hang indefinitely if a non-existing file was specified as argument. This bug was introduced in version 11.2.
* In Schema Sync a comma could be missing before a COLLATE clause thus resulting in an invalid SQL statement.
* A very large .zip archive generated by Scheduled Backup could fail to open due to a checksum error.

* MySQL 3.23 and 4.0 servers are no longer supported and a connection attempt to such will be denied..

Downloads: https://www.webyog.com/product/downloads
Purchase: https://www.webyog.com/shop


Add yours
  1. 1
    Martin Francis

    Many thanks, good changes here.
    I do think that the ability to remember connections is a good idea, but I agree that it’s not for everyone.
    This said, ability to preset a ‘profile’ that opens a group in one shot would be need – sometimes I develop on a single machine, that needs one connection, sometimes I deploy to multiple machines, that would need several open at once.

    1) One feature I would love to see is the ability to save settings for ‘Filter Databases’ per connection, so that when I open a connection I can show only those which match the filter automatically.

    2) Also, could the filters be extended so we could use multiple ‘or’ type clauses like this:
    ecc_media, ecc_visits

    You could use spaces, commas or semicolons to separate names since no names in MySQL can contain these characters anyway so there’d be no conflict.

    3) Simple * wildcards would be another great addition:
    *_media, *_visits, *_stats_country*

    Anyway, keep up the great work, you product is a real blessing to me.

    Martin Francis

  2. 2

    Martin – this “You could use spaces, commas or semicolons to separate names since no names in MySQL can contain these characters anyway so there’d be no conflict.” is not true. Since MySQL 5.1 identifiers are fully unicode (as specified by the SQL standard). ANY character can be used. Only the NULL character cannot be used in an identifier. Refer http://dev.mysql.com/doc/refman/5.1/en/identifiers.html “Permitted characters in quoted identifiers include the full Unicode Basic Multilingual Plane (BMP), except U+0000:”

    If filters are not available after a ‘session restore’ it surprises me. Are you sure? Anyway, we will check!

    • 3
      Martin Francis

      Hi Peter,

      You are right of course – provided that you enclose a string in backticks (or quotes if that feature is enabled), then yes, you can of course use any of the characters I suggested.

      However, you do already provide an option for ‘Database(s)’ filtering in the ‘Connect to MySQL Host’ dialog, and this accepts a semi-column ‘;’ (also on that prohibited list) as a separator ad this allows multiple values to be matched at once.

      My suggestion is that that your newer and more flexible ‘Filter Databases’ feature might be brought in line with that to allow a range of clauses to be matched, and that while you are at it you might also allow some form of pattern matching on the ‘Database(s)’ filtering in the Connection dialog, even if its just the ‘starts with…’ type of clause your ‘Filter Databases’ feature currently provides.

      Right now, every time I connect to seven different hosts to push up SQL build files to the application I maintain, I have to manually enter a filter criteria to hide several dozen irrelevant databases before I start my build deployment. This happens several times a week and over weeks and months all that time begins to add up. It would be great if I could open a connection with that soft-filter already in place (but which can be overridden if needed), and better still if it could be made to handle multiple clauses or even wild-card matches to further refine the displayed resources.

      Oh and by the way, if I set a filter in the ‘filter databases’ then disconnect, that filter is NOT set for me if the ‘restore connections’ feature kicks in and remakes the connection next time I start the program.
      Anyway, I think the proper place to stare that setting is with the connection itself anyway.

      Well, thanks again, your product helps keeps me in business, so you have my heartfelt thanks for all your efforts in this.


      Martin Francis

+ Leave a Comment