SQLyog 7.11

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.

Main features:
- 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. Its 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)

Enhancements:
- 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.