Choose your SQL server:
AnySQL
MySQL
MS SQL Server
PostgreSQL
Oracle
SQL Anywhere
DB2
SQLite
Firebird
MaxDB

Subscribe to our newsletter

SQL Maestro for MySQL online help

Prev  Return to chapter overview Next 

What's new

10/20/2008 - SQL Maestro for MySQL 8.10 released

 

Server management extensions:

 

An ability of using the LOAD DATA INFILE command has been incorporated into the Import Data wizard. This feature can speed up the import process up to 10 times so it is recommended to use it always if possible. Also we have added the Empty table before importing option (can be found at the last step of the wizard).

 

Get SQL Dump Wizard and Extract Database Wizard now can generate multi-row INSERT statements. Also both the wizards have been redesigned to increase the usability.

 

Interface improvements:

 

Data Grid features the following things:

 

oStarting with this version it is possible to use the lookup editor for a column, which is linked by a foreign key with a (single) column from another table. The editor displays the contents of parent table’s columns within the dropdown window.

 

oA possibility of displaying data in the master-detail form has been incorporated into the Table Editor (multiple detail pages can be displayed for a single master row). Use the Show/Hide details link at the editor’s navigation bar to activate/deactivate this view mode.

 

oFiltering, grouping, and sorting features become available for TEXT columns. Also it is possible to edit the contents of such columns in a separate window as well as encrypt it using the md5 algorithm.

 

Database Designer settings: the Show hints option has been added. Also it is now possible to select the default graphic file format to export diagrams as images.

 

Data Export, Data Import, and Get SQL Dump wizards now store their size and position.

 

Database Explorer: the Data management group has been added to table and view nodes popup menus. Use this group items to run Data Export, Data Import, and Get SQL Dump wizards for the selected table or view without opening its editor (the Empty Table command has been moved to this group too). The Go to foreign table command is now available for all the foreign keys.

 

 

03/20/2008 - SQL Maestro for MySQL 8.3 released

 

Server management extensions:

 

The main feature of the new version is a possibility of connecting to remote MySQL servers with restricted access via HTTP tunneling. The technology works as follows:

 

oUpload the connection PHP script to your website. The script is named mysql_tunnel.php and can be found under the installation folder, usually C:\Program Files\SQL Maestro Group\SQL Maestro for MySQL.

 

oTest the script in your web-browser (optionally).

 

oEnter the script URL in the Create Profiles Wizard, Create Database Wizard, or Edit Database Profile dialog. Of course you should select the "I have to use HTTP tunneling" option in any of these windows.

 

Starting with this version you can set up default character set and collation in Create Database Wizard.

 

Now you can specify the client encoding in the connection properties. Default value is UTF-8 (do not change it without necessity).

 

SQL Formatter now understands expressions like INTERVAL 600 MINUTES.

 

Quick Connect mode has been implemented. Use it to skip metadata refreshing when connecting to a database (for example, to execute a query or SQL script).

 

Interface improvements:

 

This version of our software is fully compatible with large fonts (120 DPI).

 

Extract database wizard: common database properties and program info are now included into the result scripts.

 

SQL Editor: a popup menu has been added to each query tab. Using this menu you can create a new query, close existing one, save the query to profile, etc even if editor's navigation bar is closed.

 

Create Database Wizard, Create Profiles Wizard, and object creation wizards become resizable.

 

Data import wizard: the interface for adding and editing of replacements has been slightly improved.

 

The F11 key is now used to show/hide the Explorer tree.

 

Data grid options: it is now possible to restrict maximum column width.

 

SQL Script Editor settings: the "Use script runner for large scripts" option has been added.

 

Important fixes:

 

Data in UTF-8 encoding are now displayed correctly for MySQL 4.1.

 

Extract Database Wizard now works fine even if a user has no permissions to obtain view definitions.

 

 

12/14/2007 - SQL Maestro for MySQL 7.12 released

 

Server management extensions:

 

A new editor for values of the set data type has been implemented.

 

Values of the enum ('Y','N') data type are now displayed and edited as checkboxes.

 

Foreign keys are now extracted corrected for all MySQL versions.

 

Interface improvements:

 

The SQL Generator tool has been implemented. Use this feature to produce various SQL scripts (CREATE, DROP, SELECT, INSERT, etc) for the selected object. The result script can be saved to a file, copied to clipboard, and opened in SQL Editor or SQL Script Editor.

 

Data Grid has been significantly updated:

 

oThe notification pane is now displayed after simple mode activation (filtering, grouping and sorting features are not supported in this mode). All the related settings can be customized in the Options dialog;

 

oThe Generate Query command has been added to the Table / View Editor. Use this command to copy current filter conditions to the SQL Editor window as an SQL query. It is also possible to copy filter condition to clipboard as WHERE clause using grid’s popup menu;

 

oNow it is possible to encrypt the contents of the selected cell by the md5 algorithm (the corresponding item has been added to grid's popup menu).

 

Database designer: the Note and Text tools have been added. You can use them to decorate the diagrams.

 

Create Database Profiles wizard: the Hide already registered databases option has been added.

 

Object editors, SQL Editor, Database Designer, BLOB Viewer and other database-dependent windows: only connected databases are now displayed in the drop-down list.

 

 

08/23/2007 - SQL Maestro for MySQL 7.8 released

 

Server management extensions:

 

SQL Maestro for MySQL was optimized to work with MySQL servers with a small timeout;

 

Since this version you can reorder fields for existing tables. It is also possible to reorder parameters for a stored procedure/function and reorder partitions (only for newly created tables);

 

It is now possible to cancel a long running query execution (MySQL 5) and data fetching (all MySQL versions);

 

Field Editor: the NCHAR and NVARCHAR types are added to the type list;

 

Process Browser: session killing is now works correctly for all MySQL versions.

 

Interface improvements:

 

The SQL Formatter for DML statements (SELECT, INSERT, UPDATE and DELETE) is implemented. It can be invoked through the Format SQL link on the SQL Editor's navigation bar (Ctrl+Alt+D shortcut). Also it is now used for view body formatting (MySQL stores view body as a single line)

 

Data grid: the editor for ENUM fields displays a lookup list with enumeration values.

 

Extract Metadata Wizard is improved. Now it works faster and requires less memory

 

Now SQL Maestro for MySQL displays execution time for lengthy operations.

 

Get SQL Dump Wizard: the result table is now scripted correctly.

 

The Row count and Data length columns are added to the table list (Database Editor, Object Browser).

 

The database hints in the explorer tree now contain connection ID and default character set/collation. Hints for tables and columns are also included character set and collation, but only if they are different from database default.

 

Data Import Wizard: the speed of loading of Excel files was significantly increased.

 

Foreign key editor: now only InnoDB tables are displayed in the foreign table list. Table engine is also now checked for the Relation tool in the Database Designer.

 

 

08/21/2007 - Renaming of administration tools family for MySQL

 

SQL Maestro Group have renamed all MySQL Administration tools family members because of MySQL AB trademark policy.

 

Since then the new title of MySQL Maestro is SQL Maestro for MySQL.

 

 

06/25/2007 - MySQL Maestro 7.6 released

 

Server management extensions:

 

The most important thing added in this version of MySQL Maestro is support of UTF-8 data.

 

Process Browser is implemented. This feature is very useful for DBAs who want to monitor the users' activity (in fact, there are potentially thousands of sessions in a database at any one time). You can view details for each session (such as user, connect time, database name, client host, last SQL statement executed and more) as well as group and filter sessions by client host, connected user, database, client application, etc.
To access the Process Browser window, select the corresponding item from the Tools menu.

 

Now MySQL Maestro displays view body correctly even if you're not the owner of the view.
 

Interface improvements:

 

Database Designer: a possibility of locking/unlocking diagram objects is added. This feature prevents your diagram from unforeseen changes: when the diagram is locked, you can neither move/resize/delete existing objects nor add new ones.

 

Some new features are incorporated into SQL Editor and SQL Script Editor. Now it is possible:
 
ocomment/uncomment selected text (Shift+Ctrl+. / Shift+Ctrl+, shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift+Ctrl+, having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported;

 

oconvert selected text to different cases (lower, UPPER, and NameCase);

 

oexport the contents of the editor to RTF and HTML formats (to file or to clipboard);

 

oprint/preview the contents of the editor.

 

The Copy to SQL Script Editor command is added to all object editors (available in the Navigation Bar on the SQL tab). Use it for quick copying object’s SQL definition (DDL) to the SQL Script Editor for future modifications;

 

Data grid: some advanced filtering abilities were implemented (see Main menu | Tools | Options | Data grid | Filter);

 

Explorer tree: the Browse command is added to lists' popup menus (runs the Object Browser tool).

 

 

02/15/2007 - MySQL Maestro 7.2 released

 

Server management extensions:

 

MySQL Maestro has been successfully tested with the latest MySQL versions up to 5.0.27, 5.1.15 beta and 5.2 alpha;
 
Support of the Falcon storage engine from MySQL 5.2 is implemented;

 

Interface improvements:

 

The main feature of the new version is Graphical Database Designer - a case tool for managing your database in a few mouse clicks. This piece of our software is intended for creation of physical Entity Relationship Diagrams that represent objects in your MySQL databases. Each diagram displays the tables of your database and the relationships between them.
 
oHandy tools of Designer allow you to create new and edit existing tables and references;
 
oThe reverse engineering feature will help you to understand the schema structure and make its modification in an easy and clear way.
 
oNow you can quickly and easily print your database structure with a lot of options including header and footer, paper size and orientation, etc;
 
oA rich set of options and settings give you a way to see your database in your own look and feel style.
 

A diagram of your database can help you define operational aspects of your application logic that you might otherwise overlook. Also, a well-defined data diagram that accurately represents your tasks can be helpful in orienting employees to goals and operations.
 

SQL Editor: now MySQL Maestro can edit even very large SQL files. Also the speed of editor's work has been significantly improved;
 
SQL Editor: queries' tabs can now been displayed at the all sides of the editor (bottom, top, left or right);
 
The hint for foreign keys now contains such information as foreign table name and field correspondence.

 

 

12/08/2006 - MySQL Maestro 6.12 released

 

Server management extensions:

 

The Make primary key and Clear primary key commands are now accessible anywhere in the software (Table Editor, Explorer Tree, Object Browser, etc);

 

Interface improvements:

 

The tabbed interface is implemented in addition to classic MDI (see screenshot). You can choose your favorite UI in the Options dialog;
 
MySQL Maestro now stores parameters history for procedure execution so you can choose a set of already used values instead of entering them manually;
 
SQL Script Editor: if a user opens a file larger than 100K, MySQL Maestro will suggest him to execute the script file without opening it in the editor. Of course it is also possible to execute any script file using this way: just press the "Execute script from file" link on the Script Editor navigation bar and specify the filename;
 
We have implemented the Data Analysis, a tool to represent your data as OLAP cubes;
 
Database profiles are now grouped by host+port+login combination rather than host+port in the previous versions;
 
The Table Editor interface is improved: now all the subitems i.e. fields, indexes, and triggers are displayed at the main editor tab. We found this layout more comfortable;
 
BLOB viewer/editor: the text pane provides now several types of text highlighting (Plain text, HTML, JScript, CSS, PHP, XML, SQL, and SQLite DDL). Also it is possible to find and replace a text fragment of a BLOB column data;
 
It is now available to refresh schema object list whenever an object depends on other objects e.g. refresh table list on view creation;
 
The Insert key is now a shortcut for creating a new database object from the Explorer tree;
 
Create Profiles Wizard: we've added an option for converting new object names to lower/upper case;
 
Data grid: the speed of data loading was significantly increased.

 

 

10/20/2006 MySQL Maestro 6.10 released

 

A new version of MySQL Maestro, a powerful Windows GUI solution for MySQL server administration and database development, has been released.

 

Please consider the list of all new features implemented in MySQL Maestro 6.10:

 

The new version connects to the database much faster because of using the information_schema database (MySQL 5.0 and higher).

 

It is now possible to view/change SQL scripts generated by MySQL Maestro before executing.

 

Support of events (MySQL 5.1.6+) and table partitions (MySQL 5.1.3+) is implemented.

 

Now it is possible to read and set object grants and user permission even you have no access to mysql database.

 

Support of all the user permissions (up to MySQL 5.1.12) is provided.

 

A new tool for multi-dimensional analysis, Data Analysis (OLAP Viewer), is implemented in the new version MySQL Maestro. With the tool it is able to slice and dice information efficiently and provide customers with an extremely intuitive end-user experience. Data can be rendered to answer business questions - and best of all - it allows you to focus on business rules rather than creating dozens and dozens of reports.

 

Server scope objects (such as users, UDFs, etc) are now displayed in the Explorer tree. There is also a separate branch for all the triggers.

 

SQL Editor improvements: now you can execute each query in a separate thread in order to continue your work with the software while the query is executing. The Procedure and Function editors are also improved for the purpose of executing the routine asynchronously.

 

Create Object Wizards are improved: now it is possible to specify all the object properties and subitems during its creation. The Create View Wizard now includes the Filter Builder dialog to facilitate creating WHERE condition. Also the wizards became resizable now for more usability.

 

MySQL security management became easier. Now you can set all object permissions within the Object Editor.

 

Table Editor: Foreign key references is implemented. This feature allows you to manage foreign keys that are created in other tables and reference columns of the current table.

 

Object Browser tool for operating on database objects designed as an extension of Database Explorer with advanced features such as sorting, grouping and filtering the database objects. It also provides such operation as multiple selecting of objects (for copying, dropping, etc.) and the ability of using drag-and-drop operations between Object Browser and Database Explorer is implemented.

 

For your convenience it is implemented the second mode of viewing data as info cards.

 

New Explorer option "Display system object in different color" allows you to mark system objects with customizable color (purple by default).

 

Table Editor provides viewing of text fields' contents in data grid.

 

The Code Folding feature is implemented in all the SQL editors and viewers. The Code Folding item group makes it possible both to view the whole text and to divide it into logical parts (regions). Each part can be collapsed and extended.

 

SQL Editor: the pair bracket highlight is available for your convenience.

 

Now it is possible to set character set and collation during the database, table or field creation. They also can be changed within the corresponding editors.

 

Table maintenance commands (Analyze Table, Check Table, Repair Table, Optimize Table) are now available from the Table Editor or from popup menu of Database Explorer.

 

Server Editor and Database Editor are added.

 

MySQL Maestro provides now the ability to describe the object directly from the Database Explorer.

 

New software look and feel: program icon, installer, splash screen, wizard image and various other interface improvements.

 

In addition to this, a lot of other improvements and bugfixes were made.

 

 

09/01/2005 - New version format

 

When setting product versions, we have accepted the following principles for version format:

 

the first figure of the product version stands for the year of release;

 

the second figure of the version is meant to indicate the month of the current version release.

 

For example, MySQL Maestro 5.4 (former version 1.9) indicates that the version was released in April 2005.

 

Please refer the present news item for checking out whether your current product version is the latest one released.

 

 

08/02/2005 - MySQL Maestro 1.95 released

 

The key feature of this version is support of triggers, which were actually implemented in MySQL 5.0.10. You can add new triggers to the database and edit existing ones using the Trigger Editor as well as removing needless triggers. Also triggers are now supported by the Extract Database and SQL Script Editor modules.

 

Other improvements and bugfixes:

 

1. Fixed a bug with reordering table fields for MySQL 4.1 and higher.

 

2. SQL Script Editor: the CREATE VIEW statements with the ALGORITHM keyword are now displayed correctly in the object tree.

 

3. Extract Database: now default character set is included into database definition for MySQL 4.1.x and 5.x.

 

4. Fixed a bug with displaying the View Editor toolbar.

 

5. SQL Editor: it is now possible to see the results of CHECKSUM TABLE statements.

 

6. Other small improvements and bugfixes.

 

 

04/28/2005 - MySQL Maestro 1.9 released

 

1. Stored procedures and functions are now compiled correctly under MySQL 5.0.3 and higher.

 

2. Support of character sets and collations is added to the Create Database and Create Table wizards (for MySQL 4.1.x and 5.x).

 

3. Support of new MySQL privileges is implemented. Now it is possible to grant/revoke CREATE VIEW and SHOW VIEW privileges (MySQL 5.0.1 or higher) as well as CREATE ROUTINE, ALTER ROUTINE and CREATE USER privileges for MySQL 5.0.3+.

 

4. The "Manage Database Objects" submenu is added in the popup menu of the Explorer Tree. Use it to quickly open the Object Manager tool with database tables, views, procedures, etc.

 

5. All database objects now can be dragged from the Explorer Tree to the SQL Script Editor (the SQL definition of the object will be pasted). Also you can drag-n-drop tables and views from the Explorer Tree to the SQL Editor; in this case a SELECT statement will be generated.

 

6. The Ctrl+F7 and Ctrl+F9 shortcuts now can be used to compile views, procedures, and functions.

 

7. Russian localization included into the installation package (thanks to Elmir Mirdiev). Earlier our software was also translated to French and Italian languages.

 

8. The Close View item is added to the Main Menu | Windows | Close submenu.

 

9. Double-click at the column header area of an object list (fields, indexes, etc) does not invoke the corresponding editor anymore. Similarly double-click at the Data Grid's header does not invoke the Data Input Form.

 

10. Default values are now displayed correctly in the field list.

 

11. Fixed the bug with editing DATETIME fields in the Data Grid and Data Input Form.

 

12. Some other improvements and bug fixes.

 

 

12/16/2004 - MySQL Maestro 1.8 released

 

1. The Code Insight system now supports aliases in SELECT queries. For example, you can type something similar

 

SELECT * from mytable t where t.

 

and MySQL Maestro will display you the list of all the table fields in the popup window.

 

2. Since this version it is possible to use the "Database Tools" item in the popup menu of the Explorer Tree and Database Profile Manager to get access to some frequently used modules such as SQL Editor, Visual Query Builder, Extract Database, etc more quickly.

 

3. The Add Index window is redesigned to make index creation more comfortable.

 

4. Now MySQL Maestro doesn't disconnect from an active database if you change its profile properties (except changing server or database name).

 

5. Data Grid: double click on the grid now invokes the Data Input form. Also we've added shortcuts for such operations as Export Data, Import Data, Get SQL Dump, etc.

 

6. It is now possible to open the corresponding object editor directly from the BLOB Viewer (see the "Edit BLOB Source" link).

 

7. The MySQL Help System is now available for the Security Manager.

 

8. Some interface changes for improving multilingual support.

 

9. Some other minor improvements and bug fixes.

 

 

10/15/2004 - MySQL Maestro 1.7 released

 

Version 1.7 released. The multilingual support is implemented: now our software can be translated to any language. The Italian (thanks to Giuseppe Maxia and StarData s.r.l.) and French (thanks to Renaud Lepage) translations are included into the installation package. To change the application language, select it from the Main menu | Tools | Languages menu. It is also easy to translate MySQL Maestro to another language: just find the English.txt file in the MySQL Maestro\Languages directory, save it as YourLanguage.txt and translate all the strings from the file using any text editor e.g. Notepad or MS Word. If you send as a new translation, we'll provide you with a free business license of MySQL Maestro.

 

Other improvements and bug fixes:

 

1. The "Auto link tables by foreign keys" option is added to the Visual Query Builder settings. If this option is on, MySQL Maestro will automatically add links between tables when you add a new table to the Query Builder area. Of course this option works only if your MySQL server supports the foreign keys.

 

2. The Copy to Clipboard item is added to the Data Grid's popup menu. Use it to copy selected records to the Windows clipboard. Records in the clipboard are separated by the line break character. The Tab character is used to separate values within a record. To copy all the grid records at the same time, you can use the Select All item, which is added as well. Both these operations are also available through the main menu.

 

3. The Show Filter Panel and Show Subobjects buttons are added to the MySQL Maestro main tool bar.

 

4. The Ctrl+O and "Ctrl+D" shortcut keys are now associated with Object Manager and Database Profile Manager accordingly.

 

5. The Data Export page is added to the MySQL Maestro options dialog. Here you can specify the formats for data exporting. If you set ON the Auto save format option, MySQL Maestro saves the data formats each time you change them in the Export Data Wizard. The Set Defaults button resets all the export formats.

 

6. Since this version it is not necessary to close/open windows with data grids (e.g. Table Editor or SQL Editor) to apply the changes you made in the Options dialog.

 

7. Security Manager: now grants are set correctly for all MySQL servers (there were some problems with 3.23.xx versions).

 

8. Some other minor improvements and corrections.

 

 

08/25/2004 - MySQL Maestro 1.6 released

 

Version 1.6 released. In this version we have implemented the support for views, which are available in MySQL starting from version 5.0.1. The views are usually used for more friendly representation of data selected from one or several tables. They also can be used to limit an access for data viewing or editing by users. Also we have adapted MySQL Maestro for managing stored procedures and functions, which are belong to individual database instead of a host starting from version 5.0.1 of MySQL server.

 

Several improvements and bug fixes:

 

Retrieving of stored procedures and functions from a server does not require a user to have any permissions to the 'mysql' database;

 

Fixed bug in the Export Data Wizard with loading destination file format and file name from a template;

 

The popup window for parameters input appeared incorrectly in some cases;

 

Fixed bug in the SQL Script Editor with parsing negative numbers within the INSERT INTO statement in some cases;

 

Field list on the step for customizing Excel file format could contain duplicate values;

 

The "Server's host key did not match the signature supplied" error appeared during connection to some SSH servers. Now it is fixed.

 

 

07/12/2004 - MySQL Maestro 1.5 released

 

Version 1.5 released. In this version we have implemented a possibility to connect to a remote MySQL server using a secure protocol. The secure connection is established through the Secure SHell (SSH) tunnel, which guarantees a high security for the data transmission between a local PC and remote MySQL server. All the parameters for the SSH connection are stored in database profiles as extra properties, and can be specified as follows:

 

In the Create Database Wizard, when you create a new database. In this case the SSH connection is established before the database is created, and all the SSH parameters are stored in the database profile, if an appropriate option is checked in the wizard.

 

In the Create Database Profile Wizard, when you register existing database(s). The SSH parameters are also stored in the database profiles.

 

In the Edit Database Profile dialog, when you edit an already registered database profile.

 

Also MySQL Maestro can ask you for the SSH parameters when you attempt to retrieve user privileges or server variable list through the SSH tunnel in the Security Manager or Server Properties window.

 

In addition to the described feature we have made some small improvements and several minor bug fixes. Here is a list of most important changes:

 

we've made the Export Data and Import Data wizards sizeable for easier navigation within their controls;

 

the columns containing a user name, user host, and database object are frozen in the Security Manager for convenience purposes now;

 

table type can be reported incorrectly in the Table Properties dialog with MySQL 4.1.3;

 

there could be a problem to create a new database if the server port number was different from the default one;

 

fixed bug with the 'commands out of sync' error occurred with executing subqueries in the SQL Editor in some cases.

 

 

05/28/2004 - MySQL Maestro 1.4 released

 

Version 1.4 released. Now it is possible to manage several table subobjects at once e.g.

 

create/edit/drop all the indexes and foreign keys for a whole database. This feature is available in the Create Database Object dialog, which can be invoked from the Object menu;

 

drop several fields, indexes, or foreign keys at a time for a table: just select required objects at the proper page of the Table Editor and simply press the Del key;

 

copy several fields, indexes, or foreign keys from one table to another: you can do it using standard Copy/Paste functions or by drag-n-drop between two instances of the Table Editor.

 

Several minor bugs were fixed:

 

there were some troubles with copying tables containing foreign keys from one database to another;

 

the Copy Database wizard did not copy tables with foreign keys properly in some cases. The "Disable foreign key checks" option was added to the final step of the wizard to avoid this problem;

 

the Windows -> Close All menu item did not closed all child windows in some cases;

 

the database explorer did not restore its width after sequential hiding and showing by its splitter.

 

04/09/2004 - MySQL Maestro 1.3 released

 

In this version we have implemented the Object Manager - a feature-rich tool for easy manipulation of database objects. Now it is possible to work with tables, queries, procedures and other database objects as easy as it can be. Here are some examples, which demonstrate how you can use the new tool:

 

you can open several database objects at a time;

 

you need to clear data from all database tables? Just open the Object Manager, press Ctrl+A, then choose Empty Tables from the popup menu;

 

in earlier versions of MySQL Maestro you can copy a table definition to the clipboard by Ctrl+C and then paste it in the same or different database. Now it is possible to process several tables at once;

 

it is also possible to drop several database objects at a time. Hope you will treat this tool carefully.

 

full drag-n-drop support is available: you can drag objects between the Object Manager and the Database Explorer as well as between two instances of the Object Manager;

 

and much more.

 

The Object Manager starts automatically when you connect to a database. It is possible to disable this feature in the Options dialog as well as call the Object Manager manually from the Object menu.

 

We also have fixed several bugs:

 

the Diagram Viewer did not clear the list of fields after switching to another database using combo box in the Database group area. This bug could cause some instability of the application;

 

the Move Up/Move Down menu items did not work in the field list on the second step of the Create Table wizard;

 

some steps of the Create New Procedure and Create New Function wizards did not open the proper help topic after clicking on the Help button.

 

 

03/08/2004 - MySQL Maestro 1.2 released

 

The main feature of this version is the Diagram Viewer. It is a tool for representing data from a table or a query as a diagram in various ways. Also the Diagram Viewer has the Export diagram image feature, as well as the Export diagram data one, with a lot of formats supported. The interface of the new tool is liked to BLOB Viewer, so we hope it will be easy to use.

 

Some technical details:

 

you can save the diagram as Bitmap, PDF, JPEG, GIF, PostScript, Metafile, VML, PNG, or PCX file. Of course it is possible to open the result file in the associated application (e.g. Paint, Acrobat Reader, Photoshop, etc) directly from MySQL Maestro;

 

supported diagram types are: bar, line, area, point, pie, or fast line;

 

it is possible to show/hide diagram axis;

 

it is possible to show/hide the diagram legend;

 

it is possible to specify axis labels source and diagram header.

 

The Diagram Viewer is located in the Tools menu, the appropriate button on the toolbar is also available.

 

Several minor bugfixes:

 

the confirmation dialog appeared for each database object dropping even if an appropriate option was off in the Options dialog. Now this bug is fixed;

 

fixed bug with impossibility to disconnect from a database if the MySQL server was shut down during the connection session;

 

group boxes did not appear in accordance with current scheme in some cases.

 

 

02/04/2004 - MySQL Maestro 1.1 released

 

In this version we have implemented the Database Profile Manager, which is a tool, designed as an extension of the Database Explorer with some advanced features. In particular, it allows you to:

 

connect/disconnect several databases a