- 14.4 Manual Pages
- 14.4.1 MySQL Utilities Overview — Brief overview of command-line utilities
- 14.4.2 mysqlauditadmin — Allows users to perform maintenance action on the audit log
- 14.4.3 mysqlauditgrep — Allows users to search the current or an archived audit log
- 14.4.4 mysqldbcompare — Compare Two Databases and Identify Differences
- 14.4.5 mysqldbcopy — Copy Database Objects Between Servers
- 14.4.6 mysqldbexport — Export Object Definitions or Data from a Database
- 14.4.7 mysqldbimport — Import Object Definitions or Data into a Database
- 14.4.8 mysqldiff — Identify Differences Among Database Objects
- 14.4.9 mysqldiskusage — Show Database Disk Usage
- 14.4.10 mysqlfailover — Automatic replication health monitoring and failover
- 14.4.11 mysqlindexcheck — Identify Potentially Redundant Table Indexes
- 14.4.12 mysqlmetagrep — Search Database Object Definitions
- 14.4.13 mysqlprocgrep — Search Server Process Lists
- 14.4.14 mysqlreplicate — Set Up and Start Replication Between Two Servers
- 14.4.15 mysqlrpladmin — Administration utility for MySQL replication
- 14.4.16 mysqlrplcheck — Check Replication Prerequisites
- 14.4.17 mysqlrplshow — Show Slaves for Master Server
- 14.4.18 mysqlserverclone — Clone Existing Server to Create New Server
- 14.4.19 mysqlserverinfo — Display Common Diagnostic Information from a Server
- 14.4.20 mysqluc — Command line client for running MySQL Utilities
- 14.4.21 mysqluserclone — Clone Existing User to Create New User
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:
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.
User Comments
Add your own comment.