SQLyog is an all-round Management Tool (/'GUI'/'Frontend') for the MySQL database. MySQL versions from 3.23 to 5.1.x are supported. SQLyog provides an efficient and intuitive User Interface for management of MySQL. It is at the same time an easy-to-use tool for beginners and an efficient timesaver for MySQL power users - Developers and DBA's as well.
SQLyog is a mature program that has been in existence for almost 5 years but now (Sept. 2006) released as Open Source under the GPL license. SQLyog 'development rate' is being continously accelerated. SQLyog runs on Windows and Wine (on Linux and other *nix variants where Wine is available). SQLyog has full support for MySQL 5.
Here are some key features of "SQLyog Community Edition":
· Nag Screen on startup displaying SQLyog Enterprise features
· Complete Unicode/UTF8 Support
· Developer / User Productivity
· Favorites Manager
· HTML Schema Documentation
· Shortcuts to generate SQL DML statements from schema definition
· Creating/Dropping/Altering tables
· Multi-tab Query Editor and Result-set Editor
· Multiple Query Execution
· Multi-threaded Query execution - Ability to stop long running queries
· SQL Templates
· Excel-style grid interface to view/update resultsets
· Multi-format Blob editor
· View data in Grid/Text Mode
· ResultSet/Data Export to CSV/XML/HTML/Excel
· Full Support from 3.23.38 to the latest 5.x
· Support for all MySQL table handlers
· Excel friendly resultsets/table-data export to clipboard/file
· Dialog-less table and resultset editor
· DBA Productivity
· Restoring / Importing large SQL dumps
· MySQL 5.x objects support
· User Management
· Managing hosted MySQL
· Connection Manager
· Index Management
· Relationship/Foreign Key Manager
· Reorder Columns
· Copy objects to another Host with single click
· Table diagnostics
· Flush Tools
· Object Browser
· Creating/dropping database
· Optimized for managing Hosted MySQL
· Multiple database connections
· Technology
· Turbo Speed MySQL Management. Uses native MySQL C API - the fastest way to communicate with MySQL server
· 100% keyboard friendly
· Small compact binary
· Minimal use of Registry - easy migration of User Preferences by dragging and dropping config files.
· Non-cluttered look and feel, ability to show/hide panes
What's New in This Release: [ read full changelog ]
Bug Fixes:
· When connected to a 5.0 server compiled without PROFILING option and with Query Profiler/SHOW PROFILE feature enabled SQLyog would still send PROFILING-related queries. It was not properly detected that the server did not support this. MySQL versions from 5.1 and up (also when compiled without PROFILING option) were not affected.
· In DATA and RESULT tabs/text mode unicode/non-ASCII characters could cause a change of the font that was used for displaying data. This was an old bug from when introducing full unicode support in 6.0.
· In RESULT tab BLOB/TEXT data would sometimes not display beginning of data in GRID. This bug was introduced in 8.15.
Miscellaneous:
· EXPLAIN EXTENDED option is now disabled as default in Query Profiler
