mysqldiff(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>].

--width=WIDTH

display width

--force

do not abort when a diff test fails

-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