mysqldbcompare(1) - Linux man page

Name

Synopsis

Description

Options

--version

show program's version number and exit

--help

display a help message and exit

--server1=SERVER1

connection information for first server in the form: <user>[:<password>]@<host>[:<port>][:<socket>] or <login-path>[:<port>][:<socket>].

--server2=SERVER2

connection information for second server in the form: <user>[:<password>]@<host>[:<port>][:<socket>] or <login-path>[:<port>][:<socket>].

-f FORMAT, --format=FORMAT

display the output in either grid (default), tab, csv, or vertical format

--skip-object-compare

skip object comparison step

--skip-row-count

skip row count step

--skip-diff

skip the object diff step

--skip-data-check

skip data consistency check

--width=WIDTH

display width

-a, --run-all-tests

do not abort when a diff test fails

--disable-binary-logging

turn binary logging off during operation if enabled (SQL_LOG_BIN=1). Note: may require SUPER privilege. Prevents compare operations from being written to the binary log.

-v, --verbose

control how much information is displayed. e.g., -v = verbose, -vv = more verbose, -vvv = debug

-q, --quiet

turn off all messages for quiet execution.

-d DIFFTYPE, --difftype=DIFFTYPE

display differences in context format in one of the following formats: [unified|context|differ|sql] (default: unified).

--changes-for=CHANGES_FOR

specify the server to show transformations to match the other server. For example, to see the transformation for transforming server1 to match server2, use --changes-for=server1. Valid values are 'server1' or 'server2'. The default is 'server1'.

--show-reverse

produce a transformation report containing the SQL statements to conform the object definitions specified in reverse. For example if --changes-for is set to server1, also generate the transformation for server2. Note: the reverse changes are annotated and marked as comments.

Copyright