"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "docs/man/mysqldiff.1" between
mysql-utilities-1.6.4.tar.gz and mysql-utilities-1.6.5.tar.gz

About: MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers (written in Python).

mysqldiff.1  (mysql-utilities-1.6.4):mysqldiff.1  (mysql-utilities-1.6.5)
skipping to change at line 93 skipping to change at line 93
objects listed as arguments. OPTIONS.PP mysqldiff accepts the following command-line options: objects listed as arguments. OPTIONS.PP mysqldiff accepts the following command-line options:
· --help · --help
Display a help message and exit. Display a help message and exit.
· --license · --license
Display license information and exit. Display license information and exit.
· --changes-for=<direction> · --changes-for=direction
Specify the server to show transformations to match the other server. For example, to see the Specify the server to show transformations to match the other server. For example, to see the
transformation for transforming object definitions on server1 to matc h the corresponding definitions transformation for transforming object definitions on server1 to matc h the corresponding definitions
on server2, use --changes-for=server1. Permitted values are server1 a nd server2. The default is on server2, use --changes-for=server1. Permitted values are server1 a nd server2. The default is
server1. server1.
· --character-set=<charset> · --character-set=charset
Sets the client character set. The default is retrieved from the serv er variable Sets the client character set. The default is retrieved from the serv er variable
character_set_client. character_set_client.
· --difftype=<difftype>, -d<difftype> · --difftype=difftype, -ddifftype
Specify the difference display format. Permitted format values are un ified (default), context, Specify the difference display format. Permitted format values are un ified (default), context,
differ, and sql. differ, and sql.
· --compact · --compact
Compacts the output by reducing the control lines that are displayed in the diff results. This Compacts the output by reducing the control lines that are displayed in the diff results. This
option should be used together with one of the following difference t ypes: unified or context. option should be used together with one of the following difference t ypes: unified or context.
· --force · --force
Do not halt at the first difference found. Process all objects to fin d all differences. Do not halt at the first difference found. Process all objects to fin d all differences.
· --quiet, -q · --quiet, -q
Do not print anything. Return only an exit code of success or failure . Do not print anything. Return only an exit code of success or failure .
· --server1=<source> · --server1=source
Connection information for the first server. Connection information for the first server.
To connect to a server, it is necessary to specify connection paramet ers such as the user name, host To connect to a server, it is necessary to specify connection paramet ers such as the user name, host
name, password, and either a port or socket. MySQL Utilities provides a number of ways to supply name, password, and either a port or socket. MySQL Utilities provides a number of ways to supply
this information. All of the methods require specifying your choice v ia a command-line option such this information. All of the methods require specifying your choice v ia a command-line option such
as --server, --master, --slave, etc. The methods include the followin g in order of most secure to as --server, --master, --slave, etc. The methods include the followin g in order of most secure to
least secure. least secure.
· Use login-paths from your .mylogin.cnf file (encrypted, not visib le). Example : · Use login-paths from your .mylogin.cnf file (encrypted, not visib le). Example :
<login-path>[:<port>][:<socket>] login-path[:port][:socket]
· Use a configuration file (unencrypted, not visible) Note: availab le in release-1.5.0. Example : · Use a configuration file (unencrypted, not visible) Note: availab le in release-1.5.0. Example :
<configuration-file-path>[:<section>] configuration-file-path[:section]
· Specify the data on the command-line (unencrypted, visible). Exam ple : · Specify the data on the command-line (unencrypted, visible). Exam ple :
<user>[:<passwd>]@<host>[:<port>][:<socket>] user[:passwd]@host[:port][:socket]
· --server2=<source> · --server2=source
Connection information for the second server. Connection information for the second server.
To connect to a server, it is necessary to specify connection paramet ers such as the user name, host To connect to a server, it is necessary to specify connection paramet ers such as the user name, host
name, password, and either a port or socket. MySQL Utilities provides a number of ways to supply name, password, and either a port or socket. MySQL Utilities provides a number of ways to supply
this information. All of the methods require specifying your choice v ia a command-line option such this information. All of the methods require specifying your choice v ia a command-line option such
as --server, --master, --slave, etc. The methods include the followin g in order of most secure to as --server, --master, --slave, etc. The methods include the followin g in order of most secure to
least secure. least secure.
· Use login-paths from your .mylogin.cnf file (encrypted, not visib le). Example : · Use login-paths from your .mylogin.cnf file (encrypted, not visib le). Example :
<login-path>[:<port>][:<socket>] login-path[:port][:socket]
· Use a configuration file (unencrypted, not visible) Note: availab le in release-1.5.0. Example : · Use a configuration file (unencrypted, not visible) Note: availab le in release-1.5.0. Example :
<configuration-file-path>[:<section>] configuration-file-path[:section]
· Specify the data on the command-line (unencrypted, visible). Exam ple : · Specify the data on the command-line (unencrypted, visible). Exam ple :
<user>[:<passwd>]@<host>[:<port>][:<socket>] user[:passwd]@host[:port][:socket]
· --show-reverse · --show-reverse
Produce a transformation report containing the SQL statements to conf orm the object definitions Produce a transformation report containing the SQL statements to conf orm the object definitions
specified in reverse. For example, if --changes-for is set to server1 , also generate the specified in reverse. For example, if --changes-for is set to server1 , also generate the
transformation for server2. transformation for server2.
Note Note
The reverse changes are annotated and marked as comments. The reverse changes are annotated and marked as comments.
skipping to change at line 183 skipping to change at line 183
warning is issued if the --skip-table-options option is used and tabl e option differences are found. warning is issued if the --skip-table-options option is used and tabl e option differences are found.
· --ssl-ca · --ssl-ca
The path to a file that contains a list of trusted SSL CAs. The path to a file that contains a list of trusted SSL CAs.
· --ssl-cert · --ssl-cert
The name of the SSL certificate file to use for establishing a secure connection. The name of the SSL certificate file to use for establishing a secure connection.
· --ssl-cert · --ssl-key
The name of the SSL key file to use for establishing a secure connect ion. The name of the SSL key file to use for establishing a secure connect ion.
· --ssl · --ssl
Specifies if the server connection requires use of SSL. If an encrypt ed connection cannot be Specifies if the server connection requires use of SSL. If an encrypt ed connection cannot be
established, the connection attempt fails. Default setting is 0 (SSL not required). established, the connection attempt fails. Default setting is 0 (SSL not required).
· --verbose, -v · --verbose, -v
Specify how much information to display. Use this option multiple tim es to increase the amount of Specify how much information to display. Use this option multiple tim es to increase the amount of
information. For example, -v = verbose, -vv = more verbose, -vvv = de bug. information. For example, -v = verbose, -vv = more verbose, -vvv = de bug.
· --version · --version
Display version information and exit. Display version information and exit.
· --width=<number> · --width=number
Change the display width of the test report. The default is 75 charac ters. Change the display width of the test report. The default is 75 charac ters.
SQL TRANSFORMATION LIMITATIONS.PP The SQL transformation feature has thes e known limitations: SQL TRANSFORMATION LIMITATIONS.PP The SQL transformation feature has thes e known limitations:
· When tables with partition differences are encountered, the utility g enerates the ALTER TABLE · When tables with partition differences are encountered, the utility g enerates the ALTER TABLE
statement for all other changes but prints a warning and omits the pa rtition differences. statement for all other changes but prints a warning and omits the pa rtition differences.
· If the transformation detects table options in the source table (spec ified with the --changes-for · If the transformation detects table options in the source table (spec ified with the --changes-for
option) that are not changed or do not exist in the target table, the utility generates the ALTER option) that are not changed or do not exist in the target table, the utility generates the ALTER
TABLE statement for all other changes but prints a warning and omits the table option differences. TABLE statement for all other changes but prints a warning and omits the table option differences.
skipping to change at line 228 skipping to change at line 228
· SQL extensions specific to MySQL Cluster are not supported. · SQL extensions specific to MySQL Cluster are not supported.
NOTES.PP You must provide connection parameters (user, host, password, an d so forth) for an account that NOTES.PP You must provide connection parameters (user, host, password, an d so forth) for an account that
has the appropriate privileges to access all objects to be compared. has the appropriate privileges to access all objects to be compared.
For the --difftype option, the permitted values are not case sensitive. I n addition, values may be For the --difftype option, the permitted values are not case sensitive. I n addition, values may be
specified as any unambiguous prefix of a valid value. For example, --diff type=d specifies the differ specified as any unambiguous prefix of a valid value. For example, --diff type=d specifies the differ
type. An error occurs if a prefix matches more than one valid value. type. An error occurs if a prefix matches more than one valid value.
The path to the MySQL client tools should be included in the PATH environ ment variable in order to use The path to the MySQL client tools should be included in the PATH environ ment variable in order to use
the authentication mechanism with login-paths. This will allow the utilit y to use the my_print_defaults the authentication mechanism with login-paths. This permits the utility t o use the my_print_defaults
tools which is required to read the login-path values from the login conf iguration file (.mylogin.cnf). tools which is required to read the login-path values from the login conf iguration file (.mylogin.cnf).
If any database object identifier specified as an argument contains speci al characters or is a reserved If any database object identifier specified as an argument contains speci al characters or is a reserved
word, then it must be appropriately quoted with backticks (`). In turn, n ames quoted with backticks must word, then it must be appropriately quoted with backticks (`). In turn, n ames quoted with backticks must
also be quoted with single or double quotes depending on the operating sy stem, i.e. (") in Windows or also be quoted with single or double quotes depending on the operating sy stem, i.e. (") in Windows or
(') in non-Windows systems, in order for the utilities to read backtick q uoted identifiers as a single (') in non-Windows systems, in order for the utilities to read backtick q uoted identifiers as a single
argument. For example, to show the difference between table weird`table1 from database weird`db.name and argument. For example, to show the difference between table weird`table1 from database weird`db.name and
table weird`table2 from database other:weird`db.name, the objects pair mu st be specified using the table weird`table2 from database other:weird`db.name, the objects pair mu st be specified using the
following syntax (in non-Windows): following syntax (in non-Windows):
'`weird``db.name`.`weird``table1`:`other:weird``db.name`.`weird``table2`' . EXAMPLES.PP To compare the '`weird``db.name`.`weird``table1`:`other:weird``db.name`.`weird``table2`' . EXAMPLES.PP To compare the
skipping to change at line 336 skipping to change at line 336
# --destination=server2: # --destination=server2:
# ALTER TABLE dbx.table3 # ALTER TABLE dbx.table3
# DROP COLUMN notes, # DROP COLUMN notes,
# CHANGE COLUMN misc misc char(30); # CHANGE COLUMN misc misc char(30);
Compare failed. One or more differences found. Compare failed. One or more differences found.
PERMISSIONS REQUIRED.PP The user must have SELECT privileges for both obj ects on both servers as well as PERMISSIONS REQUIRED.PP The user must have SELECT privileges for both obj ects on both servers as well as
SELECT on the mysql database. SELECT on the mysql database.
COPYRIGHT COPYRIGHT
Copyright © 2006, 2016, Oracle and/or its affiliates. All rights reserved . Copyright © 2006, 2017, Oracle and/or its affiliates. All rights reserved .
This documentation is free software; you can redistribute it and/or modif y it only under the terms of This documentation is free software; you can redistribute it and/or modif y it only under the terms of
the GNU General Public License as published by the Free Software Foundati on; version 2 of the License. the GNU General Public License as published by the Free Software Foundati on; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without
even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General
Public License for more details. Public License for more details.
You should have received a copy of the GNU General Public License along w ith the program; if not, write You should have received a copy of the GNU General Public License along w ith the program; if not, write
to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, B oston, MA 02110-1301 USA or see to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, B oston, MA 02110-1301 USA or see
http://www.gnu.org/licenses/. http://www.gnu.org/licenses/.
SEE ALSO SEE ALSO
For more information, please refer to the MySQL Utilities and Fabric docu mentation, which is available For more information, please refer to the MySQL Utilities and Fabric docu mentation, which is available
online at http://dev.mysql.com/doc/index-utils-fabric.html online at http://dev.mysql.com/doc/index-utils-fabric.html
AUTHOR AUTHOR
Oracle Corporation (http://dev.mysql.com/). Oracle Corporation (http://dev.mysql.com/).
MySQL 1.6.3 08/01/2016 MYSQLDIFF(1) MySQL 1.6.4 01/14/2017 MYSQLDIFF(1)
 End of changes. 16 change blocks. 
15 lines changed or deleted 15 lines changed or added

Home  |  About  |  All  |  Newest  |  Fossies Dox  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTPS