SQLyog Entersprise - MySQL GUI v6.56

SQLyog Migration Toolkit allows you to import data, table structure, indexes, foreign keys, constraints from any ODBC compliant data source like Oracle, SQL Server, Access, DB2, CSV, Excel, Sybase, etc into MySQL. The import session can be saved in a XML configuration file. This configuration can then be executed repeatedly using SQLyog Job Agent (SJA). You can also schedule the job at regular intervals.

Scheduled Data Sync – without MySQL replication

SQLyog Job Agent (SJA) is a high-performance, multithreaded, multi platform application to automate and schedule Synchronization of Data between two MySQL hosts.
SJA does not require any installation at hosts running the MySQL server. You can use any host to run the SJA. You can use SJA to keep your production databases (probably hosted with an ISP) in complete sync with your test database located in your PC or LAN.
SJA uses an efficient algorithm to generate checksums to find out the changes. Therefore, only those rows that have been inserted, updated or deleted since the last sync are transferred between the hosts.
You can configure SJA for One Way or Two Way synchronization. In one way synchronization, no modification is done in the source database. Two way synchronization allows you to transfer data from the source to the target and vice-versa.
Additionally, you can configure SJA to detect changes only for specific rows and columns. For example, you can exclude blob columns or include only those rows that fulfill a WHERE clause. This makes it an ideal tool to sync data even if there is limited bandwidth.
SJA is a command line tool that accepts a Job Definition file encoded in XML as one of the parameters. You can either create the Job Definition file manually or use one of the wizards included with SQLyog Enterprise. If you use SQLyog Enterprise to create your job files, you don’t need to have any knowledge about XML or the Job Definition schema

Front-end to manage hosted MySQL over over SSH/HTTP tunnels

Does the responsiveness of your web-based MySQL admin tool decrease your efficiency? Or does it make you sleep-deprived!?
If yes, read on.
The reason is that most ISPs block the MySQL port or prevent remote connections to MySQL. They probably have their reasons to do so where hundreds or thousands of users (of which not everyone cares or understands about security) share the same server. The only option is to manage MySQL with a web-based application running on the server. Thus you are forced to live with the annoying page-refreshes for every small operation!
SQLyog changes the rules of the game. Just by uploading a single PHP page to your web server, you can use all the cool features of SQLyog. The PHP page exposes the MySQL API as a set of web-services that can be consumed by SQLyog. This setup does not violate any reasonable security concerns that the ISP may have on behalf on their users. In this respect it makes no difference if the PHP-script connecting to MySQL is phpMyAdmin or it is the SQLyog Tunneller-script. Security is the same. However, efficiency is high, because with SQLyog, only data gets transferred without any graphics and GUI-elements.
Once you are connected over HTTP / HTTPs tunnel, you will not feel the limitations of a web-based application. Work with your local files, take backups on your local drive. Be Free!
(Keygen include)RS-Download (10 MB)