MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Hery Ramilison Date:January 25 2017 6:02pm
Subject:MySQL Utilities 1.6.5 GA has been released
View as plain text  
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
MySQL Utilities 1.6.5 GA has been releasedHery Ramilison25 Jan