SQLyog is an easy to use, compact and very fast graphical tool to manage your MySQL database anywhere in the world. SQLyog is a tool that allows you manage MySQL database.

Here are some key features of "SQLyog":

· MySQL 4.1.x compatible
· HTTP and SSH Tunneling - smartly manage your MySQL server even if the MySQL port is blocked or remote access to MySQL is disallowed!
· very fast retrieval of data
· ODBC Import with option to import data through query
· data synchronization tool
· powerful scheduled backup with email notifications
· schedule various jobs
· schema synchronization tool
· dialogless result editor with option to update multiple tables
· notification services
· multithreaded query execution with option to stop long running queries
· manage foreign key relationships
· fully InnoDB compliant
· view your results in GRID / TEXT mode
· fast client side sorting and filtering
· execute (very large) SQL-scripts as batch files
· execute multiple queries returning more than 1000s of rows per resultset. It's very efficient in memory
· very compact binary
· written entirely in C/C++/Win32 APIs using native MySQL C APIs. No wrapper classes used
· connection manager
· excel like grid interface to create/alter tables
· excel like grid interface to edit data with support for Enum/Set
· create/drop databases
· manage indexes
· comprehensive security manager. Control access to databases / tables / columns
· reorder columns of table
· copy database between two MySQL hosts
· drop all tables of a database with a single click
· edit BLOBs with Bitmap/GIF/JPEG-Support
· export table-structure and data into SQL-scripts
· export/import data in/from CSV files
· export database schema in HTML
· log all queries for a session
· profile queries
· syntax-highlighting
· save resultset in CSV, HTML and XML
· save your commonly used SQL scripts in a personal folder with a click of mouse
· is very keyboard friendly. You can work with 99% features of SQLyog with keyboard.
· view and kill other user-processes
· view advanced table-properties, such as Type, Comment, Key_Length and so on
· a list of server-variables e.g processlist, status, variables etc
· copy your result as CSV in clipboard
· copy tables to new table-names
· change table-types to ISAM, MYISAM, MERGE, HEAP, InnoDB, BDB
· flush Host/Logs/Privileges/Tables
· do table-diagnostics (check, optimize, repair, analyze)

What's New in This Release: [ read full changelog ]

· Program could crash when opening a migration jobfile containing a query
· Importing with the Migration Tool using a 'file-DSN' was broken since version 6.0. Various errors could result when trying to use such DSN. 'user-DSN' and 'system-DSN' worked as expected.
· The special PLINK build shipped with SQLyog ENTERPRISE failed to authenticate if there were spaces in the password/passphrase
· When connected to MySQL 3.23/4.0 there were problems when editing data in RESULT TAB with certain special characters . The fix for this in version 6.02 was not complete.
· Fixed an issue where SQLyog threw a 'meaningless' error message.