

To save the current session, select either Save Session… or Save Session As… from the File menu. Session Savepoint commands in the File menu

It’s accessible by selecting Tools > Preferences from the main menu. However, you can turn off this behavior from the Others tab of the main Preferences dialog. In fact, SQLyog will always restore your previous session on startup by default. With the Session Restore feature, restore your previous session along with all the query tabs, query builder tabs, schema designer tabs and the history tab just the way they were prior to the crash. Have you ever experienced the frustration of your system crashing, or accidentally closing your database administration application and losing all your unsaved tabs and queries? If you’re using SQLyog, you can breathe a sigh of relief we’ve got you covered! Throughout the remainder of this blog, we’ll explore how SQLyog helps boost your productivity via some of its unique and value-adding features. It not only delivers more robust operation, but also comes with a variety of useful features that help you get the most out of your DBA tasks. Frustration has led DBAs to the far superior paid solutions such as SQLyog. As such, many users have reported that MySQL Workbench hangs or fails to respond. Although it’s far more visually appealing than the command line interface, performance is less than stellar when under a high workload. With respect to MySQL, it offers the free MySQL Workbench. Why Use a Database Administration Toolĭatabase administration tools provide a GUI/Web interface to automate database tasks like querying tables, find and replace operations, and any other task that you might want to run on a database. This makes it possible to specify and test ‘scheduled jobs’ on a Windows environment and port execution parameters seamlessly to a Linux environment. Moreover, a subset of SQLyog Enterprise/Ultimate functionalities are available with the free SQLyog Job Agent (SJA) for Linux as a native Linux utility. It will also work under Linux, Unix and Mac OS X using the Wine environment. SQLyog is available for the Windows operating system starting from Windows XP/Windows 2003 to Windows 8/Server 2008 R2.


SQLyog is a professional-grade GUI tool for the MySQL RDBMS.
