Changes (as compared to 7.12) include:

Bug fixes:
* Fixed a rare crash in Schema Sync. This issue was discovered when testing internally. No user had reported this.
* Management of column-level privileges was not functional.
* It was only possible to select a single group of objects in GRIDS with the shift+click modifier.

Miscellaneous:
* Autocomplete now uses secure atomic transactions when writing to SQLite databases (’Tags files’). We had a few reports of random program crashes that could be traced down to corrupt SQLite databases. This corruption will now not happen any more.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Changes include:

Bug fixes:
* Fixed a rare crash in Schema Sync.  This issue was discovered when testing internally.  No user had reported this.
* Management of column-level privileges was not functional.
* It was only possible to select a single group of objects in GRIDS with the shift+click modifier.

Miscellaneous:
* Autocomplete now uses secure atomic transactions when writing to SQLite databases (’Tags files’). We had a few reports of random program crashes that could be traced down to corrupt SQLite databases. This corruption will now not happen any more.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Changes (as compared to 7.11) include:

Features:
* This release improves the handling of Foreign Keys with HTTP-tunnelling. In Data Sync, Migration, ‘copy to other’, ‘empty database’ and ‘truncate database’ statements are now processed in batches and “SET FOREIGN_KEY_CHECKS = 0″ statement (if selected by user) will be reinstantiated for every batch. This is a 100% solution to problems with FK’s normally occuring with PHP applications/connections due to the non-persistent nature of PHP<>MySQL connections:
* In preferences added an option to ‘force disable FK check throughout HTTP import batch process’. Selecting this will have same effect as above when importing external files with SQLyog (from tools .. restore from SQL-dump) over an HTTP-connection. It is selected as default.

Bug Fixes:
* On Wine selecting individual objects (like a single table) for export/copy could export/copy all. This was yet another issue with the tree-view control in Wine.
* Autocomplete with table alias failed if “FROM” in FROM-clause was written UPPERCASE.
* It was not possible to create the Primary Key on <target> with the Migration tool if using option to import using a user-specified query.
* Dropping a table ON which a TRIGGER was defined did not refresh the TRIGGERs folder for the database in the Object Browser. Also ‘reorder columns’ did not automatically refresh the COLUMNs folder for a table.
* The display in Object Browser could garble if program was minimized/maximized while a query was running.
* Right-clicking a only partially visible cell in DATA/RESULT tab would not select properly.
* The CREATE USER privilege (introduced in MySQL 5.03) was not handled by SQLyog user management.
* Fixed a painting issue in ‘manage privileges’ dialogue introduced with resizability in 7.11.
* Fixed an issue with the CSV import dialogue that could result in a ‘hang’ or ‘crash’.
* When nothing was selected for SQL export an empty file was generated.  Now an error pops up.
* Fixed a crash in data sync. This issue affected only empty tables (or empty WHERE results) without a PK.
* CSV-export escaped wrong inside enclosed/quoted strings. Only the enclose character itself should be escaped, but also field seperator character and linebreaks were.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Also SJA for Linux was updated with the fix for the data sync issue.

Comments(1)

Changes (as compared to first RC) include:

Bug fixes:
* It was not possible to create the Primary Key on <target> with the Migration tool if using option to import using a user-specified query.
* Dropping a table ON which a TRIGGER was defined did not refresh the TRIGGERs folder for the database in the Object Browser.
* The display in Object Browser could garble if program was minimized/maximized while a query was running.
* Right-clicking a only partially visible cell in DATA/RESULT tab would not select properly.
* The CREATE USER privilege (introduced in MySQL 5.03) was not handled by SQLyog user management.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Features:
* This release improves the handling of Foreign Keys with HTTP-tunnelling. In Data Sync, Migration, ‘copy to other’, ‘empty database’ and ‘truncate database’ statements are now processed in batches and “SET FOREIGN_KEY_CHECKS = 0″ statement (if selected by user) will be reinstantiated for every batch.  This is a 100% solution to problems with FK’s normally occuring with PHP applications/connections due to the non-persistent nature of PHP<>MySQL connections:
* In preferences added an option to ‘force disable FK check throughout HTTP import batch process’.  Selecting this will have same effect as above when importing external files with SQLyog (from tools .. restore from SQL-dump) over an HTTP-connection.  It is selected as default.

Bug Fixes:
* On Wine selecting individual objects (like a single table) for export/copy could export/copy all.  This was yet another issue with the tree-view control in Wine.
* Autocomplete with table alias failed if “FROM” in FROM-clause was written UPPERCASE.

Downloads: http://webyog.com/en/downloads.php:
Purchase: http://webyog.com/en/buy.php

Comments(0)

Introduction

If you are hosting your website with Yahoo Small Business Hosting, you will be forced to use a web based admin tool to manage your MySQL database. In fact, the help page on managing MySQL categorically mentions that “You will not be able to access your database using a desktop client or other tools run outside of Yahoo!”(I bet they don’t read our blog). In this article, I will show you how you can use all the cool and powerful features of SQLyog Enterprise with Yahoo Small Business Hosting. The same concepts can be applied to connect to other hosting providers like Godaddy, Network Solutions etc. which don’t provide direct access to MySQL database.

Step by Step Setup Guide

1. Login to your Yahoo web-hosting and you will land in home page of “Web Hosting Control Panel”.

2. Select “Create and Update Tab” in the Web Hosting Control panel.

3. (Optional) Click “MySQL Database” under “Other Site Building and Editing Tools” to create/alter your MySQL username/password. If you already know your MySQL user name and password, skip this step.

4. Now you need to upload the Tunnel Page (shipped with SQLyog Enterprise) to the Yahoo Web Server.

5. Select “Easy Upload” option under “File Management Tools”.

6. Type in the path to SQLyogTunnel.php (available in the SQLyog Enterprise installation folder) and click on the “Upload Files”  button.

7. Verify the uploaded file by accessing it with a browser.

8. Start SQLyog Enterprise and configure the Connection tabs as specified in the screenshots. Change the User Name and Password to your Username/Password specified in Step 4. Make sure that the MySQL Host Address is set to “mysql” and not  “localhost”.

Click “HTTP” tab, Check “Use HTTP Tunneling” & in the URL field, provide the URL to SQLyogTunnel.php under your domain and click on “Connect”.

9. You are now connected to your hosted MySQL Server. Enjoy the power of SQLyog Enterprise!

Download trial version of SQLyog Enterprise here.

Comments(4)

Bug fixes:
* Pressing Crtl+end in GRID did not show the last row. This bug was introduced in 7.1.
* Fixed a flickering issue in Data tab. It was a threading issue related to the STOP button introduced in 7.1.
* When executing a query not returning a result set, focus would leave editor (unless the ‘keep focus on editor’ option was set).  This made no sense.  Now focus will be kept on editor if there is no result set.
* Data sync could fail with column names containg a SPACE character and if specific keywords was used for column names.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Also SJA for Linux was updated with the fix for the Data Sync issue.

Comments(4)

Changes (as compared to 7.02) include:

Features:
* Added keyboard shortcut (F6) for Edit Index.
* The behaviour of Ctrl+R shortcut was slightly changed. It will now position cursor inside the active tab in Result pane. Before it was functional only with DATA tab and RESULT tabs.
* Added tab-navigation (for query tabs) entries in Edit-menu. Also the active Query tab can now be closed from menu.
* In certain situations Schema Sync would generate CHANGE-clauses for a column that basically did nothing (changing column to what it was). This is now ‘cleaned up’.
* A tab in the Query pane (a Query tab, a Schema Designer tab and a Query Builder tab) can now be closed with Alt+L keyboard shortcut and can now be navigated with Ctrl+pgup and Ctrl+pgdn keyboard shortcuts.
* Favorites are now displayed using Scintilla editor component. For statements with complex formatting this makes the preview more readable.
* Autocomplete now supports alias in UPDATE and DELETE statements.
* BLOB viewer and the program dialogues for schema sync, create/alter table, manage indexes (including sub-dialogues) manage foreign keys (including sub-dialogues) and manage privileges are now resizable. From now resizable dialogues have a ‘gripper’ icon in right bottom corner.
* Added a movable ’splitter’ between the object area and the script area in schema sync dialogue.
* Preferences dialogue was redesigned.
* Added an option in Preferences to ‘Automatically refresh DATA tab on focus’. This was the program behavior before 7.0. In 7.0 to 7.02 it was not. Now it is optional.
* Shift+click is now functional for multiple selection everywhere in GRIDS (before it was only in Result/Table Data tabs).
* ’show in text’ (Ctrl+L) is now functional for both DATA tab and RESULT tab. Also ‘Find’ (Ctrl+F) now works with DATA tab in text mode.
* Stop option implemented in data tab. This is in particular useful if accidentially the ’show all’ option was selected for a huge table.
* Added an icon in data tab tool bar indicating if current display is filtered. Also from this icon ‘reset filter’ can be applied directly.
* Added option in Schema Sync to compare all objects or compare only tables.
* Now the result tab displays the query as a ribbon at the bottom. This is useful where more queries are executed from the same editor tab.
* Refresh option included for show variables, show processlist and show status.
* Changed functionality for shortcut F3; now it pops up ‘Find’ dialog (before it was for keyboard shortcut dialog - F12 is used for this now).
* The sync script generated by Schema Sync could fail when a change in columns used for Foreign Key(s) or a change with the Foreign Key itself was attempted.
* The display of execution time etc. for queries (in MESSAGES tab, HISTORY tab and statur bar) was reorganised for better clarity.

Bug Fixes:
* The GRID would truncate the display of strings longer than 511 characters.
* When a user-defined DELIMITER and a comment occured close to another in the program editor, the editor tokenizer component could fail to identify exactly where a statement began and ended.
* Data Sync could fail with a table having no Primary Key, but more Unique Keys, if the same column was used for defining more than one of the Unique Keys of the table. This was introduced with the new Data Sync code of 7.0 (before 7.0 Unique Keys were not used by Data Sync at all - only Primary Keys were).
* Fixed an escaping bug in Data Sync.
* Fixed an issue with WHERE clause in Data Sync.
* Proxy authentication details were not written correctly to jobfile by SJA wizards.
* Since 7.0 the WHERE clause defined by user in migration wizard was not written to jobfile.
* In Wine Schema Sync could generate an erroneous sync script (specific functions on Wine functioned slightly different than the original Win32 API).
* Fixed a number of GUI related issues.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(2)

Changes as compared to 7.1 beta2 include:

Features:
* Stop option implemented in data tab. This is in particular useful if accidentially the ’show all’ option was selected for a huge table.
* Added an icon in data tab tool bar indicating if current display is filtered. Also from this icon ‘reset filter’ can be applied directly.
* Added option in Schema Sync to compare all objects or compare only tables.
* Now the result tab displays the query as a ribbon at the bottom.  This is useful where more queries are executed from the same editor tab.
* Refresh option included for show variables, show processlist and show status.
* Changed functionality for shortcut F3; now it pops up ‘Find’ dialog (before it was for keyboard shortcut dialog - F12 is used for this now).
* Now also ‘manage privileges’ dialogue is resizable.  From now resizable dialogues have a ‘gripper’ icon in right bottom corner.

Bug Fixes:
* Fixed an escaping bug in Data Sync.
* Fixed an issue with WHERE clause in Data Sync.
* Proxy authentication details were not written correctly to jobfile by SJA wizards.
* Since 7.0 the WHERE clause defined by user in migration wizard was not written to jobfile.
* In Wine Schema Sync could generate an erroneous sync script (specific functions on Wine functioned slightly different than the original Win32 API).
* The sync script generated by Schema Sync could fail when a change in columns used for Foreign Key(s) (or a change with the Foreign Key itself) was attempted.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)

Changes as compared to beta1 include:

Features:
* Also BLOB-viewer is now resizable.
* Added keyboard shortcut (F6) for Edit Index.
* The behaviour of Ctrl+R shourtcut was slightly changed. It will now position cursor inside the active tab in Result pane. Before it was functional only with DATA tab and RESULT tabs.
* A tab in the Query pane (a Query tab, a Schema Designer tab and a Query Buider tab) can now be closed with Alt+L keyboard shortcut.
* In certain situations Schema Sync would generate CHANGE-clauses for a column that basically did nothing (changing column to what it was). This is now ‘cleaned up’.
* Favorites are now displayed using Scintilla editor component. For statements with complex formatting this makes the preview more readable.
* Added tab-navigation (for query tabs) entries in Edit-menu.  Also the active Query tab can now be closed from menu.
* ‘Find’ is now possible in DATA  tab in text-mode (just like it was in RESULT tab).

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(0)