Webyog SQLYog Enterprise v6.16 Final

Один из лучших менеджеров для MySQL - это SQLyog. В SQLyog Enterprise есть такая возможность, как HTTP Tunneling. Это означает, что если, ваш хостер ограничивает доступ к БД извне, т.е. соединяться с MySQL могут только локальные скрипты, то Вам придётся управлять базой при помощи phpMyAdmin, что не очень-то удобно. HTTP Tunneling обеспечивает интерфейс через специальный PHP-скрипт к локальной базе хостера для управления с помощью SQLyog!




Webyog SQLyog 6 with HTTP/ HTTPS/ SSH Tunneling is a easy to use, compact and very fast graphical tool to manage your MySQL database anywhere in the world. SQLyog was developed keep in mind the necessities of all who use MySQL as their preferred RDBMS. Whether you enjoy the control of handwritten SQL or prefer to work in a visual environment, SQLyog makes it easy for you get started and provides you with tools to enhance your MySQL experience.

Возможности программы:
- поддержка баз MySQL 4.1.x и выше,
- HTTP и SSH туннелирование в случае блокировки стандартного порта для доступа к базе,
- поддержка ODBC импорта/экспорта данных,
- утилита синхронизации данных между базами,
- создание бекапа баз по расписанию,
- оповещение о событиях по email,
- всевозможные операции над базами (создание, редактирование, удаление, очистка, копирование...)
- копирование БД на другой хост
- экспорт схемы БД в HTML
- CSV экспорт/импорт
------
- просмотр содержимого таблиц
- просмотр объекта таблицы
- управление привелегиями пользователей
------
- подсветка синтаксиса SQL
- автодополнение кода
- BLOB просмотрщик
- поддержка hotkeys
------
- SQLyog работает под Wine/LINUX

Отичительной особенностью этой программы является возможность работы через некий шлюз. т.е. SQLyog Enterprise может коннектится не только напрямую к базе (что иногда прикрывается доблестными админами хостера), но и используя несколько файликов, заранее заброшенных вами на свой сайт, иммитируя, таким образом, обращение самого сайта к базе MySQL.


Enhanced Connectivity Options:
- HTTP/HTTPs Tunneling
- SSH Tunneling

Migration Tools:
- Wizard Driven Migration Toolkit
- Import task can be scheduled for transferring data at regular intervals

Synchronization Tools:
- Structure Synchronization
- Checksum based Network Efficient Data Synchronization
- Data Synchronization can be scheduled

Other Power Tools:
- Scheduled Backups
- Notification Services
- Job Manager

Developer / User Productivity:
- HTML Schema Documentation
- Shortcuts to quickly generate SQL statements and paste object names
- Learn MySQL by looking at the SQL generated by SQLyog
- Multi-tab Query Editor and Result-set Editor
- Multiple Query Execution
- Multi-threaded Query execution with option 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
- 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
- Dialogless 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
- Profiling
- 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

Features of SQLyog version 6.0:
* SQLyog is now fully UNICODE-compliant.
* Advanced GUI Query Builder.
* Filtering of data from the context menu of a cell in the GRID of DATA tab.
* Sorting on multiple columns in DATA tab

Changes in v6.16:
Features.
* SJA SMTP (mail) code will now use ESMTP if available and fall back on ('ordinary') SMTP if not (before only ESMTP was supported what failed with some specific routers).
* Added an option to specify CHARSET parameter for CSV-import. Unicode (UTF8 and UCS2/UTF16) will be detected automatically. For files encoded with a non-unicode encoding, user must select the MySQL charset used for the import. Alternatively there is a option that will not use the CHARSET parameter at all (= old program behaviour).

Bug fixes:
* The HTTP-tunneller was updated to 'work around' an issue with 'foreach' loops on PHP 4.3.10. HTTP-tunnelling to a server with that specific PHP version could cause a program crash.
* The uninstaller would not remove Start Menu shortcuts on Windows Vista.
* If SSH tunnel was used for both connections in DATA SYNC the plink process for the connection was not getting terminated properly.
* Display in the CREATE/ALTER TABLE grid would be truncated if an ENUM or SET type was defined with a value containing the ")" character.
* A crash could occur when backing up (using 'export' as well as 'scheduled backup') an object having a DEFINER different than the current user. This further depends on the MySQL version and whether user had SELECT privilege to the`mysql`database or not. Now a message will appear (on the screen or in the sja.log file) that this object was skipped due to lack of privileges when it is not possible to back up.
* When exporting to HTML, XML or CSV -formats from the RESULT tab one row could be missing if the RESULT tab dropdown was in edit-mode. EXCEL and SQL formats were not affected.
* When data were inserted or updated from RESULT tab, SQL and EXCEL export options would not export the new/changed rows unless after a reconnnect.
* When connected to MySQL 3.x and 4.0 the ALTER TABLE GUI would generate invalid SQL if existing column(s) were edited and new column(s) added in one operation (a comma was missing).
* Assigning privileges (from 'manage permissions) for a specific user to a specific Stored Function and Stored Procedure was buggy (wrong string identifying the ROUTINE type was inserted). Also a problem with VIEW-related privileges was fixed.
* A jobfile for 'scheduled backup' created with versions 6.x before 6.1 contains a tag (with the values "yes" or "no") that indicates if the backup shall be utf8-encoded. This tag was not properly ignored as it should from version 6.1 - instead it could occur that a non-existing charset (named 'yes' or 'no' respectively) was requested from the server. That would return an error that would cause the job to abort.
* Data Sync would not identify that rows containing data like ('data',NULL) and (NULL,'data') are different, as NULL-values did not 'contribute' to the checksums calculated. No update would take place.
* The fix in Data Sync for BIGINT Primary Keys containing very large numbers in 6.11 was not complete. Internal data could be truncated what again could result in wrong identification of rows to be inserted, updated or deleted.
* Certain queries (when performing GRID operations) were not 'piped through' the reconnection wrapper module. This could with low 'wait_timeout' server setting result in the 'server has gone away' error message if affected operations were executed with longer intervals between.
* Structure Sync failed to sync a specified index length.


Home Page: http://www.webyog.com/en/index.php

Size: 9.72 mb

Спасибо сказали:
BusK