HoneySoftware

HoneySoftware HoneyMonitor v.1.0.16-beta - Release Notes, Rev. 57
Contents:

Changes in release 1.0.x
Changes in release 0.9.x
Changes in release 0.8.x
Changes in release 0.7-x
Changes in release 0.6-x
Changes in release 0.5-x
Changes in release 0.4-x
Changes in release 0.3-x
Changes in release 0.2-x
Changes in release 0.1-x

• New Features:
  • new Tab "Defaults Folders" in the "HoneyMonitor Options" Window to set the default folders to be used when storing Audit Reports, Standard Reports, HTML Reports, Queries, Backups, Scripts, Exported Data.
• Improvements:
  • during the installation of the Audit System, it is now possible to choose the engine of the Audit Table. InnoDB is used by default.
  • when connecting to a server through Network or Audit Pro Editions, now a message alerts users if Event Scheduler is stopped.
  • minor improvements to the Filter Editor: an info-icon has been included to help users when setting a filter condition.
  • a different structure of directories is now used to store users' files created through HoneyMonitor (queries, reports, backups). All the files are now stored as default in the folder Documents\HoneySoftware\HoneyMonitor.
  • minor improvements in the Binary and Relay Log Editor.
  • improved stability of Connections to MySQL®: both for direct and SSH Tunneling connections.
  • several improvements in the "Connection Window":
    • it is now possible to specify a SSH Key for Tunneling Connections;
    • it is not mandatory anymore to set a local port number for SSH Tunneling Connections: you can set it or leave the default 0 value. If 0 is chosed a random (free) port will be choosed by HoneyMonitor;
    • it is now possible to store a connection even if it fails (a new "Save and Close" button has been added in the "Connection Window", when the Window is in "creation mode"). Prior to this, it was possible to edit a connection but it was not possible to create a stored connection if that connection was failing.
    • it is now possible to edit a stored connection at software startup (before, it was possible only to select a stored connection or create a new one, and it was possible to edit a stored connection only after "entering" in the software - e.g. after "Server Objects List" was loaded.
  • several improvements to the "Unable to Connect" Window: added more information and tips to better indetify and solve occurred connection errors.
  • minor improvements in the Performance Tuning Monitor: now the Report Preview is opened in a new Window, outside the Monitor, for a better usability.
  • several other minor improvements.
• Bugs Fix:
  • some Editors were closed even if not able to save, after choosing "yes" on the message "Would you like to save your changes?".
  • due to a wrong Edition limitation, in the Audit Pro Edition of HoneyMonitor, it was not possible to open the Report Preview using the top menu included in the software. Now fixed.
  • Plugin Editor: Editor was opening a different plugin (the first) than that selected in the "Server Objects Lists".
  • fixed several inconsistencies between the active node of the Server Objects List, the software captionbar and some top level menus: now, if a connection is closed, many menus are disabled so users can't open some Windows or Editors until they connect to a MySQL® Server using the Server Objects List or the "Connect" menu entry.
  • many Wizards now remember the last used directory for storing files (backups, HTML reports, reports, ...).
  • if any error occurs when executing FLUSH or RESET queries (feature called from the top menu of the software), now the message that is shown is formatted in a better way.
  • changed some red lines with blu and orange ones. Red color is typically associated to "alert status" so we have changed it for better intuitiveness. Green and red colors are now used as symptom of "no attention needed" and "attention needed". Blue and orange lines are just graphical elements and are not associated with alert status at all.
  • better error handling when connecting on a server using a wrong STMT statement.
  • better error messages when pinging and shutdowning the server (if any error is returned).
  • several bugs fix in the Trigger Editor.
  • several bugs fix in User's Privileges Window.
  • several bugs fix in User Editor.
  • several bugs fix when saving a script file from the Script Editor.
  • several bugs fix in the actions performed through the popup menu of the Plugins Tab of the Server Properties Window.
  • several bugs have been fixed in the Connection Window:
    • sometimes, when testing SSH Tunnels, Connection Window was saying that local port for SSH Tunnel was in use even if it was not.
    • when editing a stored connection, changes made in the local port number used for SSH Tunnel were not saved, if other options were not changed at the same time.
  • several bug fix in HoneyMonitor Options Window (when using this window with no MySQL® connections opened, some errors were occurring).
  • several bug fix in Editor Options Window.
  • several bugs fix when attempting to reconnect: there where some bugs when, after software lost connection to the server, it was automatically trying to re-establish the connection. Now software should reconnect silentely (in a transparent way from a user point a view).
  • several bugs fix in the Federated Server Editor:
    • even if set, socket option was not included in the query when creating a Federated Server (it was working fine when the Editor was in "editing mode");
  • several bugs fix in the HTML Report Wizard.
  • several bugs fix in LogFile Group Editor.
  • several bugs fix in TableSpace Editor.
  • several bugs fix in the Routine Editor:
  • some errors where occurring while opening the Editor with limited-privileges users;
  • parameters' popup menus were not localized in English.
  • several bugs fix in the UDF Editor: under some conditions, a wrong DROP FUNCTION query was executed while adding a new UDF function.
  • several bugs fix in the Server Properties Window:
    • bugs fix when changing values of the variables "general_log_file" and "slow_log_file" on Windows®.
  • several bugs fix in the Metadata Catalog:
    • bugs fix when connected over MySQL® version 6.x (MySQL® Bug #33106).
  • minor bugs fix in the localization of the Replication Monitor.
  • minor bugs fix in Server Object List.
  • minor bugs fix in Log Management Window.
  • minor bugs fix in the Performance Tuning Monitor.
  • minor bugs fix in the Field Editor when used for Timestamp fields in MySQL® 6.
  • minor bugs fix in the Table Editor.
  • minor bugs fix in the string "username@hostname:port" shown in the captionbar of the software: now the output of the query "SELECT CURRENT_USER();" is used.
  • minor bugs fix in the Backup Wizard.
  • minor bugs fix in the style of the Calendar controls used in some Windows (minor compatibility issues with Systems with English local Settings).
  • minor bugs fix in the Audit Reports: a better font size is now used for report head.
  • several other minor bugs fix.
• Other:
  • compatibility tests with MySQL® ver. 5.1.31, 5.1.32, 6.0.9-alpha and 6.0.10-alpha.

• New Features:
  • new menu entry Auditing / Reports / Edit Report's Template / Custom Report.
• Improvements:
  • minor bugs fix and improvements in the Report Designer.
• Bugs Fix:
  • on Vista^TM, the Report Designer was losing the connection after opening the report preview. Now fixed.
  • InnoDB Performance Report: an incorrect % simbol was on the chart innodb_rows_xxx_per_second. Now removed.
  • other minor bugs fix.
• Other:
  • compatibility tests with MySQL^TM ver. 5.1.29-rc, 5.1.30, 6.0.7-alpha.

• New Features:
  • new Virtual Data Grid for a better data management in HoneyMonitor (insert / edit / delete of records) [it is linked to the Table Editor, Queries Editor, View Editor, Server Objects List].
  • new menu entry Database Objects / Tables / Open Table's Data (Quick Way).
  • new menu entry Auditing / Reports / Custom Report. Possibility to create a customized Report using the Audit Table (useful to see how a numeric variable (raw or calculated) is changing over time).
  • new menu entry Auditing / Reports / Edit Report's Template to edit the Templates of the Performance Reports.
  • new menu entry Utility / Edit Report (Designer).
• Improvements:
  • minor improvements in the Metadata Catalog.
  • minor improvements in the log output created by the Data Transfer.
  • several improvements and bugs fix in the Log Management Window.
  • Server Objects List:
    • support for servers' groups;
    • minor improvements in the popup menu;
    • new menu entries "Import Link" and "Drop Link" in the popup menu of the Queries, Reports, Backups nodes;
    • new toolbar button to refresh all opened connections.
  • minor improvements to Audit Statistic Window:
    • a "Refresh" button has been added;
    • 3 new fields now show the date of the first and last audit record included in the audit table and the date difference.
  • you can now open more than one instance of the User's Account Manager.
  • improvements in the administration of the FALCON variables.
  • minor improvements in the Report Connection Choice Window.
  • new NetStat Window to see if a local port is already used before opening a SSH tunneling connection.
  • Connection Window: new STMT option (very useful, for example to set SET SQL_LOG_BIN = 0).
• Bugs Fix:
  • bugs fix in the LogFile Group Editor.
  • Field Editor (TIMESTAMP default value).
  • minor bugs fix in the Routine Editor (parameters).
  • minor bugs fix when changing software language.
  • minor bugs fix in the Performance Tuning Monitor.
  • minor bugs fix in the Change Master Wizard.
  • bugs fix when installing the Audit Database in a Master / Slave environment: SET SQL_LOG_BIN = 0 is now used, so you don't need to filter replication anymore.
  • minor bugs fix in the Replication Monitor.
  • bugs fix when establishing a SSH tunneling connection (Table Editor, View Editor, Queries Window).
• Other:
  • audit system: compatibility with MySQL^TM 6.0.6-alpha:
    • support for the Maria Engine in v.6.x;
    • status variables Com_show_column_types and Innodb_buffer_pool_pages_latched have been deprecated (MySQL^TM Bugs #36793 and #5299).
  • an up to date version of MySQL^TM Reference Manual is included (it documents MySQL^TM through 5.1.30).

• New Features:
  • first public release of the Edition Audit Pro.
  • first public release of the Edition Pro.
  • new performance Audit features:
    • new menu ''Auditing'';
    • installation of a performance audit system (only for Server's version 5.1.x or higher);
    • performance reports.
  • new Performance Tuning Monitor.
  • new Metadata Catalog.
  • new SHOW Monitor.
  • support for anonymous users.
    • new menu entry for deleting all anonymous users at once
  • new fast entry "Line Wrap" in the SQL Editor's popup menu.
  • new fast entry "SQL Syntax Highlighting Options".
  • User Editor & Change Password Window: a warning is now shown when trying to insert an empty password.
  • new Customer Experience Improvement Program (CEIP)
    • new menu Help / Customer Feedback Options;
    • new CEIP Window.
  • the HoneyMonitor Update Wizard has been deprecated. Now, when starting HoneyMonitor updates are searched on the Web and, if any, a messages is prompt.
  • support for the creation / elimination of the InnoDB Monitors: monitor, lock_monitor, tablespace_monitor, table_monitor.
  • minor changes when clicking on Server / Show... sub-menus.
  • new column ''Command Description'' in the ''Process List'' lists (Server Properties, Replication Monitor, Performance Tuning Monitor).
  • now you can filter the (server) processes by command value, as well by users.
  • first support for the Choose Database Window (for server's version lesser than 5.0. with the -skip_show_database option enabled).
  • the SQL Assistant^TM now supports Users with limited, non-root privileges.
  • the RENAME DATABASE is not supported in new servers' versions. ALTER DATABASE db_name UPGRADE DATA DIRECTORY NAME is now used.
• Improvements:
  • improvements in the Replication Monitor:
    • the slave status variables now have a description;
    • new icons in the Slaves Tab for a better view of the state (running/not-running) of the replication's threads (SQL and IO);
    • improvements in the lists' popup menus;
    • new ''Formatted Value'' column in the Master Logs list.
  • improvements in the ''Variables'' and ''Status'' Tabs of the Server Properties Window:
    • new variables handled (MARIA engine ready);
    • new column ''Formatted Value'' (e.g. bytes to KB, MB or GB);
    • improvements in the lists' popup menus.
  • SQL Syntax Highlighting improvements.
  • improvements and bugs fix in the Create Table Wizard.
  • improvements and bugs fix in the Partition Editor:
    • the Editor is now sizeable;
    • Partition's Tree: more information are now shown.
  • improvements and bugs fix in the Log Management Window:
    • support for users with limited privileges;
    • new column ''Formatted Value'' (e.g. bytes to KB, MB or GB).
  • improvements in Plugin management:
    • bugs fix in Plugin Editor;
    • new ''Plugin'' node in the Server Objects List;
    • new submenus in the Server / Plugins menu.
  • improvements in the HoneyMonitor Options.
  • improvements in the View Editor: the SQL Syntax for recreating the view is now formatted in a better way.
  • improvements and bugs fix in the Event Editor:
    • the SQL Syntax for recreating the event is now formatted in a better way;
    • now the user is not required to have privileges on mysql.events.
  • improvements and bugs fix in the UDFs Editor.
  • improvements in the Script Editor: lists in the Tab ''Profiling'' now have their popup menu.
  • improvements in the Query Window: the ''Profiling'' Tab is now enabled.
  • improvements and bugs fix in the Report Designer (upgrade to Fast-Report^TM 4.4.60).
  • minor changes in the Query Log Window.
  • bew button in the Status Tab of the Server Properties Window to flush the status.
• Bugs Fix:
  • bug fix in the Binary & Relay Log Editor.
  • bug fix in the Server Object List (Queries, Backups and Reports nodes) for servers with a port number higher than 9999.
  • bug fix in Field Editor.
  • the Change Master Wizard is now compatible with server version lesser than 5.1.
  • bugs fix in the Federated Server Editor: it failed when setting a port higher than 9999.
  • bugs fix in the View Editor.
  • bugs fix in the Routine Editor (Stored Procedures and Stored Functions).
  • bugs fix in the "User's Account Manager".
  • bugs fix in the Server Properties Window.
  • some memory-related issues have been fixed.
• Other:
  • an up to date version of MySQL^TM Reference Manual is included (it documents MySQL^TM through 5.1.26-rc).
  • compatibility tests with MySQL^TM ver. 5.1.25-rc, 5.1.23a-maria-alpha, 6.0.5-alpha.

• bugs correction

• bugs fix and improvements in the Report Designer

• bugs fix in the Report Preview Window

• a new "Warnings" Tab has been added in the HoneyMonitor Options Window

• bugs correction

• first public version of the HoneyMonitor Network Edition:
  • new Server / Replication Management menu
  • a Replication Monitor has been added
  • a Change Master Wizard has been added
  • a Binlog and Relay Log Editor has been added
  • new Server / Cluster Management menu
  • a Cluster Monitor has been added
  • a TableSpace Editor has been added:
    • now you can add DataFile to your TableSpace using the “Add DataFile Dialog”
  • a LogFile Group Editor has been added:
    • now you can add UndoFile to your LogFile Group using the “Add UndoFile Dialog”

• first public version of the HoneyMonitor Standard Edition

• new “Server Logs Management” Window:
  • the Log and Error Tab of the “Server Properties” Window have been moved to the new “Server Logs Management” Window
  • now you can manage your binary logs

• improvements to the Server Objects List:
  • a “Falcon TableSpaces” node has been added: it lists the Falcon TableSpaces, and, for each TableSpace, the Falcon Tables that use that TableSpace (for MySQL® 6.0 or higher)

• improvements to Create Table Wizard:
  • now you can specify a TableSpace (for FALCON and NDBCLUSTER engines)
  • the option STORAGE DISK | MEMORY is now supported (for NDBCLUSTER engine)

• new Code Assistance features:
  • New one-click Procedural Code View
  • Smarter IntelliSense in the code auto-completion features
  • New SQL Syntax Checker
  • Spell Checker for Comments and hard-coded String
  • Automatic Generation of Variable Declarations
  • Enhancements in the Code Structure View: added support for loops and conditional statements, support for more types of SQL commands
  • Improvements in Code Formatter and Beautifier

• first support for the Plugin Editor

• first support for SSL Connections

• first support for the MetaData Catalog (it is included in the Server Objects List)

• bugs fix in Partition Editor: when adding partitioning to a table, the Editor doesn’t allow the User to change the partition query.

• improvements to the Event Editor:
  • now you can set the variable event_scheduler in a simpler way (without opening the Server Properties Window, but just click on the Editor Status Bar)
  • compatibility with MySQL® v.5.1.22-rc

• improvements to the Script Editor: now you can set the variable profiling_history_size in a simpler way (without opening the Server Properties Window, but just click on the dedicated button)

• bugs fix and improvements to the Query Builder

• improvements to the Installation Wizard: now all the HoneyMonitor Editions are installed, and you can choose, after installation, which Edition to use

• bugs fix in the Connection Window

• bugs fix in the UDFs Editor

• improvements to the User Editor: after the user creation, the Editor is now ready to edit the user just created (it isn’t closed)

• bugs fix in Index Editor: HoneyMonitor fails in FULLTEXT index creation

• bugs fix in Table Properties Window

• bugs fix in Stored Functions and Stored Procedures Editors: parameters like DOUBLE(10,2) UNSIGNED or DECIMAL(10,2) UNSIGNED were incorrectly parsed

• bugs fix in Federated Server Editor

• improvements and bugs fix to the Server Properties Window:
  • a “Description” column has been added to the Status Variables List
  • some missing system variable descriptions have been added
  • support for a logical visualization of the Status Variables (in Categories)
  • support for a logical visualization of the System Variables (in Categories)
  • now you can check the NDB status (from the Engine Status Tab)
  • now you can see the InnoDB mutex statistics (from the Engine Status Tab)
  • the InnoDB Status Tab has been renamed in Engine Status

• compatibility tests with MySQL® ver. 5.1.21-beta, ver. 5.1.22-rc and ver. 6.0.3-alpha

• compatibility tests with MyODBC ver. 3.51.19, 3.51.20, 3.51.21 and 3.51.22

• an up to date version of MySQL® Reference Manual is included (it documents MySQL® through 5.1.23-rc)

• bugs fix in the HTML Report Wizard (an error occurred if you didn’t choose, as destination folder, the default one)

• bugs fix in Import and Export Data Wizards

• bugs correction

• bugs fix: if used with an empty password MySQL® account, HoneyMonitor fails to execute SQL script, backup data, transfer db objects, ping the server, shutdown the server, open a command line client, create a report

• now you can enable / disable the HoneyMonitor logging using HoneyMonitor Options form

• compatibility tests with MySQL® ver. 5.1.20-beta

• an up to date version of MySQL® Reference Manual is included (it documents MySQL® through 5.1.19-beta)

• improvements and bugs fix in SQL Script Execution Wizard:
  • a new step for results visualization has been added
  • now you can open several instance of the form
  • asynchronous execution is now supported
  • a new step for execution options has been added

• improvements and bugs fix in SQL Script Editor:
  • now you can set several execution options
  • now you can view (and save) the script output in several format: .txt, .html and .xml
  • now the SQL errors occurred during execution are showed in a separated text-box
  • now you can choose to execute the script asynchronously, in a separate thread (so while Script executing, you can use other HoneyMonitor functionalities; also at any moment you can stop the script execution)
  • a ``Profiling'' Tab has been added in order retrieve profiling information that indicates resource usage for executed statements

• now you can set the value of the dynamic variables profiling and profiling_history_size

• graphical improvements to Create Table Wizard

• improvements and bugs fix in Event Editor:
  • the state SLAVESIDE_DISABLED has been added to the state's list
  • you can now rename the event using a command on the Editor

• improvements to Server Objects List:
  • User's items have been added to the toolbar
  • now the Table's sub-items have their own popup menu

• improvements to several menu and popup menu:
  • improvements to Server menu
  • improvements to Database's menu and popup menu: a "Multi-Drop of Databases" item has been added
  • improvements to Federated Server's menu and popup menu: a "Multi-Drop of Federated Servers" item has been added
  • improvements to UDF's menu and popup menu: a "Multi-Drop of UDFs" item has been added
  • improvements to User's menu and popup menu:
    • a "Multi-Drop of Users" item has been added
    • now all User's Administration tasks are accessible via the Server menu
  • improvements to Event's menu and popup menu: a "Multi-Drop of Events" item has been added
  • improvements to Function's menu and popup menu: a "Multi-Drop of Functions" item has been added
  • improvements to Procedure's menu and popup menu: a "Multi-Drop of Procedures" item has been added
  • improvements to View's menu and popup menu: a "Multi-Drop of Views" item has been added
  • improvements to Table's menu and popup menu: a "Multi-Drop of Tables" item has been added
  • a "Print" item has been added in Editor's popup menu

• a Multi-Drop Wizard has been added: it helps you in dropping a set of same-type objects

• bugs fix in Blob Editor

• bugs fix in Table Properties form

• bugs fix in Add Partition form

• bugs correction

• bugs fix in Partition Editor

• bugs fix in Queries Window

• bugs fix in View Editor

• graphical improvements in Web Browser

• now the User’s Privileges form is resizable

• improvements and bugs fix in Field Editor: now you can set default values for TIMESTAMP fields in a better way

• improvements in several Editors: now you can use shortcuts

• improvements and bugs fix in MySQL® Immediate Help Window

• improvements in Query Log Window

• improvements and bugs fix in Advanced Sorting Form

• improvements in Index Editor

• improvements and bugs fix in Create Table Wizard

• SQL Syntax Highlighting improvements

• bugs fix in Federated Server List localization

• bugs correction

• the SQL Assistant® has been integrated

• bugs fix in Blob Editor

• bugs fix in Table Properties form

• improvements and bugs fix in Create Table Wizard

• bugs fix in Connect to MySQL® Server form

• bugs correction

• improvements to Field Editor: ASCII and UNICODE flags has been added

• bugs fix in View Editor

• bugs fix in Create Table Wizard

• bugs fix in Data Transfer Wizard: events were not properly transferred

• bugs fix in HTML Report Wizard: create event syntax was not properly shown

• bugs fix in Queries Window

• compatibility with MySQL® version 5.1.18: now the Event Editor shows the "Originator" field

• compatibility tests with MySQL® ver. 5.1.18

• bugs fix in Server Properties form

• Improvements in Dynamic Variables management ("Variables" Tab of Server Properties Form)

• SQL Syntax Highlighting improvements

• bugs correction

• Table Editor: now in the Tab headers the number of the contained objects (fields, indexes, ...) is showed

• bug fix in Queries Window

• bug fix in User's Account Manager

• now you can open User's Privileges Window from within the User Editor

• bugs correction

• bugs fix in Queries Window

• SQL Syntax Highlighting improvements: now you can set MySQL® variables style (i.e. @@variable_name, @variable_name) and identified text style (i.e. `database_name`, `table_name`)

• improvements and bugs fix in Event Editor: now you can specify a definer

• improvements and bugs fix in Trigger Editor: a "SQL" Tab had been added

• improvements and bugs fix in Routine Editor (Stored Procedures and Stored Functions): a "Internal Representation" Tab had been added

• bugs fix in View Editor

• an up to date version of MySQL® Reference Manual is included (it documents MySQL® through 5.1.18-beta)

• bugs correction

• bug fix in SSH Tunneling Connections

• bug fix in Table Properties

• bug fix in Views Editor localization

• Create Table Wizard:
  • new row_format had been added
  • you can now use the Query Builder within the Create Table Wizard for "Select Statement" creation
  • you can now set KEY_BLOCK_SIZE option (starting from MySQL® v.5.1.10)
  • you can now set Connection option for FEDERATED engine

• you can now edit log_output variable value

• SQL Syntax Highlighting improvements

• Federated Server management:
  • a Federated Server Editor had been added
  • Federated Servers are now listed in Server Objects List

• an up to date version of MySQL® Reference Manual is included (it documents MySQL® through 5.1.16-beta)

• bug fix in UDF Editor localization

• bug fix in Field Editor

• bugs correction

• compatibility with MySQL® version 5.2: FALCON engine had been added to the lists of engines

• compatibility tests with MySQL® version 5.2.3

• Table Properties: a confirmation is now required when you try to change table's engine to MERGE or BLACKHOLE in order to prevent inadvertent loss of data

• bug fix: engines lists lack of BLACKHOLE engine

• Server Properties Window:
  • bugs fix
  • you can now edit global event_scheduler variable value

• Scheduled Event Editor: if event_schedueler value (global variable) is OFF or DISABLED, a warning is showed in status bar

• bugs fix in Table Editor

• bugs fix in Script Editor

• SQL Script Execution Wizard: bug fix in big files line numbers calculation

• bugs correction

• Syntax Highlighting improvements: a new set of reserved words had been added to SQL words list

• bugs fix in Routine Editor (Stored Procedures and Stored Function):
  • bug fix in parameter's parsing
  • existing procedures having parameters whose type [ IN | OUT | INOUT ] was not specified are now parsed: IN is used by default
  • parameter attributes are now parsed (for example IN `param1` BIGINT ZEROFILL)
  • you can now set parameter's attributes (i.e. ZEROFILL, UNSIGNED, ASCII, UNICODE, BINARY)
  • you can now set value's list for ENUM and SET parameters
  • bug due to the presence in the same database of a stored function and a stored procedures having the same name had been fixed
  • all SQL Queries carried out by Routine Editor are now listed in Query Log Window

• detailed information on open connections are now showed by clicking on HoneyMonitor status bar

• bugs fix in Query Builder SQL parsing

• improvement to popup menu relative to Query node of the Server Objects List: "New SQL Script" item had been added

• compatibility tests with MySQL® version 5.1.16

• an up to date version of MySQL® Reference Manual is included (it documents MySQL® through 5.1.15-beta)

• bugs correction

• first public release

• bugs correction

• compatibility with MySQL® version 5.1.14: a "License" column had been added to "Plugins" Tab of Server Properties Window.

• compatibility tests with MySQL® version 5.1.14

• a status bar had been added to Server Objects List Form

• an Editor Option Form had been added: you can now edit advanced options of SQL text editors

• an helpful Query Builder had been added in "Edit" Tab of Queries Window: an easy graphic way to create complex SQL queries

• improvements in refreshing Server Objects List’s treeview

• you can now open several Queries Window

• compatibility tests with MySQL® version 5.1.12

• added the form MySQL® Immediate Help

• support for several help files according with software languages

• you can now rename an event by using Server Objects List form popup menu

• compatibility with MySQL® version 5.1: support for Event privilege

• bugs correction

• improvements to Backup Wizard

• you can now choose using a program option if Table Editor and View Editor have to show extensive or minimal information on fields

• improvements to View, UDFs, Script, Procedures, Functions, Events and Blob Editor

• improvements to Export and Import Data Wizard

• improvements to HoneyMonitor Options form

• improvements to HTML Report Wizard: you can now specify a “WHERE’ condition (only for one table or one view reports)

• support for print of views

• bugs correction

• you can now create a report from Records Viewer form

• improvements to SQL Script Execution Wizard: you can now choose which connection to use; useful information on file script are now showed

• improvements to Table Properties form

• improvements to Table Editor: you can now use useful popum menu from field, indexes, ..., grids; toolbar improvements: report button had been added

• improvements to Trigger Editor: useful popup menu had been added

• improvements to Fields Editor: geometric fields are now supported; you can now choose where to insert the field (before or after an existing field)

• improvements to Table Maintenance Wizard: you can now choose which connection to use

• improvements to Create Table Wizard: useful popup menu had been added in fields, indexed and foreign keys grids

• bugs correction

• first support for HoneyMonitor Update Wizard

• improvements to Server Properties form

• first support for Report Preview form

• first support for Graphical Report with FastReport® tool: you can now print tables and query results

• Splash form graphical restyling

• added an option to choose objects to show in the Server Objects List's treeview

• bugs correction

• first support for Connection Errors form: it show helpful tooltips on connection errors

• improvements to Partition Maintenance form

• improvements to Partition Editor

• improvements to Trigger Editor

• added an option to change HoneyMonitor style (XP® or Window 2000®)

• bugs correction

• improvements to Add Partition form

• improvements to Reorganize Partition form

• support for SSH (Secure SHell) tunneling connections

• first support for Query Log Window

• first support for Partition Maintenance form

• bugs correction

• compatibility with MySQL® version 5.1: a partitioning step was added in Create Table Wizard

• compatibility with MySQL® version 5.1: first support for Partition Management from Table Editor: you can now add, drop, aggregate partitions, ...

• compatibility with MySQL® version 5.1: first support for Reorganize Partition form

• compatibility with MySQL® version 5.1: first support for Partition Editor

• compatibility with MySQL® version 5.1: first support for Add Partition form

• bugs correction

• a foreign key step was added in Create Table Wizard

• added helpful popup menu in Routine Editor (Procedures and Functions)

• added "Routine Information " frame in Routine Editor (Procedures and Functions)

• compatibility with MySQL® version 5.1.8: you can now specify a routine definer

• you can now change parameters order in Routine Editor

• bugs correction

• an helpful status bar was added in several Editors

• you can now choose to add a link in the Server Objects List after a query save

• added helpful popup menu in Queries Window

• first support for Server Properties and Set value for 'variable' form

• added the "Reset..." submenu in the Server menu

• improvements to Table popup menu of Server Objects List form

• bugs correction

• improvements to Foreign Key Editor

• added "Find" and "Filter" functionalities in record grids

• added the "Form View" in the Records Viewer form

• bugs correction

• improvements to Event Editor

• compatibility tests with MySQL® version 5.1.9

• compatibility with MySQL® version 5.1: you can now rename a database

• bugs correction

• compatibility tests with MySQL® version 5.1.7

• compatibility with MySQL® version 5.1: the Event Editor was added: you can now create/edit/enable/disable/drop events

• compatibility with MySQL® version 5.1: added helpful popup menu in the "Scheduled Events" node of Server Objects List form

• compatibility with MySQL® version 5.1: added the "Scheduled Events" node in the Server Objects List form: it lists events of the parent database if you have select privileges in mysql.event table

• bugs correction

• added a progress bar visible while loading objects in the treeview of Server Objects List form

• you can now shutdown the Server provided you have the right privileges

• you can now Ping the Server

• bugs correction

• improvements to Data Transfer form

• first support for Event Editor

• bugs correction

• first support for Data Transfer form

• improvements to records grids

• bugs correction

• added the option "confirm script execution" in the HoneyMonitor Options form

• outline info are now showed after a script execution from SQL Script Execution Wizard

• graphical improvements to SQL Script Execution Wizard

• improvements to Backup Wizard: - several fast options were added - outline info on backup are now shown

• bugs correction

• graphical restyling of Server Objects List form

• Server Objects List form is now dockable

• bug correction in Server Objects List form refresh

• improvements to Create Table Wizard: a summary final step was added; you can now edit the creation table query

• bugs correction

• added the Copy Table Wizard in order to copy/clone a table from a database to another in the same server

• bugs correction

• compatibility with MySQL® version 5: improvements to HTML report: you can now print views, procedures, functions and events apart form table

• bugs correction

• improvements to Queries Window: multiple queries support was added

• MySQL® version check for several "show" syntax

• bugs correction

• improvements to UDFs Editor

• bugs correction

• UDFs Editor was added

• added the UDFs node in the Server Objects List form: it lists the server's udf provided you had the right privileges on mysql.func table

• bugs correction

• improvements to View Editor

• bugs correction

• compatibility with MySQL® version 5: you can now rename a view

• compatibility with MySQL® version 5: View Editor was added

• bugs correction

• improvements to Function Editor

• you can now drop a function by using the popup menu of the Server Objects List form

• bugs correction

• compatibility with MySQL® version 5: Function Editor was added: you can now create/edit/call Stored Function

• compatibility with MySQL® version 5: added tho "Functions" node in the Server Objects List form: it lists stored functions of parent database provided you have the right privileges on mysql.proc table

• bugs correction

• improvements to Stored Procedure Editor

• directory /tmp is now used by HoneyMonitor

• first support for Script Editor

• bugs correction

• compatibility with MySQL® version 5: Stored Procedure Editor was added: you can now create/edit/execute Stored Procedures

• compatibility with MySQL® version 5: added the "Stored Procedures" node in the Server Objects List form: it lists stored procedures of parent database provided you have the right privileges on mysql.proc table

• bugs correction

• HTML Report Wizard was added

• bugs correction

• added the Move Table Wizard and the Wizards for Tables maintenance

• a video is now shown while Server Objects List form is refreshing

• bugs correction

• you can now open several Table Editor

• you can now edit the database charset and collation

• bugs correction

• you can now specify charset and collation in a database creation

• bugs correction

• the Windows menu was added

• Import and Export Wizard were added

• bugs correction

• added the option "prompt before quit" in HoneyMonitor Options form

• added the option "Show info after a Flush syntax" in HoneyMonitor Options

• added the option "use no_write_to_bin_log option for flush queries" in HoneyMonitor Options form

• bugs correction

• added the remove host from Server Objects List functionality

• Flush... menu and popup menu were added

• first support for HoneyMonitor Options form

• bugs correction

• first support for simultaneous connections to several servers

• bugs correction

• you can now consult MySQL® Reference Manual by clicking in the HoneyMonitor Help menu

• directory /settings/languages is now used

• first support for Choose Software Language form