1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
Myloader Usage
==============
Synopsis
--------
:program:`myloader` :option:`--directory <myloader --directory>` = /path/to/mydumper/backup [:ref:`OPTIONS <myloader-options-label>`]
Description
-----------
:program:`myloader` is a tool used for multi-threaded restoration of mydumper
backups.
.. _myloader-options-label:
Options
-------
The :program:`myloader` tool has several available options:
.. program:: myloader
.. option:: --help, -?
Show help text
.. option:: --defaults-file
Use the given option file. If the file does not exist or is otherwise inaccessible, no failure occurs
.. option:: --host, -h
Hostname of MySQL server to connect to (default localhost)
.. option:: --user, -u
MySQL username with the correct privileges to execute the restoration
.. option:: --password, -p
The corresponding password for the MySQL user
.. option:: --port, -P
The port for the MySQL connection.
.. note::
For localhost TCP connections use 127.0.0.1 for :option:`--host`.
.. option:: --socket, -S
The UNIX domain socket file to use for the connection
.. option:: --threads, -t
The number of threads to use for restoring data, default is 4
.. option:: --version, -V
Show the program version and exit
.. option:: --compress-protocol, -C
Use client protocol compression for connections to the MySQL server
.. option:: --directory, -d
The directory of the mydumper backup to restore
.. option:: --database, -B
An alternative database to load the dump into
.. note::
For use with single database dumps. When using with multi-database dumps
that have duplicate table names in more than one database it may cause
errors. Alternatively this scenario may give unpredictable results with
:option:`--overwrite-tables`.
.. option:: --source-db, -s
Database to restore, useful in combination with --database
.. option:: --queries-per-transaction, -q
Number of INSERT queries to execute per transaction during restore, default
is 1000.
.. option:: --overwrite-tables, -o
Drop any existing tables when restoring schemas
.. option:: --enable-binlog, -e
Log the data loading in the MySQL binary log if enabled (off by default)
.. option:: --verbose, -v
The verbosity of messages. 0 = silent, 1 = errors, 2 = warnings, 3 = info.
Default is 2.
|
