MySQL Forums
Forum List  »  Announcements

MySQL Utilities 1.6.5 GA has been released
Posted by: Jocelyn Ramilison
Date: January 25, 2017 06:51AM

Dear MySQL users,

MySQL MySQL Utilities 1.6.5 is a GA version of 1.6 release series. It can be
used for production environments.

MySQL Utilities version 1.6.5 GA is compatible with MySQL Server
versions 5.5 and greater. Python v2.6 and v2.7 are supported.
It is available for download from:

A brief summary of changes is listed below. Please check the CHANGES.txt
file inside the distribution for a more complete list of changes.

MySQL Utilities provides a collection of command-line utilities that are
used for maintaining and administering MySQL servers, including:
• Admin Utilities (Clone, Copy, Compare, Diff, Export, Import,
User Management)
• Replication Utilities (Setup, Configuration, Verification)
• General Utilities (Disk Usage, Redundant Indexes, Manage Meta &
Audit Data)
• And more

Changes in MySQL Utilities 1.6.5 (2017-01-25)

   Bugs Fixed

     * Corrected a problem when using a --exec-before script
       that failed causing the mysqlfailover utility to fail
       silently. (Bug #25030151)

     * Added corrections to the message text of some utilities
       to eliminate typographical errors. (Bug #24742356, Bug

     * The mysqldbcopy utility failed to copy views that refer
       other views in the list of databases to be copied. (Bug

     * Corrected an issue when using anonymous hosts. (Bug
       #24624716, Bug #82636)

     * The mysqlfrm utility failed to parse some .frm files
       properly. This fix ensures that the utility can parse
       tables with many columns in the field list. (Bug
       #24613794, Bug #82907)

     * The mysqldbcopy utility failed to copy tables with a
       primary key set to zero and with AUTO_INCREMENT applied.
       This fix enables the copy and export of auto-increment
       columns with an initial value of zero. For export, the
       user is warned to turn on the NO_AUTO_VALUE_ON_ZERO mode
       for the import and suggested SQL statements to enable the
       mode are provided. For copy, the mode is turned on
       automatically and turned off after the copy. (Bug
       #23598948, Bug #81866)

     * Permits IPv4 address parsing to include values of 0-255
       rather than 0-254. Thanks to Erol Guven for the patch.
       (Bug #23578714, Bug #81834)

     * Tables with BLOB data in fields marked NOT NULL
       restricted the operation of the mysqldbcopy utility. This
       fix enables the utility to copy these tables by
       temporarily altering the columns on the destination to
       remove the NOT NULL option and then to restore it after
       the copy. (Bug #23335753, Bug #81553)

     * Corrected an issue with reading strings from
       configuration files when run with Python 2.6. (Bug

     * Corrected the error message stating the
       --discover-slaves-login option is not used with the
       failover command for the mysqlrpladmin utility. (Bug
       #22616847, Bug #80082)

     * Corrected the problem when socket files are used in
       replication utilities. Previously, the port defaulted to
       3306 instead of the actual port for the servers. The code
       now retrieves the port from the connected servers so that
       connections of slaves are directed to the correct port.
       (Bug #22543116)

     * Added context to errors resulting from server startup for
       the mysqlserverclone utility. Messages recommend using
       the -vvv option to find the actual error from the server
       startup sequence. (Bug #22457829)

     * The mysqlfrm utility failed when the --verbosity option
       was used. This fix replaces the --verbosity option with
       --verbose, the correct option name, and uses it
       consistently in error messages and code. (Bug #22254445,
       Bug #79382)

     * The mysqlserverinfo utility required connection
       parameters to show all MySQL servers running on the local
       host. This fix removes that restriction when the
       --show-servers option is specified. (Bug #22215626, Bug

     * Corrected a problem in the mysqldbimport utility where
       specifying the --skip option with a valid type failed to
       skip the intended object or objects during the operation.
       (Bug #22155217, Bug #79128)

     * The mysqldbcopy utility failed to copy grants for
       anonymous users. (Bug #22093518, Bug #78940)

     * Improved the --quiet option to silence all informational
       messages for the mysqldbcompare utility. (Bug #22093453,
       Bug #78938)

     * Corrected a problem using a single database name in the
       mysqldiff utility when comparing the same database on two
       servers. (Bug #21764003)

     * The DEB packages did not create the required
       /usr/share/pyshared/mysql directory. (Bug #21626041, Bug

     * Added error handling to ensure only one slave is
       specified for the --slave option for the mysqlreplicate,
       mysqlrplcheck, and mysqlrplms utilities. (Bug #21497923)

     * Enabled the use of the --exclude option for the
       mysqlrplsync utility. (Bug #21270853, Bug #77359)

     * Corrected a logic error when detecting and setting
       READ_ONLY mode on the candidate server during promotion
       for failover. (Bug #21201454, Bug #76522)

     * When the mysqldiff utility compared columns for indexes,
       it failed to take into account cardinality changes. That
       is, if the cardinality of one column differed from the
       corresponding column in the compared table, the index was
       considered different. This fix eliminates unnecessarily
       changes to indexes by the utility when cardinality
       differences are detected. (Bug #20857151, Bug #76619)

     * Removed password() function usage in the MySQL Utilities
       library for MySQL 5.7.6 or later. (Bug #20807296)

     * The mysqlfailover utility did not remove the
       failover_console table correctly on exit when run with
       the --daemon=start option. (Bug #20524886)

     * Improved the --force option for the mysqldiff utility to
       allow checks to continue when missing objects are
       detected. (Bug #20511130, Bug #75822)

     * Removed an extraneous difference in GRID format output of
       the mysqldbcompare utility when column sizes differ. (Bug

     * Corrected PEP8 warnings and errors on the utilities code
       base. (Bug #18755438)

     * Corrected an issue in which the mysqldbexport utility
       produced output with inconsistent table and database
       names. (Bug #18733683)

Reporting Bugs
We welcome and appreciate your feedback and bug reports:


On Behalf of the MySQL/ORACLE RE Team
Hery Ramilison 

Options: ReplyQuote

Written By
MySQL Utilities 1.6.5 GA has been released
January 25, 2017 06:51AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.