Online Documentation for SQL Manager for MySQL
Version history
Product name |
Version |
Release date |
SQL Manager for MySQL |
August 9, 2022 |
|
SQL Manager for MySQL |
October 20, 2021 |
|
SQL Manager for MySQL |
December 17, 2019 |
|
SQL Manager for MySQL |
December 21, 2018 |
|
SQL Manager for MySQL |
July 10, 2018 |
|
SQL Manager for MySQL |
February 18, 2018 |
|
SQL Manager for MySQL |
August 21, 2017 |
|
SQL Manager for MySQL |
December 21, 2016 |
|
SQL Manager for MySQL |
October 26, 2016 |
|
SQL Manager for MySQL |
August 16, 2016 |
|
SQL Manager for MySQL |
June 2, 2016 |
|
SQL Manager for MySQL |
September 2, 2016 |
|
SQL Manager for MySQL |
June 26, 2015 |
|
SQL Manager for MySQL |
April 6, 2015 |
|
SQL Manager for MySQL |
February 9, 2015 |
|
SQL Manager for MySQL |
September 23, 2013 |
|
SQL Manager for MySQL |
April 27, 2012 |
|
SQL Manager for MySQL |
January 19, 2012 |
|
SQL Manager for MySQL |
August 03, 2011 |
|
SQL Manager 2011 for MySQL |
June 14, 2011 |
|
SQL Manager 2010 for MySQL |
August 23, 2010 |
|
SQL Manager 2010 for MySQL |
June 19, 2009 |
|
SQL Manager 2007 for MySQL |
August 22, 2008 |
|
SQL Manager 2007 for MySQL |
February 26, 2008 |
|
SQL Manager 2007 for MySQL |
November 1, 2007 |
|
SQL Manager 2007 for MySQL |
June 4, 2007 |
|
SQL Manager 2007 for MySQL |
April 19, 2007 |
|
SQL Manager 2005 for MySQL |
June 20, 2006 |
|
SQL Manager 2005 for MySQL |
March 28, 2006 |
|
SQL Manager 2005 for MySQL |
February 2,2006 |
|
SQL Manager 2005 for MySQL |
October 26, 2005 |
|
MySQL Manager |
August 17, 2005 |
|
MySQL Manager |
June 29, 2005 |
|
MySQL Manager |
April 13, 2005 |
|
MySQL Manager |
February 15, 2005 |
|
MySQL Manager |
February 1, 2005 |
|
MySQL Manager |
November 29, 2004 |
|
MySQL Manager |
July 21, 2004 |
|
MySQL Manager |
April 12, 2004 |
|
MySQL Manager |
August 28, 2003 |
|
MySQL Manager |
June 25, 2003 |
|
MySQL Manager |
June 4, 2003 |
|
MySQL Manager |
May 21, 2003 |
|
MySQL Manager |
April 30, 2003 |
|
MySQL Manager |
April 23, 2003 |
|
MySQL Manager |
March 18, 2003 |
|
MySQL Manager |
March 17, 2003 |
|
MySQL Manager |
February 24, 2003 |
|
MySQL Manager |
February 24, 2003 |
|
MySQL Manager |
February 5, 2003 |
|
MySQL Manager |
February 5, 2003 |
|
MySQL Manager |
September 11, 2002 |
|
MySQL Manager |
July 11, 2002 |
|
MySQL Manager |
April 12, 2002 |
|
MySQL Manager |
February 15, 2002 |
|
MySQL Manager |
January 31, 2002 |
|
MySQL Manager |
November 14, 2001 |
|
MySQL Manager |
October 15, 2001 |
|
MySQL Manager |
September 5, 2001 |
1. JSON tab has been added to BLOB editor.
2. The error occured on importing DBF data with columns skipped. Fixed now.
3. Dimension and default values are now set correctly for table columns.
4. The error occured in specific configuratons on connecting to server with SSL disabled. Fixed now.
5. Users differed by 'host_name' only were not displayed correctly in a list. Fixed now.
6. Improved display of table DDL with composite key.
7. Autodefinition of file encoding fixed in SQL Script.
8. Displaying of names and types in parameters input dilog has been fixed.
9. Displaying of function body with one statements fixed.
10. Other minor improvements and bugfixes.
1. New SSL modes added: Preferred, Required, Verify CA, Verify Identity.
2. Support for ECDSA, Ed25519 Putty private keys implemented.
3. Added Keyboard-interactive authentication method for SSH.
4. Size limit removed for databases in Free version.
5. Grants and limits for users are set correctly now.
6. The process rarely remained in the process list for a long time after program close. Fixed now.
7. The error occured on editing tables with long names. Fixed now.
8. The Out of memory error ocurred on retrieving table data in some cases. Fixed now.
9. Charset was not applied correctly for procedures. Fixed now.
10. Deafult values are now processed correctly.
11. The errors occured on editing partitioned tables in some cases. Fixed now.
12. Events are now refreshed even with event scheduler disabled on the server.
13. Many other fixes and improvements.
- Editor tabs can be now highlighted with the specific DB color.
- Support for server aliases implemented.
- Updated SSH library with ECDSA and Ed25519 support.
- Added syntax support for WITH queries.
- Dependent objects are now displayed correctly in editors.
- Grant manager. Revoke all operation is performed without errors now.
- Processing of triggers fixed in Copy database wizard.
- Emoji data is displayed correctly in grid now.
- Progress bar was not displayed in Import data wizard in some cases. Fixed now.
- Other improvements and bugfixes.
- Added support for 'caching_sha2_password' authentication plugin for MySQL server 8.0.
- Parameters window for procedures is now resizable.
- The Ping option added to SQL monitor settings.
- DATE parameters were displayed incorrectly in procedure debugger. Fixes now.
- Reordering of tabs was disabled. Fixed now.
- Access violation error occurred in some cased on closing Query Builder. Fixed now.
- Program settings were saved incorrectly with non-default localization used. Fixed now.
- Column descriptions are now displayed correctly for all national charsets.
- Fixed errors on refreshing user privileges.
- SQL Editor content was not restored with 'Same queries for all databases' option ON. Fixed now.
- Some other fixes and improvements.
1. Improved support of high-DPI monitors and large-scale fonts.
2. Some improvements in dark color scheme implemented.
3. SSL connection without keys and certificates was not established. Fixed now.
4. Datetime fields were not displayed in Export data wizard. Fixed now.
5. Search of objects has been fixed.
6. Extract of functions and procedures with REPEAT loop has been fixed.
7. The error of using views in Query Builder has been fixed.
8. Text is now replaced correctly in SQL editors.
9. SQL Editor was not restored on re-opening the program. Fixed now.
10. Transactions for data were not disabled in some cases. Fixed now.
11. The error on printing diagrams in Visual Database Designer has been fixed.
12. Many other improvements and bug-fixes.
- New icons have been introduced.
- Support of dark visual theme added.
- Support of Unicode added for object names.
- Support of Access 2016 files implemented in Import data and Export data wizards.
- Export as PHP wizard. PHP Data Objects interface supported now.
- BLOB data and binary data are exported as Base64 and HEX strings for text formats.
- Duplicate wizard didn't copy data in some cases. Fixed now.
- Fixes for syntax highlighting in procedures and functions.
- Fixes in autocompletion of keywords.
- Displaying of time in Greek locale has been fixed.
- Many other improvements and bug-fixes.
- Added support of MySQL 8.0.
- Added support of generated columns.
- Added support of SIGNAL statement in Procedure and Function Editor.
- Added the ability to delete records in target tables in the Copy Database Wizard.
- The error occurred in Dependency Tree on displaying objects from another database for procedures.
- The error occurred on getting information on Scheduled Events when user had restricted permissions. Fixed now.
- The error of exporting privileges for user in Grant Manager has been fixed.
- The default values are handled correctly on inserting data now.
- Sometimes selecting the file in Import Data Wizard produced an error. Fixed now.
- Many other fixes and improvements.
- The ability to connect with custom sockets has been implemented in HTTP-tunneling module.
- The error on displaying hints has been fixed.
- The error of executing the 'LOAD DATA' statement in SQL Editor has been fixed.
- The data was incorrectly imported in the 'Update' mode. Fixed now.
- The 'Out of memory' error in the Duplicate Wizard has been fixed.
- There was no information about current connection in editor window headers. Fixed now.
- The hang on executing long-running queries with transactions has been fixed.
- Many other fixes and improvements.
- Support of PHP 7.x in HTTP-tunneling module.
- Retrieving of metadata in the Copy Database wizard has been improved.
- The error on displaying Code Completion dialog in editors has been fixed.
- Data of the Time datatype has been displayed incorrectly. Fixed now.
- The size of navigation bars was not saved. Fixed now.
- DDL triggers were not displayed in the Print Metadata report. Fixed now.
- Date values are copied to clipboard correctly now.
- The 'SELECT command denied' error occured when the user with restricted rights modified the procedure. Fixed now.
- The errors of comparing tables with autoincrement fields have been fixed.
- Many other fixes and improvements.
- Support of latest OpenSSH versions implemented.
- Added shortcut for finding objects in DB Explorer tree.
- The "SELECT command denied" error occured on creating a new procedure. Fixed now.
- The error on exporting Decimal values to MS Excel files has been fixed.
- The EXPLAIN command did not work for selected text. Fixed now.
- The Access Violation error on database comparison occured in some cases. Fixed now.
- Export of autoincrement fields with custom sorting has been fixed.
- The default shortcut for "Set to Null" has been changed at the Data tab.
- Some other improvements and bug-fixes.
- JSON type support added.
- Multiple result sets are now supported in SQL Editor.
- Timeout settings for connection and metadata lock waiting have been added.
- Search/replace features have been optimized in SQL Editor.
- Extract Database and Copy Database. Triggers can be selected separately from tables now.
- Added support of latest OpenSSH versions.
- Excessive connect/disconnect operations when connecting to a database have been eliminated.
- Wrong applying of default database charset has been fixed.
- Data displaying errors in BLOB Editor have been fixed.
- Tabs were not renamed in Visual Database Designer. Fixed now.
- ENUM type was implemented incorrectly as function return type. Fixed now.
- Fixed the error of assigning permissions to objects having the '.' (dot) in their names.
- The function text was incorrectly formatted. Fixed now.
- The null date was copied to clipboard incorrectly. Fixed now.
- Many other improvements and bug-fixes.
- Fixed the critical error occurred while applying the filter in grid.
- There was an error when opening the 'Print Preview' dialog in Query Builder. Fixed now.
- The behavior of the Code Completion window appearing was enhanced.
- Sorting of fields in Table Editor has been fixed.
- On connection to the database using SSH the passphrase was asked twice. Fixed now.
- Fixed the child windows saving in the 'Floating Windows' mode.
- Duplicating of the table data using SSH-tunnel was incorrect. Fixed now.
- There were errors executing some queries containing specific date-functions. Fixed now.
- The constraints were not considered while exporting the data from SQL Editor. Fixed now.
- The 'Print Metadata' report name was added to support some PDF-printers.
- Lots of other improvements and bug-fixes.
- Generating of the table definition (DDL) has been fixed for tables having the dot (".") in their names.
- Opening of procedures for the users with restricted rigths has been fixed.
- There was a critical error when launching the program on the specific versions of Windows. Fixed now.
- The print preview window for the view was not opened. Fixed now.
- The size of the wizard windows has been fixed for the specific font sizes (DPI).
- The order of scripts addind fields to a table was incorrect. Fixed now.
- Displaying of dependencies in the Procedure Editor has been fixed.
- The cursor positioning in tab-delimited text has been fixed.
- Comparing of the AUTO_INCREMENT property for the tables is excluded now.
- Initialization of the DateTime parameters in the Procedure Debugger has been fixed.
- When transactions were enabled the data changes within procedures were not applied. Fixed now.
- The indices comparison has been fixed in Database Comparer.
- The import of unicode data from Excel (.xls) files has been fixed.
- Lots of other improvements and bug-fixes.
- Code completion window did not appear in some cases. Fixed now.
- Saving/restoring size of editors was fixed.
- The error occurred when objects were refreshed for the user with restricted permissions. Fixed now.
- Drawing of controls was incorrect when large fonts DPI was set. Fixed now.
- Some mutually exclusive options were applied. Fixed now.
- There were errors when saved grid levels were restored. Fixed now.
- Export of the 'date' fields to XLS was fixed.
- Incorrect logging of queries execution in SQL Editor was fixed.
- When the specific illegal dates were displayed the errors occurred. Fixed now.
- Some errors occurred when the program was launched in the 'Floating Windows' mode. Fixed now.
- The error occurred when the query was executed second time in modal Query Builder. Fixed now.
- Other improvements and bug-fixes.
- Added the possibility to restore databases from dump files using wizard.
- Added support of microseconds for TIME, DATETIME and TIMESTAMP data types in type editors and data grid.
- Data Export. Large amount of records is now exported without errors.
- Working with database with large amount of objects is significantly improved.
- Added the possibility to rename tables, procedures and functions directly in object editors.
- Added the possibility to set the defaults as CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP for the DATETIME type in the editor.
- ALTER TABLE ... RENAME INDEX statements are now used for renaming index instead DROP/CREATE (for MySQL version 5.7 and higher).
- Visual Database Designer. Page borders are now displayed on the diagram.
- SQL Editor. ‘Save and restore layout’ option did not work in the result grid in SQL Editor. Fixed now.
- Save settings wizard. SQL Editor queries were exported incorrectly. Fixed now.
- SQL Script. Script highlighting did not work properly for large scripts. Fixed now.
- Data Grid. Now transaction does not begin if it is not supported by a table which prevents the metadata from lock.
- Lots of other improvements and bug-fixes.
- The possibility to backup database with mysqldump appeared.
- Now the table editor for MariaDB servers supports such storage engines as PBXT, Aria, SphinxSE.
- Such privileges as TRIGGER, CREATE VIEW, SHOW VIEW were added to tables Grant manager.
- The data export speed increased.
- In Floating windows mode Visual Database Designer was not opened. Fixed now.
- The locale formats use for the table representation of data is fixed.
- When getting the trigger dependencies, the error occurred. Fixed now.
- When clearing the table, the freeze occurred. Fixed now.
- When editing scripts with long comments, the errors occurred. Fixed now.
- At times files from Excel, Access and CSV were imported incorrectly. Fixed now.
- The representation of large values of BIGINT type in grid view is fixed.
- Extract Database. Tiriggers are extracted at the end of the script now.
- When exporting data to Excel files, invalid characters appeared instead of spaces. Fixed now.
- The input of special Spanish characters is fixed.
- The support of increased system font appeared in table editor.
- When restricted users edited the procedures, error occurred. Fixed now.
- The results of queries with comments at the end were not represented. Fixed now.
- Lots of other improvements and bug-fixes.
- Added the possibility to update and edit procedures with limited rights to the "mysql.proc" table.
- Database Comparer tool. Implemented the comparison of all index properties.
- SQL Monitor. The "Log SQL Monitor events to file" option did not work. Fixed now.
- Tables on Unix-servers with different registers were displayed incorrectly. Fixed now.
- Indices Editor.
- The comment of an existing index could not be changed. Fixed now.
- When trying to change the primary index, an error occurred. Fixed now.
- Opening Instance Manager in the German localization caused the error. Fixed now.
- Field Editor. On some server versions when trying to remove the "Primary key" option, the field change script was generated incorrectly. Fixed now.
- Some other improvements and bugfixes.
- Added the possibility to update information regarding procedures and functions in the database system tables information_schema.
- Export as PHP Page wizard is improved:
- Database Comparer. The algorithm for generating scripts and calculating script sequence is improved.
- Duplicate Object. Now it is possible to copy with INSERT INTO ... SELECT FROM.
- The form of adding/ editing indexes is changed, added the support of index properties such as HASH, BTREE, SPATIAL, KEY_BLOCK_SIZE, PARSER, COMMENT.
- User Editor. Added the MAX_USER_CONNECTIONS property.
- Procedure and Function Editor. The form of editing options is added.
- Other improvements and bugfixes.
- Added the possibility to register a new database automatically after copying it with the Copy Database Wizard.
- User Manager. Added the possibility to filter by types of privileges.
- Dependency tree now parses the dependencies of the whole server.
- Added the possibility to clear the history of the input parameters.
- Server Properties. When viewing a list of processes, now it is possible to process a query associated with this process.
- Some other improvements and bug-fixes.
1. Added the possibility to debug procedures, functions, triggers and events.
2. Now it is possible to connect to databases using SSL certificates.
3. Added the possibility to connect through named pipes.
4. Added support of new objects: PARTITIONS, TABLESPACE, LOGFILE GROUP and SERVERS.
5. Added the possibility to compare databases (Database Comparer tool) that allows getting a SQL script for synchronizing database structure.
6. Database Registration Manager is added. It makes the process of registering and un-registering databases much faster.
7. Added the possibility to copy objects by groups in the DB Explorer by Drag And Drop.
8. Added support of MySQL invalid dates. Also it is now possible to set any date and time format manually.
9. Added the possibility to create procedures, views and functions based on the selected table (through the table menu).
10. Added the possibility to change table type for several tables at once.
11. Support of LOAD XML command and SET clause is added in the Load Data Wizard.
12. Added a new option for keeping connection in the Database Registration Info dialog - “Ping database every … seconds”.
13. Triggers in DB Explorer are now displayed in a separate branch.
14. Added the possibility to rename databases in DB Explorer and in the Database Properties dialog.
15. Added the possibility to disconnect from all connected databases at once.
16. Now it is possible to set shortcuts not only for SQL Editor commands, but also for other ones (Environment Options | Global Shortcuts).
17. Added the possibility to export data as PHP page - Export as PHP Page Wizard.
18. SQL Formatter now allows formatting DDL statements.
19. Added the possibility to create templates for new object names.
20. Added the history of procedure input parameters.
21. Some other minor improvements and bugfixes.
- Now the connection to the server is restored automatically if it is interrupted when using SSH tunnel.
- Grant Manager:
- Added the possibility to grant CREATE TRIGGER and DROP TRIGGER privileges.
- Grant Manager. Fixed an error connected with the erroneous display of grants like GRANT SELECT ON `with\_underscore`.*
- Now it is possible to view geometry fields in the BLOB Editor.
- Save settings. Added the possibility to save Favorite Queries.
- Fixed the error occurred during the repeated import of MS Office 2007 and Open Office files on Windows 7 32/64 bit.
- The first field was not exported during the export of fields list from data frame. Fixed now.
- The possibility to display Column Summary is added in the Data Grid.
- Data Export. Fixed the MS Access error - “Application uses a value of the wrong type" which occurred when exporting some TEXT fields.
- Some other improvements and bugfixes.
- The possibility to search in metadata is implemented
- Windows 7 support is added
- Procedure and Function Editors: now, when compiling a procedure/function, its privileges are automatically recreated
- Grid View: the Set to Now operation does not post data for newly created and edited records
- Procedure Editor: procedure values weren’t memorized upon procedure execution, if the procedure had a parameter of the BIGINT type. Fixed now
- Procedure Editor: execution of a procedure with a BIGINT parameter resulted in an error, if the parameter value was more than 2147483648. Fixed now
- Export as SQL Script Wizard: the program ignored table DDL generation when exporting a SQL script to SQL Server. Fixed now
- Export Data Wizard: exporting data to the ODF Spreadsheets format resulted in the ‘Cannot create basic structure’ error, if the program was running under Windows Vista 64. Fixed now
- Editing of the SET field could sometimes reset the default value. Fixed now
- The default value of the “BIT (1) DEFAULT ‘\0’” fields was identified incorrectly. Fixed now
- Field Editor: the default value of the TIMESTAMP fields with the “on update current_timestamp” option enabled wasn’t stored. Fixed now
- Other minor improvements and bug-fixes
- Table Editor: data filtration is now available when connecting through HTTP tunneling
- Table Editor: Unicode is now displayed properly in the DB Explorer
- Table Editor: partial support of OpenGIS fields is implemented
- Table Editor: disabling the 'Use dimension' option in fields of the Double type used to be ignored. Fixed now
- Copy Database: comment length restrictions for tables and fields are now taken into consideration when copying a database whose source and destination server versions differ
- Extract Database: with both 'Add DELIMITER' and 'Generate DROP IF EXISTS statements for objects' options enabled, the program used to generate an erroneous result script because of the wrong placement of the DROP statement delimiter. Fixed now
- Extract Database: database structure containing circular table dependencies used to be extracted improperly. Fixed now
- Extract Database: if the 'Record in block' option value is '1', comments before each extracted record will not be added
- Extract Database: if the Client Charset was set at 'Windows Charset', the SET NAMES statement used to get wrong charset. Fixed now
- Duplicate View: a view’s name remained unchanged in the result script. Fixed now
- Data Export: an attempt to open a file exported to the Excel 2007 format failed with the 'Excel found unreadable content in libri.xlsx' error. Fixed now
- Trigger View: if a user did not have the SELECT FROM permission for the mysql.user table then an attempt to edit a trigger failed with an error. Fixed now
- Procedure Editor: the procedure used to be edited improperly if its body contained a 'main: Begin … END main' marker. Fixed now
- Procedure Editor: the OUT parameter values used to be displayed as NULL when executing a procedure
- SQL Editor: occasionally Ctrl+C and Ctrl+V shortcuts stopped working. Fixed now
- In some cases the 'Restore Desktop on connection' option did not work. Fixed now
- Other minor improvements and bug-fixes
- DB Explorer: added the Search Panel for quick search within the tree
- DB Explorer: Window list is now available in the DB Explorer area, the corresponding tab has been added
- Added UTF8 support for metadata: procedures, functions and triggers containing national characters are now compiled correctly, irrespective of the operating system settings; national characters are also displayed correctly in ENUM fields now
- Now it is possible to restore lost database connection automatically. The corresponding 'Automatically reconnect when connection is lost' option is added to the Options section of the Database Registration Info dialog
- Added the Find Option tool which allows one to find the required option in the scope of all program settings, by a word or an expression from the option title
- Table Editor: support for tables of the FEDERATED type is implemented
- Extract Database: increased running speed for large databases
- Extract Database: it is now possible to add the delimiter directives upon extraction of procedures and triggers. The corresponding 'Add DELIMITER statements for stored routines and triggers' option is available at the Customizing script options step of the wizard
- Extract Database: adding comments is now optional (the 'Insert comments' option is added to the Customizing script options step of the wizard)
- Import Data Wizard: table fields can now be mapped to the text columns automatically
- Import Data Wizard: now it is possible to specify encoding for imported TXT and CSV files
- Import Data Wizard: while importing from DBF, ANSI or OEM selection did not affect the result. Fixed now
- Visual Database Designer: it is now possible to display the foreign key names in the diagram, the corresponding 'Draw FOREIGN KEY name' option is added to the Diagram Options dialog and to the Visual Database Designer page of the Environment Options dialog
- Visual Database Designer: added the 'Materialize virtual relation' function that can be used to create a Foreign key on the basis of a virtual relation
- Visual Database Designer: the size of table fields is now displayed in the diagram
- Visual Database Designer: when deleting foreign keys, you are now prompted for confirmation
- Restore Tables: now you can manually input the names of tables that do not exist in the database to restore
- Export Data Wizard: when exporting the result of a query, it is possible to add the text of the query to the header and/or to the footer of the output file (the corresponding 'Add to Header'/'Add to Footer' buttons are added to the Setting header and footer step)
- Export Data Wizard: the 'Out of memory' error used to occur when exporting a large amount of records (more than 1000000). Fixed now
- Trigger Editor: it is now possible to add and edit the DEFINER for triggers
- Trigger Editor: code completion did not work after a table name and the dot (.) character. Fixed now
- The unsigned bigint and unsigned int field values exceeding 2147483647 are displayed and edited correctly now
- Form View: zero date (0000-00-00) is displayed and edited correctly now
- Grid View / Form View: now it is possible to edit time within the entire range supported by MySQL: from '-838:59:59' to '838:59:59'. For this purpose one should select the 'hhh:nn:ss' format for displaying time (the Grid | Color & Formats section of the Environment Options dialog)
- SQL Editor: with the 'Group undo' option enabled, rollback is performed more logically
- SQL Editor: improved the Code Folding function for complex queries
- SQL Editor: the editor now works considerably faster; such features as syntax highlight, object hyperlinks are not disabled while processing large scripts
- Procedure Editor: an error occurred upon compilation of procedures with names longer than 60 characters. Fixed now
- Save Data Wizard: the templates did not work. Fixed now
- 'Execute from file' did not work for UNICODE files. Fixed now
- Lots of other minor improvements and bug-fixes
- Building the dependencies under the corresponding editor tabs is improved
- SQL Editor: the Code Completion feature is significantly improved. Highlight of MySQL 6.0 reserved words is implemented
- When setting the Korean locale in Windows, character data in tables displayed improperly sometimes. Fixed now
- Create Database Wizard: on attempt to set the UTF8 at the Character Set field the error used to occur. Fixed now
- View Editor: in some rare cases, when selecting the 'Edit with Query Builder' item, the abnormal program termination used to take place. Fixed now
- Extract Database: when extracting procedures and functions, empty comments used to be processed improperly in some cases. Fixed now
- German localization improved
- Russian localization added
- Polish localization added
- Other minor improvements and bug-fixes
- SQL Editor: added a hint listing parameters for added procedures and functions. The hint can be called manually by using the Ctrl+Shift+Space shortcut
- Procedure Editor, Function Editor: added a capability to maximize the SQL definition editor window
- BLOB Editor now allows one to browse TEXT fields
- In many object lists the ability to perform incremental search appeared
- BLOB Editor could not be used for text fields. Fixed now
- Considerably increased the runtime speed of the Extract Database tool
- Updated all wizards: added confirmation prompts upon pressing the 'Finish' button again
- When connected to a database with HTTP tunneling used, there was an error in data representation. Fixed now
- Fixed the "Illegal mix of collation" error that occurred upon execution of some SQL commands on MySQL 4.1 - 5.0
- Print Metadata: an error occurred on attempt to print metadata with "Letter" paper size specified. Fixed now
- SQL Script: execution of a sequence of statements like OPTIMIZE TABLE table1, table2; FLUSH TABLES; caused the "out of sync" error. Fixed now
- Services | Optimize tables: there was an error on attempt to optimize InnoDB tables on MySQL 5.0. Fixed now
- Extract Database: with the "Login prompt before connection" option set, an error occurred on attempt to extract data. Fixed now
- Corrected program registration behavior: registration information of the older version (SQL Manager 2005) is not erased upon SQL Manager 2007 registration
- Fixed a bug when the SQL Manager Direct feature could not be activated in the Lite version of the program
- SQL Editor: quotation marks could not be typed with "USA-International" and "DA - Danish" keyboard layout used. Fixed now
- SQL Editor: an opened file was not saved upon clicking "Save to file". Fixed now
- SQL Editor: in some cases the fields list did not appear for table alias. Fixed now
- Added a new shortcut - Ctrl+W that can be used to close the active window
- Several minor improvements and bug-fixes
Basic features:
- Support of UTF8 data in SQL Editor, Query Builder, Grid View, Data Export/Import Wizards
- Now you can continue working with SQL Manager while a query is being executed in SQL Editor or Query Builder or while table or view data are being loaded in the editor. A query taking too long to execute can be aborted
- All wizards, including Data Export/Import, DB Extract, Copy DB wizards can now be run in the background mode, so that you could continue working with the program
- New improved SQL Editor of the Visual Studio 2005 kind with the Code folding function and UNICODE support
- Improved Import Data Wizard now allows one to import data up to 10 times faster. New import formats have been added: HTML, XML Document, Open Document Format (OpenOffice), Open XML Format (MS Word 2007, MS Excel 2007).
- Improved Copy Database Wizard now works faster and allows to copy databases and db objects between different server versions. Objects dependencies are now taken into account during the copy process
- Improved Extract DB Wizard works faster, allows to set the server version to generate the script for, and considers objects dependencies
- Support of queries returning Multiple Result sets
- Common SQL commands can now be generated from DB Explorer (Script to SQL Editor, Script to Clipboard). Now you can easily generate such SQL commands as CREATE, ALTER, DROP, SELECT etc for each database object
- Now you can save your queries within the Favorite Queries folder in DB Explorer; these queries can be stored either locally in the registry (nobody but you will have access to them) or in a special database table (then all or some of your db users will have access to it)
- Improved Visual Database Designer: new objects like comments and virtual relations added. Now it is possible to include Procedures, Functions and Views in the diagram. One can choose whether only object names or fields and parameters should be displayed, too
- Improved Export Data Wizard now works faster. New export formats have been added: XML Document, Open Document Format (OpenOffice), Open XML Format (MS Word 2007, MS Excel 2007).
- New Dependency Tree tool allows to view dependencies between database objects
- Improved the Server Properties tool: Variables can be divided into groups, System Variables can be modified. Server information, InnoDB Status and General Query Log are displayed
- The Database Properties window has been added, which displays database options and allows to change them, and also displays summary information about database size and its objects
- Improved Table Editor: now it is possible to view/change table properties and view Table Status on a new tab
- Connection parameters as well as Data options that impact the database performance speed have been moved to Database Registration Info window and can be set individually for each database for maximum convenience
- In DB Explorer hosts are now named in accordance with the selected connection type (SSH or HTTP tunneling)
- SSH tunneling now allows to set key
- SQL Script: ability to execute selected statements and statements under cursor added
- Improved the report building system
- Lots of other improvements and bug-fixes
and more...
- Added support for Scheduled Events that appeared in MySQL ver. 5.1.6
- Export as SQL Script: now you can choose for which DBMS server the script should be generated
- SQL Editor: added the opportunity to rename and move the tabs
- SQL Editor: the time of query execution now is shown in the format hh:mm:ss
- SQL Editor: sometimes the Range Check Error emerged in SQL Editor when executing a query. Fixed now
- SQL Editor: added opportunity to import data in a query if the latter supports data insertion
- DB Explorer: the 'Add to Projects' function is added. Now it is possible to add objects to the projects not only by dragging them, but also by choosing them in a form opened with the help of this command
- HTTP tunnel can now work through HTTPS protocol
- Now there is no need to connect to a database in DB Explorer when using Services
- Added support of NDBCluster and BlackHole storage engines
- The character sets and collations list for Create Database Wizard has been updated
- The size and location of new objects editor windows (new procedure, new function, etc.) are now saved
- Grid View: the 'Expand All' and 'Collapse All' options are added to the context menu
- The control location in toolbars remains now after a newer version of the program is installed. One can reset toolbars and menus using the corresponding command in the Windows menu or the button in the Environment Options dialog
- Visual Database Designer: the context menu style did not change in correspondence with the current visual scheme. Fixed now
- Fixed the considerable processor loading (CPU usage 90%) when using the program together with some other applications
- Definitions for views and triggers were truncated to 8K. Fixed now
- Table Editor: the truncate table function works correctly now
- Sum() type calculated fields were considered as string in queries. Fixed now
- Wrong formatting of the view body with fields like concat(ucase(`staff`.`pref_surname`), ', ', `staff`.`pref_name`) AS `person`
- Unique keys were refreshed wrong for the fields, which resulted in an error during fields reorder. Fixed now
- Fixed the error that appeared while editing indexes like UNIQUE KEY `name` (`surname`(5),`name`,`patronymic`)
- When adding a new report through Create Report Wizard, an error emerged in some server versions. Fixed now
- Fixed the error that appeared while getting default fields values for BIT fields
- Function Editor returned NULL result as empty string. Fixed now
- Window size and location were not saved. Fixed now
- Database Registration Info: while saving data, the uniqueness of database aliases was not checked. Fixed now
- Grouping worked incorrectly in Table Editor with certain settings used. Fixed now
- Access violation error emerged when setting a filter for the text field. Fixed now
- The 'Help' item in Report Designer did not work. Fixed now
- Some non-Latin characters were shown incorrectly in the EMS Direct window. Fixed now
- The authentication dialog prompted twice on attempt to open the Server Properties tool. Fixed now
- Naming Rules were not saved after closing the program. Fixed now
- The Restore Tables service gave an error when choosing Non-registered database. Fixed now
- Query Builder: after query text editing on the Edit and Create View tabs, it used the old query from the Builder tab. Fixed now
- Other minor improvements and bug-fixes
- SQL Editor: Key Mapping is implemented to set the shortcuts for various commands/operations according to your needs
- Query Builder: support of queries containing the tables from different databases hosted on one server is implemented
- Create Table: added comment support for tables.
- Server Properties: now connection with SSH and HTTP tunnels is supported
- New option "Write only successfully executed SQL statements to log" (Database Registration Info -> Logs) is added
- SQL Editor: opportunity to execute statement under cursor is added
- SQL Editor: the bug with division by zero upon using Explain Query for an incorrect query is fixed
- Extract Database: added the "Use tables selected on the previous step" option to extract data from the tables selected for extracting the structure
- Extract Database: the progress indicator now displays the number of extracted data for tables
- Extract Database: fixed the bug with extracting the procedures and functions when the user has no rights for viewing them
- Extract Database: now the generated script inserts 0 values for autoincrement fields correctly
- Copy Database: added the "Use tables selected on the previous step" option to copy data from the tables selected for copying the structure
- Copy Database: the progress indicator now displays the number of copied data for tables
- Copy Database: added the "Use compressed protocol" option
- Create Database Wizard: now the created database name is quoted
- Data Import: now with the transactions disabled in the "Commit changes manually" mode the proper transaction action (Commit or Rollback) is requested after import
- Import Data: now it is possible to resize the dialog window
- Import Data: setting of Generator Value and Constant Value was ignored when defining format of the imported fields. Fixed now
- Import Data: when defining a part of fields for import, empty values were inserted into the rest fields, which resulted in not applying the default values set for the fields in the table. Fixed now
- Procedure Editor: added support of the constructions in procedure bodies like: procd:BEGIN ... END procd
- Procedure Editor: fixed the bug with creating a procedure with the parameters like: param2 ENUM('a','b','c')
- The function parameters were not updated if the user did not have rights for mysql.proc. Fixed now
- Now the Optimize Tables service for InnoDB tables on MySQL 5.x works correctly
- Fixed the bug with getting default values for the BIT(n) fields
- SQL Editor: the 'Next Bookmark', 'Previous Bookmark' commands are added
- SQL Editor: in some rare cases the text from the beginning of the line was deleted when using the Code Completion tool with option "Trim trailing spaces" enabled. Fixed now
- Visual Database Designer: the Drop Table context menu item worked incorrectly if the field was highlighted, but the table was not. Fixed now
- SQL Script: now confirmation of aborting the script execution is added
- DB Explorer: the context menu did not hide when switching to another application. Fixed now
- Table Editor, View Editor: The lines exceeding 32 symbols were cut when exporting lists of subobjects. Fixed now
- Other minor improvements and bug-fixes
- SQL Formatter: formats SELECT, INSERT, UPDATE, DELETE queries (available in the context menu of SQL Editor)
- SQL Script: now the process of script executing is shown and there is an opportunity to stop this process
- SQL Script: now you can open several windows
- SQL Script: when option 'Enable parsing' was enabled, editing a large script (> 10 M) caused hanging. Fixed now
- Now you can define Host connection info in User Manager, Grant Manager and SQL Script when setting up a connection. Now these tools also work correctly when using HTTP and SSH tunneling
- SQL Editor: option 'Don't save queries automatically for the next session' is added. When the option is enabled, you can create and save queries for each database that will be read automatically when running SQL Editor. When the option is disabled, queries created during the last session are saved
- SQL Editor: now there are no limitations for the size of edited scripts
- Supporting data of type BOOLEAN and BIT(M) is added
- Table truncation can now be performed for several selected tables in DB Explorer
- Query Builder: saves queries between sessions
- Table Editor: now the 'Refresh' button can show changes committed by other transactions
- Table Editor: reorder fields now work correctly for InnoBD tables containing foreign keys
- Grid View: now when executed, such commands as 'Set to Empty String' and the like do not post data to the table
- Grid View: now when pasting records from the clipboard, you can set correspondences between clipboard columns and query columns
- Grid View: 'Copy to clipboard' now uses tabs as delimiters (for pasting into Excel)
- Form View: Memo fields editor is extended (can be customized in the Grid | Advanced section of the Environment Options dialog)
- Extract Database: option 'Generate USE statement' is added
- Export Data Wizard: the 'Allow captions' option added
- Export Data Wizard: the 'Finish' button is available at all steps
- Procedure Editor: now shows values of output parameters
- Now you can call the Table Properties window for the selected table in DB Explorer using the context menu or the 'Object Properties' button on the Toolbar
- Blob View: the 'Word Wrap' option is added for text (available in the context menu)
- Now you can open Grant Manager without connecting to a database
- Trigger Editor: Code Completion shows the list of table fields after OLD. and NEW. keywords
- The 'Binary flag for char and varchar fields' option is supported (for MySQL versions 3.23-4.0)
- Database options used to be saved at the end of working session. Now changes are saved immediately. In case of emergency shutdown of the program or system crash the changes made during the working session are saved too
- Report Designer and Report Editor: added support for HTTP connection to database
- Field Editor: saves the 'Size' value when changing the Char type to Varchar and vice versa
- Duplicate Object, modal Query Builder: The size of these windows can now be regulated
- It took long to close Table Editor when the number of tables in the database exceeded 1000. Fixed now
- With 'SQL sort mode' option enabled sorting by fields of BIGINT type was performed incorrectly. Fixed now
- In Code Completion fields for tables and views were not displayed. Fixed now
- Print Metadata: the 'Show all objects' button did not work. Fixed now
- Procedure Editor: clicking on Execute resulted in executing the query twice. Fixed now
- View Editor: on creating a new view with capital letters in its name an error occurred. Fixed now
- Decimal type (10,2) was displayed as Decimal(10,0) in case of HTTP connection. Fixed now
- When updating functions and procedures in DB Explorer an error occurred if the user had no rights to access ‘mysql.proc’. Fixed now
- Other minor improvements and bug-fixes
- Triggers support implemented
- Visual Query Builder: support of subqueries and UNION joins
- Visual Query Builder: ability to create INSERT/UPDATE/DELETE statements
- Now the program notifies itself of new versions released and updates the needed files when SQL Manager Direct is enabled to automatic update
- Now you can add comments for table columns
- Extract Database: the 'Set Names' option implemented
- Extract Database: the 'Drop If Exists' option for views, procedures ad functions implemented
- The Truncate Table option now available from the table context menu in DB Explorer
- Ability to edit data using Latin2 charset
- SQL Script: now comments like /*!40102 */ are taken into consideration while executing SQL Scripts on different server versions
- Now you can define database and table name when creating Foreign Key from the Foreign Key Editor
- Ability to rename foreign keys is implemented now
- Grid View: fixed a bug with incorrect setting default value for timestamp fields if it equal to current_timestamp
- SQL Editor: fixed a bug with lose of SQL statements formatting when creating procedures, functions and triggers
- Now zero date values ('0000-00-00') are shown correctly in the Grid View and the Export as SQL Script tools
- Copy Database: fixed a bug with creating new database
- Now DB Explorer keeps the order of object type nodes when Sort By Aliases option is set
- Visual Database Designer: now the reverse engineering function correctly recognizes foreign keys for the tables named using uppercase symbols when lower_case_table_names=0
- Field Editor: fixed a bug with ignoring of the Use Dimension option
- Grid View: data were displayed incorrectly for the fields of types like float(12,2) when working through HTTP Tunneling
- Now the Table Details -> Show DDL option works correctly
- Other minor improvements and bug-fixes
- 'Client Charset' option works for HTTP Tunneling connections now
- Added ability to rename Views, Procedures and Functions
- New 'SQL Filter' and 'SQL Sort' options added. Use these options when limited number of records is fetched in the grid. They allow filtering and sorting records through all the dataset records, instead of only fetched ones
- 'Sort by Aliases' option is now considered for all lists of registered databases in the program
- Modal Visual Query Builder form size is variable now
- A new option added to the Tools | Table Editor page of the Environment Options dialog: "Default storage engine for new tables"
- Incremental Search in field lists implemented
- Table Editor: now only table types supported by server are shown
- When 'Enable floating toolbars' option was on it was possible to undock main menu, but it was impossible to get it back. Fixed now
- Fixed an error with reordering fields: data were copied incorrectly
- Fixed the bug with displaying wrong size for unsigned decimal fields
- 'Show Table Details' setting to 'DDL' now works correctly
- Now you can disable Delete record(s) confirmation
- SQL Editor: fixed the bug with positioning cursor when option "Show result for each query" is enabled
- Fixed the bug with displaying unsigned BIGINT fields having values greater than 9223372036854775807
- Fixed the bug with modifying default TIMESTAMP field value to 'CURRENT_TIMESTAMP'
- MySQL 5.0.6 support
- Procedure Editor: added ability to execute stored procedures and functions
- Code Insight: now supports aliases, shows field types and view fields
- Table Editor: the Truncate Table feature is added
- Query Builder: implemented ability to select types of objects shown in the list and to sort them
- Query Builder: now it is possible to create view based on the query
- Save Data Wizard added. It complements Load Data Wizard and uses 'SELECT INTO ... OUTFILE' MySQL command for quick exporting table data or query to a text file
- Now you can edit view in the View Editor using Query Builder tool
- SQL Editor: added ability to show query results on the same tab with the query text
- Grant Manager: added ability to rename users
- Grant Manager: stored procedures and functions support
- Grant Manager: increased performance
- Added ability to check views within Check Tables Wizard
- BLOB Editor: now you can view and edit blob fields with no need to open a separate window
- BLOB Editor: ability to print memo and html BLOB data added
- The HTML Report tool has been replaced with a more user-friendly HTML Report Wizard
- DB Explorer: now you can hide certain types of objects
- Implemented ability to commit or rollback current transaction. You can switch it off in the Environment Options dialog
- Fixed bugs with reordering columns
- BINARY, VARBINARY, BIT field types support
- SQL Editor: the Bug with executing CALL PROCEDURE command: "SELECT in a stored procedure must have INTO" is fixed now
- Data Import from Access: fixed a bug when loading from a template: fields map was not loaded
- Import Data Wizard and Load Data Wizard: after loading of large amount of records, the program hung for a while. Fixed now
- Other minor improvements and bug-fixes
- Import Data Wizard: added Commit options
- Added a new Grid option - 'Use compact view for TEXT fields'
- DB Explorer: now MySQL Manager remembers 'Sort by Aliases' option
- Create table window: now it is possible to switch between cells in fields list using Tab key
- Now it is possible to modify procedures and functions for MySQL 5.0.3
- Sometimes when connecting to a database through SSH in DB Explorer an exception arose. Fixed now
- Fixed the bug with running queries on servers with specific versions like "3.23.23-nt-20050403"
- Visual Database Designer: fixed a bug with opening previously saved diagram
- Server Properties: 'Kill process' now works correctly
- Import Data Wizard: now shows the number of committed records correctly
- Fixed the Access Violation error appeared when trying to add a field to the new table
- An error arose when switching to BLOB Editor after closing the window from which it was started. Fixed now
- Visual Query Builder: now parsing errors are shown only when switching to the Builder tab
- Fixed an error with importing from MS Excel and using the case adjustment functions
- Import Data Wizard: when importing only a part of fields, the others were set to NULL
- Other minor improvements and bug-fixes
- Connection character sets support. Now you can work with databases in different charsets, irrespectively of server defaults
- Field charsets and collations support implemented
- MySQL Manager now supports servers using long user names (more than 16 characters long)
- The Truncate Tables service added: now you can remove data from tables quickly
- Improved Duplicate Object Wizard
- Improved Export as SQL Script Wizard (former Export as INSERT dialog)
- Added support for VARBINARY and BINARY data types
- Romanian localization added
- Now Create Database Wizard shows detailed error messages while creating a database
- Fixed the bug with impossibility to switch between windows using Windows Bar in some cases
- Fixed some minor bugs in DB Explorer
- It was impossible to filter grid content while in Load Visible Rows mode. Fixed now
- Fixed the bug with inability to set field size when changing its type from TEXT to VARCHAR
- Other minor improvements and bug-fixes
Basic features:
Latest MySQL versions support
- Compatible with any MySQL versions from 3.23 to 5.02
- Views support in MySQL 5.01
- Stored Procedures and Functions support in MySQL 5.0
- New MySQL 5.0 Authentication Protocol
- MySQL 4.x User Privilege Extensions
- Charsets and collations support for databases and tables
Significantly improved user interface
- Office 11 and Windows XP visual schemes support
- New well-described Wizard System
- New useful Navigation bars in most of the program windows
- New Windows Toolbar to switch between windows, like Windows Task Bar
Improved Database Explorer
- Creating tabs for any tree node to access it in one-click
- Working with multiple selected objects at a time
- Much more convenient toolbar and context menu
Completely remade Visual Database Designer
- Obvious new look
- Two diagram notations (IDEF1x and IE)
- Improved diagram navigation
- Several pages in one diagram to divide diagram into different subject areas
- A lot of visual customization options
New powerful data management tools
- Plenty of useful tools such as data grouping, summarizing, fast searching and filtering
- Master-Detail View to work with two linked tables at the same time
- Table and Card Views to see data the way you like
- Ability to copy and paste selected records
- Advanced printing system
- Fully customizable interface
New connection options
- Access to MySQL server through HTTP protocol in case of Internet access through HTTP proxy only, or if the server does not allow direct connections to MySQL
Improved report management
- The new Create Report Wizard allows you to create a simple report in a few clicks
- Managing reports in the same way as if it were a database object: accessing reports directly through the DB Explorer tree
and more...
- We have improved the compatibility with different Linux versions
- SSL connections are supported and do not require installed openssl now
- Fixed the problem with enumerated fields management
- We have added the possibility to enter a unix-socket instead of port number like "/tmp/mysql.sock", i.e. possibility to connect to the local server with disabled TCP/IP
- We have implemented an installer. The program is distributed as a sh-script now instead of archives
- Several bugfixes in design: displaced fonts, wrong control sizes, invisible combo box captions, etc.
- Closing the help file often caused the program hang-up. Fixed now
- The majority of open/save dialogs did not show files due to the incorrect filters. The issue is resolved
- We have significantly improved the usability of .txt files importing page
- Fixed the bug with SQL-Monitor. Now it works correctly after reopening
- Several serious errors in print preview window are fixed now
- Fixed the issue with managing the thread-safe table types on some server versions
- A number of minor improvements and corrections
- We have implemented an ability to create InnoDB tables in MySQL 4.1.3
- Duplicate Table: with this version you can copy the table data as well as the table structure
- Print Data View: now you can customize column widths using the new dialog that is accessible through the Tune Column Widths button on the toolbar of the Print View tab
- Reports: with this version you can save your reports to XLS, RTF, HTML, JPEG, BMP, and TIFF files. We have added the new save filters for this purpose
- Print Data View: now the program saves page settings. You can disable this feature using the corresponding option on the Reports tab of the Environment Options dialog
- Print Data View: now the program displays the table name on each page of the report
- Export Data Wizard: fixed a bug that appeared when exporting data to CSV files
- Import Data Wizard: fixed a bug that appeared when importing data from Excel files
- Create Table Wizard: an error occured when creating table with default values of the first field. Fixed now
- Fixed a bug that appeared when changing fonts for the interface elements
- DB Explorer/Duplicate Object: fixed a bug that appeared when trying to duplicate an object if the program established connection with two database at once
- Some small improvements and corrections
- With this version you can work with MySQL server 4.1.1 or higher
- Fixed a bug that caused an error when working with SSH client
- Export to Excel: now you can export your data into any cell of the Excel spreadsheet
- Export to Excel: a possibility of creating merged cells is added
- Export to Excel: the "Auto calculate column width" option is added
- Export to Excel: added a possibility of defining background images for an Excel sheet
- HTML Report: you can now edit the CSS table
- HTML Report: a bug with displaying index columns is fixed
- Import Data Wizard: added a possibility of defining an error log file name
- Import Data Wizard: the "Rewrite error log file" option is added
- Import Data Wizard: the "Show error log" option works correctly now
- Import from Access: fixed a bug with displaying table list
- SQL Editor: changed hot keys for deleting query (Ctrl-R) with Ctrl-Del and for deleting all history (Shift-Ctrl-R) with Shift-Ctrl-Del to avoid a conflict with the Replace text function called from the context menu
- Import from Excel: fixed a bug with selecting ranges
- Now the Query Builder saves table size, position and expanded property in the builder area
- Fixed a bug with parsing queries such as: SELECT ... FROM MyTable INNER JOIN MyTable Alias1 ON (MyTable.Id = Alias1.Id) INNER JOIN MyTable Alias2 ON (Alias1.Id = Alias2.Id)
- Added the MySQL Server v4.1 support to MySQL Manager. Starting from this version MySQL Manager allows you to connect to MySQL 4.1 using its authentication protocol, so no more client incompatibility messages are going to appear
- Added a possibility to disable the separated thread creation for each data/result view in tables and SQL editors. This may be necessary if maximum allowed connection limit is too low
- The foreign key checks can be disabled now while transferring databases with MySQL Manager
- The SQL Monitor operation list now includes the SHOW command as well
- The Print View of the Table Editor Data tab allows you to save current report as CSV, TXT, RTF or HTML file now
- The Unsigned flag is available for the FLOAT and DOUBLE fields on MySQL server 4.0.2 or higher
- Now MySQL Manager also supports foreign keys for the MySQL server versions from 3.23.44 to 3.23.50, in which a foreign key definition is not generated within a table definition returned by the SHOW CREATE TABLE command
- Fixed a bug with the incorrect BIGINT value displaying in the query result if the field has an alias in the query text
- Fixed a bug with the incorrect fields order in the INSERT statement generated by the Export as Insert dialog in some cases
- Fixed a bug with the impossibility to drop a foreign key from a list containing only one foreign key
- Fixed a bug with an invalid value displaying after editing a TIMESTAMP field in the Grid View
- Fixed a bug in the Extract Metadata Wizard with generating the incorrect order of tables containing foreign keys
- Fixed a bug with the impossibility to set a field as a primary key in the Visual Database Designer diagram
- Fixed a bug with transferring binary data
- Some small improvements and corrections
- Added a possibility to save the Visual Database Designer diagrams as graphical images
- Now SQL Editor and Visual Query Builder support query parameters
- Data View: we have added a possibility to set filters for the Grid View
- Added a possibility to forward a local port to the MySQL server located on a different from the SSH host
- Grant Manager provides now two new menu items: 'Grant All on All' and 'Revoke All on All'
- The Tools | Table section of the Environment Options dialog provides the new "Do not retrieve record count for a table" option. Enable this option for not to retrieve record count, as this can take a long time for large InnoDB tables
- The Visual Database Designer allows dropping table fields now
- Fixed a bug with granting options on objects with long (> 31 chars) names in Grant Manager
- Fixed a bug with quick filtering in the Grid View
- Parsing the RIGHT JOIN clause in the Visual Query Builder works correctly now
- Fixed a bug with showing foreign keys for tables having keywords as names
- Identifiers appearing in the IN (..) clause are parsed correctly by the Visual Query Builder now
- Errors with exporting and importing BIGINT values are fixed
- Fixed a bug with dropping indices from the Table Editor Object Explorer
- Some small improvements and corrections
- Added the foreign key support for InnoDB tables
- Table information in HTML Report includes foreign keys now
- DataFrame: the popup menu item SetFilter works correctly now
- We've added a possibility of integration between other EMS HiTech products and MySQL Manager
- Transfer Database Wizard is added. Use this wizard to transfer database structure and/or table data to different hosts
- Added a possibility to define a browser type to use for viewing help files, HTML Report and other pages, called from MySQL Manager
- Several minor improvements and corrections
- Internal SSH client was implemented in MySQL Manager. Now it is possible to connect to a remote MySQL server using local port forwarding through the SSH (Secure SHell) tunnel
- A possibility of dropping/editing the foreign keys was added
- Hungarian localization of the program interface was included in the installation package
- A possibility to specify default directory for HTML Report files was added for each database
- Index definition doesn't appear in the CREATE TABLE statement generated by the Export As INSERT dialog, if a field included to the index is not selected for exporting
- Fixed a bug with editing items of the To-Do List. A new item does not appear after successful editing anymore
- Fixed a bug with BLOB fields truncating during the import data process
- Fixed a bug with extracting float values with the Extract Metadata Wizard if system defined decimal separator is different from '.'
- Fixed a bug with loading diagrams to the Visual Database Designer, if some objects included to the diagram have been deleted from the database previously
- Fixed a bug with executing (SELECT ...) UNION (SELECT ...) statements in SQL Editor
- Fixed a bug with the 'CONTINUE record missing' error while importing data from some Excel files
- Fixed a bug with loading templates to the Export Data dialog
- Default directories for exporting/importing data (*) and extrating metadata specified on the Directories tab of the Database Registration Info dialog are used properly now
- Some small improvements and corrections
- Added Keyboard Templates to MySQL Manager options
- Now you can define the Qt style using the Environment Options dialog
- Hot Keys work correctly now
- DB Explorer: the "Add to project" dialog is improved. Now you can add, delete or modify folders or subfolders of the project within this dialog
- Import Data Wizard: added a possibility to log the SQL statements executed during the import process. Check the "Enable SQL Log" option and set the name of the result sql file to save all import operations as SQL script
- Import Data Wizard: now you can save the error log to file
- The Database | New Object and Database | Duplicate Object menu items work correctly now
- Two buttons are added to the tool bar. You can use this buttons to create new or show last table or UDF
- The 'Environment Options', 'Editor Options' and 'Keyboard Templates' buttons are added to the main toolbar
- We have placed a button for printing metadata on the Table Editor toolbar
- Several minor improvements and corrections
- Implemented a new tool - Transfer Database Wizard: now you can easily transfer one database's metadata and data to another as a whole or partially
- Visual Database Designer: added a possibility to extract metadata for the current diagram
- Import Data Wizard: now you can log all the SQL commands executed during the import process into a file
- Added a possibility to hide the explorer window in all editors
- Import Data Wizard: the import process uses much less memory by calling the SELECT ... LIMIT 0 statement every time the wizard commits changes. Import speed is also significantly improved especially for large source files
- Fixed a bug with impossibility to specify NULL as a default value for the ENUM type
- Extract Metadata Wizard restores the data table list from the template correctly now
- Export Data dialog: data exported to MS Access table started to print even if the corresponding option was unchecked. Fixed now
- Fixed a bug with impossibility to close all database windows by choosing the corresponding menu item from the window list
- Fixed a bug with the incorrect field order in index definition when all the index fields were selected at once
- Fixed a bug with incorrect representation of the default values for the ENUM type if its items contain spaces
- The UPDATE or INSERT mode of the Import Data Wizard imports data properly now
- Fixed a bug with saving table comments containing apostrophe characters
- The 'Command out of sync' error doesn't appear after executing the EXPLAIN statement in SQL Editor anymore, and the Results tab displays correctly after executing this statement
- Fixed a bug with parsing SELECT statements containing a YEAR function within the Visual Query Builder
- Fixed a bug with identifying the TEXT type as SET with MySQL 4.1
- Some small improvements and corrections
- A possibility to select data retrieving method was added. There are two methods: retrieve a complete result set to the client (recommended for small result sets) and initiate a row-by-row result set retrieval (recommended for large result sets)
- New "Keep connection alive" option was added to the Database Registration Info dialog
- Export Data dialog: a possibility of multi-file export was added to HTML options
- Data View: columns in Print View tune their widths in accordance with column widths in Grid View
- A possibility to define indices necessary for a foreign key during its creation process was added
- Visual Database Designer: creation of links is not allowed for any table type except InnoDB now
- Page options were added to the PDF Options page of the Export Data dialog
- The "Duplicate key entry" error doesn't appear on every key violation during import data process
- Fixed a bug with minimizing MySQL Manager after it has been closed in its minimized state previously
- Fixed a bug with editing BIGINT values in Grid View
- Fixed a bug with encoding data in Grid View accordingly to the Database Font Charset option in the Database Registration Info dialog
- Fixed a bug with Access Violation error after disconnecting from a database with SQL Editor opened
- Fixed a bug with error occurrence while refreshing data in Grid View for a table that contains a lot of BLOB fields
- Some small improvements and corrections
- Export Data Dialog: export to PDF added. Now you can export data to one of the most popular document formats as well as to the other supported formats
- Export Data Dialog - export to HTML: a possibility of customizing navigation links for multi-file export and a possibility to define a background picture for the result table added
- Import Data Wizard: import modes are implemented - now you can define an action to be executed with the concurrent records in the source file and the target table
- Import Data Wizard: added a possibility of defining a way to add data to the destination table - insert or append
- Several minor improvements and corrections
- Grant Manager and User Manager were modified in compliance with MySQL 4.0.x privilege system. Now all the privileges provided by MySQL 4.0.x are supported (available for MySQL v4.0.8 and higher only)
- Import Data Wizard: a possibility of defining the import mode was added
- Visual Query Builder: a possibility of diagram saving/loading was added
- Data View: a possibility to enable/disable multiselection in the Grid View was added
- The "Autoconnect On Startup" option was added to the Database Registration Info dialog
- The "Set Defaults To All Child Windows" item was added to the Windows menu
- The "Always Open the Fields Tab" option was added to the Tools | Table section of the Environment Options dialog
- If the Show Hosts option is enabled, databases are grouped by hosts now in the database lists of all program tools, such as SQL Editor, Table Editor and others
- Dropping a field or an index requires confirmation now
- Fixed a bug with using the AltGr key for typing characters in editors (SQL Editor, SQL Script)
- Fixed a bug with getting wrong result with the 'SELECT @var' query execution after the 'SET @var=' query one in SQL Editor
- Fixed a bug with DATE and DATETIME field values extraction using the Extract Metadata Wizard
- Fixed a bug with importing values to BIGINT fields within the Import Data Wizard
- Some small improvements and corrections
- The HTML Report Generator implemented. This tool allows you to create the powerful database schema reports in HTML format quickly and easily
- Import Data Wizard: the interface of this module is improved - now setting correspondence between the source columns and the target fields becomes easier and faster
- Help system significantly expanded and improved - new topics and more detailed descriptions
- A bug with saving/restoring export templates in the Export Data Dialog is fixed
- Date values are now converted correctly to the script, when extracted with the Extract Metadata Expert
- A lot of various interface improvements
- Several minor improvements and corrections
- The Visual Database Designer is implemented. Now it is possible to design your database visually using this tool
- The support of InnoDB foreign keys is now available
- The HTML Report Generator was implemented
- MDI environment style implemented
- Now you can develop your own plugins for MySQL Manager 2. An example plugin with Delphi sources is included to distribution package
- Report Designer: now you can design your own reports in MySQL Manager
- Database passwords can be stored encrypted now
- New User Manager and Print Metadata windows
- New Environment Options: the Environment Options dialog has been completely redesigned
- A lot of other improvements and bug-fixes
The Linux version of MySQL Manager - a powerful GUI tool for MySQL database administration and development.
MySQL Manager for Linux is the same powerful tool for MySQL management as the Windows version. It provides graphical interface for all basic operations: creating/dropping databases, creating/dropping/altering tables, views, functions and other database objects, managing table data, running SQL queries and scripts, etc. Export/import data to/from most popular formats and other unique features are also available in Linux version.
- Visual Query Builder was significantly improved. Most of the known bugs in Visual Query Builder are fixed, some MySQL-specific words and constructs such as LIMIT #, SQL_SMALL_RESULT, SQL_BIG_RESULT, HIGH_PRIORITY are supported now
- Import Data Wizard: the import data engine was updated to the latest version (1.4) of EMS QuickImport suite
- Export Data as INSERT dialog exports only currently selected records now
- Fixed a bug with importing data from .csv files with empty values within records
- Changing a field size is now possible after changing a field type in the Edit Field dialog
- Fixed a bug with wrong text representing just after record editing in the Data View if the database font charset is different from default
- Several small improvements and minor bug-fixes
- Export Data dialog was upgraded to a newer version of QuickExport Component Suite
- Grant Manager: a possibility to manage the privileges on database level was added. Now you can manage all the MySQL privileges using the Grant Manager feature
- SQL Script: a possibility to disable the result log was added. Now you can disable output to the result memo (if it isn't necessary for you) and improve the performance of the query execution
- A possibility of not using the field dimension was added to the Add/Edit Column dialog. Now you can define fields such as FLOAT and DOUBLE with or without size and precision
- Form View: fixed a bug with clearing the field value if in the previous record it was Null
- Fixed a bug with changing the primary key index to index with the different name
- The strings that contain backslashes as the escape character process properly now. Because of a bug in the parser some errors did occur with '\\', '"' and ''' sequences within a string. Fixed now
- Fixed a bug with renaming tables in old versions (generally 3.22.x) of MySQL server
- Fixed a bug with setting the BINARY attribute to CHAR and VARCHAR fields
- Several small improvements and minor bug-fixes
- MySQL Manager Direct feature is added; now you can easily check for MySQL Manager updates and download the latest version just from the application
- Now it is possible to invoke Export Data, Export Data As INSERT, Import Data and Load Data functions directly from DB Explorer
- The ability to export all the MySQL Manager settings was added
- Load Data Wizard now works properly with libmysql.dll library compiled without local-infile option
- Commit/Rollback dialog now does not appear if connection to server is lost
- Fixed some bugs with localization of multiple instances of the Table Editor window and SQL Editor
- Several small improvements and minor bug-fixes
- EMS HiTech is now an official MySQL AB Software Partner!
- Interface localization has been implemented. Five languages - English, French, Italian, Dutch and Russian - are included in the installation package. Spanish localization is coming soon
- DB Explorer: three modes of viewing table's details in SQL Assistant were added. Now you can view table's fields, table's indices or table status
- DB Explorer: the ability of editing/dropping fields or indices was added to SQL Assistant
- BLOB Editor: the ability of viewing images in GIF format was added
- Query Builder: the last used query is being saved now on closing the Builder and is being restored on the next session of the Query Builder work
- You can restore the default size of any child forms by pressing Ctrl+D now
- Several small improvements and minor bug-fixes
- New powerful and flexible user interface was applied to MySQL Manager. This new interface allows you to customize tool bar content (e.g. hide or move button, make button groups, etc.), show only recently used items in menu, customize menu's behaviour and other useful features. Moreover, a new dialogue was added that allows you to select the visual scheme between two standard ones (XP-like or Classic), or customize it as you desire. The visual scheme includes the view style of bars, trees, lists, edit controls, check boxes and page controls, so you can totally change the way of how the application looks. All customizations will be saved for future use
- New powerful data grid was added to Data View: now you can edit data just in the grid within powerful inplace editors
- Extract Metadata: added extraction templates. Now you can save the frequently used extract configuration templates for future use or load previously saved ones. It is very useful when you use the Extract Metadata dialog for backing up the dump of your databases
- The possibility of extracting the data for the BLOB fields was added. Now you can dump the table data with BLOB fields using Extract Metadata dialog. Also this possibility was added to the Export As INSERT dialog
- SQL Script: the Enable/Disable Parsing button was added to the toolbar. This feature allows you to disable script text parsing when the script is too large (e.g. has BLOB data in INSERT statements)
- DB Explorer: possibility of multiple object dropping and editing was added. Now you can quickly drop several objects from database using the popup menu of the SQL Assistant. Simply select the objects in the list of SQL Assistant, right-click on selection and choose the 'Delete' item from the popup menu. You can also activate object editors within the same menu
- The possibility of dropping the system 'mysql' database is not allowed now via Drop Database menu item
- Fixed a bug with viewing/editing the fields of DECIMAL type. Now the size of such fields will be displayed correctly
- Several small improvements and minor bug-fixes
- Version 4.0.0-alpha of MySQL server is fully supported now!
- Grant Manager: possibility of grant privileges for columns added. Now you can grant/revoke privileges for columns in addition to tables
- DB Explorer: Register/Unregister host feature was added. Now you can register several databases at once with Register Host/Database wizard and quickly unregister all databases within a host
- Data View: all values in fields of ENUM type are displaying as it is represented in a table. Moreover, ENUM values now can be edited within drop list in a grid cell
- Fixed a bug in User Manager: now global privileges will be displayed correctly for users that have some privileges on the table level
- Fixed a bug with primary key editing. Now fields can be added to or deleted from primary key properly
- Fixed a bug with quick filtering of NULL values in Data View
- A lot of small improvements and bug-fixes
- 'Save Desktop' option added: check the "Save desktop on disconnect" checkbox in Environment Options | Preferences dialog page to enable/disable the restoring of all table/UDF editors, SQL Editor or Query Builder forms that was active before disconnect
- SQL Editor: the Result message added. Now after query execution the result message will appear in the message window of SQL Editor. It will represent the number of rows affected/fetched by query and the time of query execution
- Fixed a bug with calling the Database Registration Info dialog: no error now occurs on attempt to call it from context menu of the Host node
- Several small improvements and minor bug-fixes
Basic features:
- Easy management all MySQL objects
- Powerful tools to work with MySQL server
- Multiple database connections
- Powerful User Manager and Grant Manager
- SQL Editor with syntax highlight
- Visual Query Builder
- Powerful BLOB Viewer/Editor that provides several ways of viewing BLOB data
- Export data to Excel, RTF (Word), HTML, XML, DBF, TXT, CSV, SYLK, DIF, LaTeX and Windows Clipboard
- Import data from most popular formats, including MS Excel, Access, etc.
- SQL processing and watching tools
- Customizable program interface
- Detailed Help System and User's Guide
and more...
See also: |