Manage and administer MySQL database in an intuitive way.
SQLyog MySQL GUI is the most powerful MySQL manager and admin tool, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and various other MySQL Front Ends and MySQL clients in a single intuitive interface.
Visual Tools Visual Schema Designer Visual Query Builder Migration Tools Wizard Driven Migration Toolkit Import tasks can be scheduled Synchronization Tools Schema Synchronization Data Synchronization Data Synchronization can be scheduled Other Power Tools Scheduled Backups Notification Services Job Manager Licensing Perpetual Licensing Company wide Unlimited licensing at very attractive prices 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 Table duplication with two clicks Enhanced Productivity Smart Autocomplete Intelligent Code Completion Advanced Connectivity Options HTTP/HTTPs Tunneling SSH Tunneling SSL Connections Internationalization 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 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
New Features: * Added an option to use Base64 encoding for communicating XML data stream with the HTTP tunneller. Using this option can be required to work around this XML-related bug in PHP. * Improved editor performance with large scripts if Wordwrap was enabled.
Bug fixes: * On Windows Vista Business edition, SQLyog could crash while closing down. No other Windows OS (and also not any other Vista edition) was affected. * Also a ‘hang™ could occur when closing down. It could happen with all systems, but Windows Vista was mostly affected. * Schema Sync failed with identically named Foreign Key CONSTRAINTs on identically named colums of basically same type (that could still differ in LENGTH, SIGNED/UNSIGNED specification etc.)
Miscellaneous: * When a PK is built on a string column using a case insensitive collation, SJA could try to insert a row where the PK was identical to an existing one as compared “COLLATION-wise” (ie. when only LETTERCASE differed). That would result in ‘duplicate key™ error and the sync job would abort. We have now reverted back to case insensitive camparison with string-based PK™s as before 7.0, but (to avoid data loss/overwriting) we will abort sync of tables when a string-based PK uses a binary or case sensitive collation.
Changelog for this release:
Features: * A Korean translation is now included.
Miscellaneous: * The localization tools have been updated. The compiler for building localizations is now up to 100 times faster than before. Also the XML has now been properly versioned. Refer this blog on how to download the localization kit.
RoSoftDownload.com team has tested SQLyog against viruses, spyware, adware, trojan, backdoors and was found to be 100% clean of any form of malware.. Our editors will test this application periodically to assure that it remains clean.
Click the link below to view the entire antivirus report.