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: http://dev.mysql.com/downloads/tools/utilities/ 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 #83173) * The mysqldbcopy utility failed to copy views that refer other views in the list of databases to be copied. (Bug #24657793) * 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 #22738248) * 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 #79135) * 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 #78054) * 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 #18763591) * 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: http://bugs.mysql.com/ Enjoy! On Behalf of the MySQL/ORACLE RE Team Hery Ramilison -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
