1MYSQLSERVERCLONE(1)             MySQL Utilities            MYSQLSERVERCLONE(1)
2
3
4

NAME

6       mysqlserverclone - Start a new instance of an existing MySQL server
7

SYNOPSIS

9       mysqlserverclone  [[ --help | --version] | --quiet |
10                         --server=<user>[<passwd>]@<host>:[<port>][:<socket>]
11                         [ --new-data=<datadir> | --new-port=<port> |
12                           --new-id=<server_id> ] | --root-password=<passwd> ]
13

DESCRIPTION

15       This utility permits an administrator to start a new instance of a run‐
16       ning server.  The utility will create a new datadir  (--new-data),  and
17       start  the server with a socket file. You can optionally add a password
18       for the login user account on the new instance.
19

OPTIONS

21       --version
22              show version number and exit
23
24       --help, -h
25
26              show the help page
27
28       --server <source>
29
30              connection  information  for  source   server   in   the   form:
31              <user>:<password>@<host>:<port>:<socket>
32
33       --verbose, -v
34
35              control  how  much  information  is displayed. For example, -v =
36              verbose, -vv = more verbose, -vvv = debug
37
38       --quiet, -q
39
40              turn off all messages for quiet execution
41
42       --new-data <path to new datadir>
43
44              the full path to the location of the data directory for the  new
45              instance
46
47       --new-port <port>
48
49              the new port for the new instance - default=3307
50
51       --new-id <server_id>
52
53              the server_id for the new instance - default=2
54
55       --root-password <password>
56
57              password for the root user
58
59       --mysqld <options>
60
61              additional options for mysqld
62

NOTES

64       The login user must have the appropriate permissions to grant access to
65       all databases and the ability to create a user account.
66

EXAMPLES

68       The following demonstrates how to create a new instance  of  a  running
69       server and setting the root password and turning binary logging on.:
70
71       $ mkdir /source/test123
72       $ mysqlserverclone --server=root:pass@localhost \
73         --new-data=/Users/cbell/source/test123 --new-port=3310 \
74         --root-password=pass --mysqld=--log-bin=mysql-bin
75       # Cloning the MySQL server running on localhost.
76       # Creating new data directory...
77       # Configuring new instance...
78       # Locating mysql tools...
79       # Setting up empty database and mysql tables...
80       # Starting new instance of the server...
81       # Testing connection to new instance...
82       # Success!
83       # Setting the root password...
84       # ...done.
85

87       Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved.
88
89       This program is free software; you can redistribute it and/or modify it
90       under the terms of the GNU General Public License as published  by  the
91       Free Software Foundation; version 2 of the License.
92
93       This  program  is  distributed  in the hope that it will be useful, but
94       WITHOUT ANY  WARRANTY;  without  even  the  implied  warranty  of  MER‐
95       CHANTABILITY  or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General
96       Public License for more details.
97
98       You should have received a copy of the GNU General Public License along
99       with this program; if not, write to the Free Software Foundation, Inc.,
100       51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
101

AUTHOR

103       MySQL Utilities Team
104

106       2010, Oracle and/or its affiliates. All rights reserved.
107
108
109
110
1111.0.1                         September 23, 2011           MYSQLSERVERCLONE(1)
Impressum