mysqlreplicate(1) - Linux man page
Name
MySQL - manual page for MySQL Utilities mysqlreplicate version 1.2.1 - MySQL Workbench Distribution
5.2.47
Synopsis
mysqlreplicate --master=root@localhost:3306 --slave=root@localhost:3310
--rpl-user=rpl:passwd
Description
mysqlreplicate - establish replication with a master
Options
- --version
- show program's version number and exit
- --help
- display a help message and exit
- --master=MASTER
- connection information for master server in the form: <user>[:<password>]@<host>[:<port>][:<socket>] or
<login-path>[:<port>][:<socket>].
- --slave=SLAVE
- connection information for slave server in the form: <user>[:<password>]@<host>[:<port>][:<socket>] or
<login-path>[:<port>][:<socket>].
- --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 = rpl:rpl
- -p, --pedantic
- fail if storage engines differ among master and slave.
- --test-db=TEST_DB
- database name to use in testing replication setup (optional)
- --master-log-file=MASTER_LOG_FILE
- use this master log file to initiate the slave.
- --master-log-pos=MASTER_LOG_POS
- use this position in the master log file to initiate the slave.
- -b, --start-from-beginning
- start replication from the first event recorded in the binary logging of the master.Not valid with --masterlog-file or --master-log-pos.
- -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.
Copyright
Copyright © 2010, 2013 Oracle and/or its affiliates. All rights reserved. This is a release of
dual licensed MySQL Utilities. For the avoidance of doubt, this particular copy of the software is released under the version 2 of the GNU General Public
License. MySQL Utilities is brought to you by Oracle.