mysqldbcopy(1) - Linux man page

Name

Synopsis

Description

Options

--version

show program's version number and exit

--help

display a help message and exit

--source=SOURCE

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

--destination=DESTINATION

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

-f, --force

drop the new database or object if it exists

--threads=THREADS

use multiple threads (connections) for insert

-x EXCLUDE, --exclude=EXCLUDE

exclude one or more objects from the operation using either a specific name (e.g. db1.t1), a LIKE pattern (e.g. db1.t% or db%.%) or a REGEXP search pattern. To use a REGEXP search pattern for all exclusions, you must also specify the --regexp option. Repeat the --exclude option for multiple exclusions.

-a, --all

include all databases

--skip=SKIP_OBJECTS

specify objects to skip in the operation in the form of a comma-separated list (no spaces). Valid values = tables, views, triggers, procedures, functions, events, grants, data, create_db

-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.

--new-storage-engine=NEW_ENGINE

change all tables to use this storage engine if storage engine exists on the destination.

--default-storage-engine=DEF_ENGINE

change all tables to use this storage engine if the original storage engine does not exist on the destination.

--locking=LOCKING

choose the lock type for the operation: no-locks = do not use any table locks, lock-all = use table locks but no transaction and no consistent read, snaphot (default): consistent read using a single transaction.

-G, --basic-regexp, --regexp

use 'REGEXP' operator to match pattern. Default is to use 'LIKE'.

--rpl-user=RPL_USER

the user and password for the replication user requirement, in the form: <user>[:<password>] or <login-path>. E.g. rpl:passwd - By default = none

--rpl=RPL_MODE, --replication=RPL_MODE

include replication information. Choices = 'master' = include the CHANGE MASTER command using source server as the master, 'slave' = include the CHANGE MASTER command using the destination server's master information.

--skip-gtid

skip creation and execution of GTID statements during copy.

Copyright