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:

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

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

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

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

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

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.

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

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!

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

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

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

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

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.

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

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

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

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

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

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

“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

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.

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.

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.

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

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.

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

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

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

Changes (as compared to 8.22) include:

Features:
* Added an option to define a ‘color code’ for a connection. The color will be used as background color in the Object Browser.
* A Query Builder session can now be saved and resumed.
* In Query Builder a table alias can be defined for any table by double-clicking the title bar of the table symbol.
* In RESULT tab results can now be retrieved page-wise. This is ON as default with this build with a defined LIMIT of 1000 rows. For a specific query user can change and for this specific query the setting is persistent across sessions. Also read ‘miscellaneous’ paragraph below.
* Added a context menu to Query Builder canvas.

Bug Fixes:
* Deleting a user would leave non-global privileges orphaned in the ‘mysql’