MySQL Blog Archive
For the latest blogs go to blogs.oracle.com/mysql
MySQL Workbench 6.0.9 GA has been released

The MySQL developer tools team at Oracle is excited to announce the availability of MySQL Workbench 6.0.9.

MySQL Workbench 6.0 is the GUI Development and Administration tool for MySQL.

Changes in MySQL Workbench 6.0.9 (2014-02-05)

This section documents all changes and bug fixes applied to MySQL Workbench since the release of 6.0.8.

Functionality Added or Changed

  •  The restore operation can restore to a different schema.

Bugs Fixed

  •  MySQL Workbench now builds on Debian 7.0-unstable.
  •  Ubuntu 13.10 is now supported.
  •  Fedora 20 is now supported
  •  On Linux, the Cancel button was written as “Cance” on some systems, depending on the GTK theme used on the system.
  •  Sometimes, when exporting an EER diagram to SQL, the generated SQL code did not include “DROP SCHEMA” statements even with  the Generate DROP SCHEMA option checked.
  •  One tab could execute the query from a different tab, after swapping tabs.
  •  On Linux, building MySQL Workbench from source would generate many glib related warnings with newer versions of glib.
  •  After creating a new view inside a model, clicking Add View would display a new view in the editor this new could not be saved.
  •  The –routines command line option was missing from the generated mysqldump command when multiple schemas were selected for a dump into a single file backup when the routines option was enabled. This could happen after executing the dump multiple times.
  •  Executing Model, Forward Engineering with the Do not create users, only export privileges option enabled would recreate the user instead of simply changing privileges for the existing user.
  •  On Linux, renaming foreign keys and indexes would crash MySQL Workbench.
  •  On Mac OS X, switching colors with layers and tables several times could eventually cause a crash.
  •  Adding a new table to an empty EER diagram would crash MySQL Workbench.
  •  When building from source and without building the documentation, the documentation link will open the online MySQL Workbench manual.
  •  The Inserts tab under Forward Engineering would sometimes unexpectedly fail.
  •  The ENUM type now corresponds better to its definition better under Model, User Defined Types, to allow arguments.
  •  On Microsoft Windows and Mac OS X, the bundled PyCrypto library was upgraded to version 2.6.1.
  •  MySQL Workbench could crash when using a MySQL connection that connects via an SSH tunnel with success, but is defined using incorrect MySQL server credentials. A dialog now requests the correct information.
  •  The catalog treeview for an EER diagram was replaced by a central control with improved handling, which allows MySQL Workbench  to worth more smoothly with a large number of tables.
  •  Indexes that were auto-created for a Foreign Key can now be deleted in case another suitable index was available.
  •  Under certain scenarios, the File, Print to File… action would not allow models to be unchecked.
  •  Model synchronization would complete, but if repeated then MySQL Workbench would ask to update the database again.
  •  Changing the collation type would not always be detected, as “No changes detected” would be reported after attempting to apply the change.
  •  The MySQL Forums link on the MySQL Workbench home page was updated, and it now links to a MySQL Workbench page that also  links to the MySQL Workbench – Database Migration forum, when before it was difficult to find.
  •  From Database, Reverse Engineer, and after selecting a schema with multiple tables, clicking the left or right arrow buttons with the Show Filter feature to include/exclude tables would lose the cursor position, and always move the cursor to the top of the list.
  •  For models, tables can now be renamed by double-clicking the name column, and the columns edited.
  •  A large SQL script file could not be saved for a model, although a limit of around 200MB limit still exists.
  •  MySQL Workbench could crash after choosing Recover when prompted to recover a model file from a previous session after MySQL Workbench was not closed properly.
  •  Applying an large SQL Script object to a model could crash MySQL Workbench.
  •  The “Scratch” SQL editor tabs were removed, and instead standard SQL editor tabs are always opened.
  •  Editing a mandatory relationship now updates the referenced column.
  •  The Copy and Paste keyboard shortcut did not always function from within table cells in all environments.
  •  The Schema Privileges tab was hidden in the Schema editor, and is now more viewable.

and much more. For a detailed overview of what’s new in MySQL Workbench 6.0, please visit:
http://dev.mysql.com/doc/workbench/en/wb-what-is-new.html

For the full list of bugs fixed in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-0.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?152

Download MySQL Workbench 6.0 now, for Windows, Mac OS X 10.6+, Oracle Linux 6, Fedora 19, Fedora 20, Ubuntu 12.04 and Ubuntu 13.10 or sources, from:
http://dev.mysql.com/downloads/tools/workbench/

In Windows, you can also use the integrated MySQL Installer to update MySQL Workbench and other MySQL products. For RPM  package based Linux distributions, you can get and update Workbench using the new MySQL RPM repository at:

http://dev.mysql.com/downloads/repo/

Quick links:
– Download: http://dev.mysql.com/downloads/tools/workbench/
– Bugs: http://bugs.mysql.com
– Forums: http://forums.mysql.com/index.php?152

Read more about MySQL Workbench 6.0 and some of its features in

MySQL Workbench 6.0: What’s New:

/2013/06/mysql-workbench-6-0-whats-new/