Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 53 Next 23 Older Entries

Displaying posts with tag: SQLyog (reset)

SQLyog – Introducing Session Restore
+0 Vote Up -0Vote Down

Ever had this nightmare of your system crashing, or you accidentally closing SQLyog and losing all your open tabs and queries? Don’t worry, we have you covered!

Introducing Session Restore. You can now restore your previous session along with all queries and history tab the way you left it. Here’s a quick video:

Session Restore is available for all SQLyog users. Existing customers can download the latest build from Customer Portal. To evaluate SQLyog, please download a 30-day trial.

We are very excited about this release, and hope that you will like it.

  [Read more...]
Speed up your database navigation with SQLyog
+0 Vote Up -0Vote Down

While coding, every second counts. And when the complexity of the database increases, you need to find new ways of speeding up your coding workflow. Let us admit it, we developers prefer to get all our work done using keyboard shortcuts, without having to switch to the mouse.

To streamline your entire coding experience and to speed up database navigation, here are a couple of useful keyboard shortcuts to make the most out of object browser filter in SQLyog.

Keyboard shortcuts:

  • Ctrl + B – sets focus on object browser for operations related to Object Browser.
  • Ctrl + [Up arrow] – brings focus to server/top-most
  •   [Read more...]
    SQLyog 11 GA – your favorite MySQL GUI in 64 bit avatar
    +0 Vote Up -0Vote Down

    Hi,

    64 bit SQLyog is here. It’s no secret that you can make the most out of your PC only when you have the right combination of software, operating system and hardware. You can now take full advantage of your 64 bit environment for your MySQL needs. We are proud to offer the first 64 bit GUI client for Windows.

    Additionally, if you are using 64 bit Microsoft Office 2013, SQLyog 11 will work out of the box with the 64 bit drivers shipped with it. Importing from Access, Excel or Text/CSV has never been easier.

    Please refer the

      [Read more...]
    Visually compare MySQL data and sync the differences
    +1 Vote Up -0Vote Down

    You had requested for a visual tool to compare two instances of a table to spot differences. We heard that. We are delighted to introduce Visual Data Compare (VDC) in SQLyog 10.5. It lets you do exactly that, and more. VDC allows you to compare two tables right next to each other making it easier to spot differences. It is a lot simpler than manually figuring it out all by yourselves.

    VDC also doubles as an additional option for data sync. With VDC you will be able to compare differences visually and specify tables and rows that shall be synced as well as to decide in what direction to sync. It comes very handy when you want to copy lookup data from

      [Read more...]
    How to Personalize your SQLyog Theme
    +2 Vote Up -0Vote Down

    Fascinated by colors? Colors play a pivotal role in all our visual experiences because of its vibrational energy. Consciously or subconsciously we have a visual perception of how a perfect UI should be. This color theory has been applied by designers to create visually appealing modern user interfaces and contributing to the overall user experience. Having said that, color perception changes from one individual to another, some of us prefer subtle colors and few others like to spice it up a bit, and sometimes change can be good.

    We’ve had users requesting for tweaks in our default SQLyog theme, and we had added

      [Read more...]
    SQLyog 10.4 improves usability with tens of thousands of databases or tables.
    +2 Vote Up -0Vote Down

    We have released SQLyog MySQL GUI 10.4. The 2 major new features are:

    * Autocomplete speed/performance is drastically increased. This is the 3rd time we do this actually since autocomplete was introduced in SQLyog 5+ years ago. Our autocomplete implementation is one of the highest appreciated features of SQLyog according to a survey we did among registered users recently. However some slugginess could occur with a very large number (tens of thousands) databases on the server or a similar number of  tables or other objects in a database. Also a number of small bugs in autocomplete were

      [Read more...]
    Think beyond phpMyAdmin to access MySQL on a shared host
    +5 Vote Up -0Vote Down

    So, do you really need phpMyAdmin to access MySQL database on a shared hosting?

    NO, you don’t need it, but popular hosting services like GoDaddy integrate phpMyAdmin to facilitate access to MySQL server. Of course phpMyAdmin is a nice tool, no offense, but what if you prefer a desktop application over phpMyAdmin, or you are a developer working on an application that needs to access the MySQL database on a shared hosting? That desktop application I’m referring to is SQLyog. So how does

      [Read more...]
    All you wanted to know about SQLyog’s Schema Comparison tool
    +3 Vote Up -0Vote Down


    Developers and DBAs often compare and synchronize structures of their database objects (Tables, Views, Triggers, Functions, Events and Stored Procedures) from Development server to Production server and vice-versa. One can use a schema comparison / synchronization tool to synchronize database (DB) objects.

    SQLyog’s Schema synchronization tool is simple and intuitive to use for comparing and synchronizing database objects. It comes with new looks and a Filter feature. Database objects’ comparison is now 100x faster.


      [Read more...]
    So, how do you sync your database schema?
    +8 Vote Up -0Vote Down

    It is almost an everyday task for developers to ensure the schema are in sync in their test/development/production databases. No doubt that everyone who works with MySQL servers will encounter situations where schema should be synchronized. When this happens, there must be a reliable solution where it should work in any complex situation.

    Challenge:

    You have made numerous MySQL schema changes to your databases during development of a new feature. Now you want to sync development and production schemas so that they match when you

      [Read more...]
    Quick Manual to SQLyog
    +2 Vote Up -1Vote Down

    One of our users has published a “Quick Manual to SQLyog” to his blog.

    Sometimes you do better writing about a subject as an ‘outsider’ than as an ‘insider’.  As an ‘insider’ you easily take things for granted that are actually not obvious for everyone.  This is a good example of this – and the writing is excellent. Enjoy!

    Tweet
    MySQL Windows installer mess.
    +7 Vote Up -3Vote Down

    It now seems impossible to maintain different ‘major’ MySQL servers on the same Windows machine using automated installers.  Refer: http://bugs.mysql.com/bug.php?id=66395 and http://bugs.mysql.com/bug.php?id=66396 . This is an unnecesssary (and stupid) limitation/regression.  Windows perfectly handles multiple MySQL versions at a time without use of Unix utilities like ‘mysql-multi’ or ‘mysql sandbox’, if only basedir, datadir, port and service names are distinct. Unix-people in MySQL organization (no matter the changing ownerships) never seem never to have understood this (I have had discussions with various MySQL people over the last 5-6 years about same and

      [Read more...]
    SQLyog MySQL GUI 10.2 Released
    +1 Vote Up -0Vote Down

    Changes (as compared to 10.12) include:

    Features:
    * Saved connections can now be exported and imported. The option is available in the ‘tools’ menu.
    * Added an option to open exported CSV and Excel XML files directly with the program associated with the file extension on the system.

    Bug fixes:
    * Exporting Schema Designer canvas as image on Wine generated empty boxes for tables with no information about columns. It is actually a bug in Wine (incomplete Windows API implementation for drawing routines) .
    * The height of GRID-cells will now adjust to fit font setting for the GRID .

    Downloads: http://webyog.com/en/downloads.php
    Purchase: http://webyog.com/en/buy.php

    Tweet
    SQLyog MySQL GUI 10.1 Released
    +0 Vote Up -0Vote Down

    Changes (as compared to 10.0) include:

    Features:
    * It is now optional whether DATA, INFO and HISTORY tabs shall display in ‘upper pane’ (as in 10.0) or in ‘lower pane’ (as before 10.0). The setting is available in tools .. preferences .. general. Note that for DATA tab this applies to the ‘non-sticky’/non-persistent DATA tab. A ‘sticky’/persistent DATA tab will always display in ‘upper pane’.
    * DATA, INFO and HISTORY tabs appearance will now be persistent across sessions when configured to display in upper pane. If visible when program was closed they will open when program starts next time – if hidden when program was closed they will not. When configured to display in lower pane they will always be visible.
    * The checkbox to ‘select all’ as added in DATA and RESULT tab in 10.0 is now


      [Read more...]
    Celebrating 10 years with MySQL – releasing SQLyog 10.0 GA
    +5 Vote Up -0Vote Down

    Hello,

    We are delighted to announce the release of SQLyog 10.0. The version number makes this release very special. We must say the journey from SQLyog 1.0 to 10.0 was very exciting and rewarding. SQLyog was first released in 2002 as a MySQL GUI. Now we are a decade away from the first release. During the course of time, we have introduced tons of features taking SQLyog beyond the definition of a GUI. We couldn’t have done it without your encouragement and patronage. A big thank you for being with us in this endeavour.

    Listed below are the features and

      [Read more...]
    SQLyog MySQL GUI 9.62 Released – Now with Korean UI
    +0 Vote Up -0Vote Down

    Changes (as compared to 9.61) include:

    Features:
    * A Korean translation is now included.

    Miscellaneous:
    * The localization tools have been updated. The compiler for building localizations is now up to 100 times faster than before. Also the XML has now been properly versioned. Refer this blog on how to download the localization kit.



      [Read more...]
    SQLyog 9.61 Released – Now with Option for Chinese Interface
    +1 Vote Up -0Vote Down

    Changes (as compared to 9.6) include:

    Features:
    * A Chinese (Simplified) translation is now included.

    Bug fixes:
    * When there was an INFO tab open the server was unnecessarily queried for the content of the INFO tab (based on Object Browser selection) when closing the program. This could cause a slow shutdown.
    * Fixed a crash occurring when pressing the ESC key in the CREATE/ALTER tab/dialog. This bug was introduced in 9.6.

    Downloads: http://webyog.com/en/downloads.php
    Purchase: http://webyog.com/en/buy.php

    Tweet
    SQLyog MySQL GUI 9.6 Released
    +1 Vote Up -0Vote Down

    Changes (as compared to 9.51) include:

    Features:
    * When performing CREATE/ALTER TABLE operation from inside the Schema Designer now a dialog with a tabbed interface similar to the CREATE/ALTER TABLE tab will open.
    * It is now optional if Query Builder will create statements with ‘fully qualified tablenames’ or not.
    * Implemented Alt+Ins, Alt+Del, Alt+Up and Alt+Down for inserting, deleting, moving up/down the rows in CREATE|ALTER TABLE interface when the focus is on respective grids. The tooltip for the toolbar buttons will now show this shortcuts.

    Bug fixes:
    * In Data Sync a low setting of ’max_allowed_packet’ on source server could result in CONCAT_WS() used for checksums’ calculation returning NULL . We did not consider this and as a consequence rows could fail to sync without




      [Read more...]
    SQLyog Query Profiler re-invented.
    +4 Vote Up -0Vote Down

    Baron Schwartz from Percona has  just re-invented the SQLyog Query Profiler.
    Refer: http://www.mysqlperformanceblog.com/2012/02/20/how-to-convert-show-profiles-into-a-real-profile/

    The SQLyog Query Profiler was introduced in SQLyog 8.o in February 2009 – exactly 3 years ago. The funny thing is actually that Baron Schwartz reviewed it before release (at friendly commercial terms) at the time. The SUM-aggregation and the ORDERING that we did (and it was solely our decision – not Baron’s advice) in SQLyog 8.0 to the result from SELECT FROM I_S.PROFILES is the same as Baron now announces as “something I developed”.

    Well ..

    1) First let me make it clear that I am not complaing.  I believe Baron when he tells that


      [Read more...]
    Creating tables now faster and easier with SQLyog 9.5
    +0 Vote Up -0Vote Down

    Hello!

    We are delighted to announce the release of SQLyog 9.5 GA. This release is geared towards enhancing the user experience.

    The major changes are:

    • The conversion of modal dialogue boxes to a tabbed interface for creating and altering tables, and defining table properties.
      • Creating a table involves – defining columns, and often, creating indexes and foreign keys. Before, these actions had to be done one after the other, which was annoyingly slow. Now, you can define columns, and create indexes and foreign keys – all in a single interface, which gives you a single CREATE/ALTER TABLE query to execute. Not only is creating tables easier, it is also much faster!
      • Modal dialogue boxes limit one from multitasking. Previously, when in the middle of creating a foreign key, if some information had to be
      [Read more...]
    Debugging stored programs in MySQL?
    +2 Vote Up -0Vote Down

    The headline above has two parts: 1) some letters 2) a question mark. The question mark is the important thing here! It resolves to:

    * Can we debug stored programs in MySQL?
    * Do you debug stored programs in MySQL?
    * How do you debug stored programs in MySQL?

    We have tried, but we gave up! In the early stages of our IssueBurner application we actually used Stored Procedures quite a lot. As the complexity increased debugging became so tedious that we recoded the application ‘the traditional way’ coding the logic in the application code instead.

    In simple cases you may of course add a little debugging code that writes some data to user variables, temporary tables etc. Next remove them or comment them



      [Read more...]
    How to localize SQLyog.
    +0 Vote Up -0Vote Down

    Please note: This Blog was updated with a few clarifications on October 21st 2011.

    As we announced in the release Blog for SQLyog version 9.3 we here publish instructions and tools for localizing SQLyog.

    To understand how localization works you should first open the SQLyog 9.3 installation folder on your system. Inside it there is a (SQLite) database file named “L10n.db”. It contains all strings in all localizations distributed by us (currently English and Japanese) displayed by SQLyog GUI. If you have selected to run SQLyog in a non-English language SQLyog will load the localized strings from this file and use them for display and not the English strings.  To enable more languages just

      [Read more...]
    SQLyog is now available in Japanese
    +0 Vote Up -0Vote Down

    “Publishing software in English will make you reach most of the global audience” is a myth. Users like software in their own language. For Non-English speaking audience localized software is a necessity. We heard it. SQLyog is now available in Japanese & will be made available in other international languages soon. We are using crowd-sourced human translation services from myGengo for translating SQLyog. I’d also like to add that our website is machine translated using Google Translate.

    Embedded below are some related screenshots:

    Option to change language

      [Read more...]
    MySQL Data Search enhanced in SQLyog 9.2
    +0 Vote Up -0Vote Down

    We have released SQLyog 9.2 GA with enhancements to the Data Search feature (and more).

    Since we introduced the Data Search feature in SQLyog 9.1 we had a lot of positive responses – but also a few critical remarks that using the feature could cause unnecessary server load as well as unnecessarily long response times. Such scenario could arise when searching for a string in a BLOB column used for storing media files for instance. Or when searching all tables of a database when there was only need to search a few tables.

    We have addressed this concern by adding filter options that let the user restrict the search to specific data types and to a subset of databases of a server, a subset of tables of a database or a subset of columns of a table.

      [Read more...]
    MySQL Data Search – data at your finger tips!
    +11 Vote Up -1Vote Down

    I don’t need to emphasize how productive you can be if you find what you are looking for in a quick and easy way. Google has shown it to us. Wouldn’t it be fun to have the same ease and speed while searching for data in your databases? Well, that’s what Data Search is all about. Find the data you want without writing any queries or worrying about the underlying schema. Type in the search string and you’ll have a table of all search results waiting to be clicked and be taken to the exact cell of the table. It also supports search operators like AND, OR and “”. Note that the results of this search is not the same as WHERE clause query results. Its rather a natural way of search. Lets say its like googling your database. For better precision you can search with regular expressions too.

      [Read more...]
    SQLyog MySQL GUI 9.0 Released
    +0 Vote Up -0Vote Down

    This is the first GA release in a new major branch of the SQLyog MySQL GUI.

    This release introduces an easy way to look up proper values for values inserted to columns that have a Foreign Key CONSTRAINT.  Foreign Key CONSTRAINTs can be difficult to handle for a human user because when updating a ‘child’ table valid values for columns that have such CONSTRAINTs  in the  ‘child’ table will often be ‘just a code’ ( an autoincrement integer or some very ‘compressed’ and ‘symbolic’ values (like item numbers, order numbers etc.).

    This SQLyog release provides a direct way to look up in ‘parent’ what should be inserted in child. It works like this: In both GRID and FORM mode a ‘…’ symbol will display if the actual column has a Foreign key CONSTRAINT.

      [Read more...]
    SQLyog 8.8 introduces improved performance, SQL_mode support and more.
    +0 Vote Up -0Vote Down

    We are pleased to announce a new and improved GA version of SQLyog MySQL GUI. The highlights of this  release (8.8) are:

    * Drastically improved memory management in DATA and RESULT tabs. This allows for larger result sets in memory and significantly improves scrolling with large result sets.

    * Added a sql_mode setting for connections. There is an option to let the GLOBAL mode apply for the session as well as to specify a sql_mode for the connections. The setting is stored on a per-connection basis. Sometimes the GLOBAL sql_mode setting on server is not the best option for a GUI tool and sometimes you may want to take special precautions by setting a specific sql_mode different from the GLOBAL mode.

    * With HTTP-tunneled connections to MySQL connection through

      [Read more...]
    SQLyog MySQL GUI 8.7 Released – Form View, improved SQL Formatter and more
    +0 Vote Up -1Vote Down

    We are pleased to announce this new major release of SQLyog MySQL GUI.

    The major enhancements with this release are:

    * Information in tabbed interface can be reordered.
    Just like you will find it in all modern browsers, TABs can now be reordered using drag’n’drop in the GUI. The option is available for connection tabs as well as Query/Query Builder/Schema Designer tabs.

    * Fast and convenient data entry from the keyboard.
    We have added ‘FORM view’ option (in addition to ‘GRID view’ and ‘TEXT view’ already available) for managing data in DATA and RESULT tabs. ‘FORM view’ will display one row at a time and is in particular convenient when entering data from the keyboard.



      [Read more...]
    SQLyog – MySQL GUI 8.6 GA – new features, improved performance and stability.
    +1 Vote Up -1Vote Down

    We are pleased to announce the release of SQLyog – MySQL GUI 8.6 GA. This release adds functionalities requested by users for some time, and fixes a number of bugs. Most important enhancements:

    User management has been updated with a brand-new interface, has been completely rewritten and also now fully communicates with the MySQL server the recommended way using GRANT and REVOKE syntax. We believe that with this release we have provided the best available ever GUI for MySQL User Management.

    For users that prefer to work in a spreadsheet-like interface when filtering and sorting data the options to do this have been enhanced: There is now a ‘custom filter’ option to be used when filtering on a value that does not exist in the result set displayed

      [Read more...]
    SQLyog – MySQL GUI 8.5 GA | Brand new Tabbed Interface!
    +0 Vote Up -1Vote Down

    Hi,

    We are pleased to announce the release of SQLyog – MySQL GUI 8.5 GA. Below are some pointers:

    • As the title suggests this release comes with tabbed interface for different connections. We need not have to emphasize the usability of a tabbed interface vs. a windowed one. All web browsers have already demonstrated it to us. Now in SQLyog, you can switch between different connections in a snap! We didn’t forget to add keyboard shortcuts to jump from one tab to other. Most – if not all – shortcuts for tabs of a standard web browser would work with SQLyog. Multi-coloring of connection tabs & object browser pane adds to the ease of use. Chances of one executing queries in one server than the other by mistake would be rare as the brain would easily grasp the connection by it’s color. Demoed below is
      [Read more...]
    SQLyog – MySQL GUI 8.4 GA | Redundant Index Finder, Compressed Scheduled Backups & much more..
    +0 Vote Up -1Vote Down

    Hi,

    SQLyog 8.4 happens to be a fairly major release with good number of features & enhancements. Listed below are some worth noting.

    • May it be Query Profiler or Datatype Optimizer, SQLyog has grown beyond the definition of a GUI with these features with intelligence. One such feature that is being unveiled with this release is an option to find redundant indexes. You can find the redundant indexes in a Table with just a click of a button. If found, a ready query is generated to drop the redundant indexes. As you know eliminating redundant indexes improves INSERTs & UPDATEs and also saves hard-disk space.
    • Scheduled Backups can be compressed.
    • If you are one of those users who deal with databases having thousands of objects (tables, columns etc.) this release will definitely add to your productivity as auto-complete has been drastically
      [Read more...]
    Showing entries 1 to 30 of 53 Next 23 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.