Recommended: Click here to scan your PC for issues causing speed loss!
SQLyog: Publisher´s Description
An easy to use, compact and very fast graphical tool to manage your MySQL database anywhere in the world 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. 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)
SQLyog: Screenshots
Have a look at some SQLyog screenshots which can help you learn more about the User Interface and operation.View more SQLyog screenshots.
Comments
SQLyog: Questions & Answers
Problems on using SQLyog? These are some of the most common questions about SQLyog. Ask your question to get free answers from expert or share you knowledge with others.
Here you can find good software with the same function which can replace SQLyog, We pick the best of the bunch from among Servers software. Browse software alternatives to SQLyog as the following list.
