mysqlserverclone (1)
Leading comments
Title: \fBmysqlserverclone\fR
Author: [FIXME: author] [see http://docbook.sf.net/el/author]
Generator: DocBook XSL Stylesheets v1.79.1 <http://docbook.sf.net/>
Date: 08/01/2016
Manual: MySQL Utilities
Source: MySQL 1.6.3
Language: English
NAME
mysqlserverclone - Clone Existing Server to Create New Server
SYNOPSIS
mysqlserverclone [options]
DESCRIPTION
This utility permits an administrator to clone an existing MySQL server instance to start a new server instance on the same host. The utility creates a new datadir (--new-data), and starts the server with a socket file. You can optionally add a password for the login user account on the new instance.
If the user does not have read and write access to the folder specified by the --new-data option, the utility shall issue an error.
Similarly, if the folder specified by
--new-data exists and is not empty, the utility will not delete the folder and will issue an error message. Users must specify the --delete-data option to permit the utility to remove the folder prior to starting the cloned server.
OPTIONS
mysqlserverclone accepts the following command-line options:
o --help
Display a help message and exit.
o --delete-data
Delete the folder specified by --new-data if it exists and is not empty.
o --mysqld=
Additional options for mysqld. To specify multiple options, separate them by spaces. Use appropriate quoting as necessary. For example, to specify --log-bin=binlog and --general-log-file="mylogfile", use:
--mysqld="--log-bin=binlog --general-log-file='my log file'"
o --new-data=
The full path name of the location of the data directory for the new server instance. If the directory does not exist, the utility will create it.
o --new-id=
The server_id value for the new server instance. The default is 2.
o --new-port=
The port number for the new server instance. The default is 3307.
o --quiet, -q
Turn off all messages for quiet execution.
o --root-password=
The password for the root user of the new server instance.
o --server=
Connection information for the server to be cloned in
o --start-timeout=
Number of seconds to wait for server to start. Default = 10 seconds.
o --verbose, -v
Specify how much information to display. Use this option multiple times to increase the amount of information. For example, -v = verbose, -vv = more verbose, -vvv = debug.
o --version
Display version information and exit.
o --write-command=
Path name of file in which to write the command used to launch the new server instance.
EXAMPLES
The following command demonstrates how to create a new instance of a running server, set the root user password and enable binary logging:
$ mkdir /source/test123
$ mysqlserverclone --server=root:pass@localhost \
--new-data=/Users/cbell/source/test123 --new-port=3310 \
--root-password=pass --mysqld=--log-bin=mysql-bin
# Cloning the MySQL server running on localhost.
# Creating new data directory...
# Configuring new instance...
# Locating mysql tools...
# Setting up empty database and mysql tables...
# Starting new instance of the server...
# Testing connection to new instance...
# Success!
# Setting the root password...
# ...done.
COPYRIGHT
SEE ALSO
For more information, please refer to the MySQL Utilities section of the MySQL Workbench Reference Manual, which is available online at http://dev.mysql.com/doc/workbench/en/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MYSQLSERVERCLONE()