.\" Man page generated from reStructuredText.
.
.TH "MYLOADER" "1" "Feb 09, 2021" "0.10.0" "mydumper"
.SH NAME
myloader \- multi-threaded MySQL loader
.
.nr rst2man-indent-level 0
.
.de1 rstReportMargin
\\$1 \\n[an-margin]
level \\n[rst2man-indent-level]
level margin: \\n[rst2man-indent\\n[rst2man-indent-level]]
-
\\n[rst2man-indent0]
\\n[rst2man-indent1]
\\n[rst2man-indent2]
..
.de1 INDENT
.\" .rstReportMargin pre:
. RS \\$1
. nr rst2man-indent\\n[rst2man-indent-level] \\n[an-margin]
. nr rst2man-indent-level +1
.\" .rstReportMargin post:
..
.de UNINDENT
. RE
.\" indent \\n[an-margin]
.\" old: \\n[rst2man-indent\\n[rst2man-indent-level]]
.nr rst2man-indent-level -1
.\" new: \\n[rst2man-indent\\n[rst2man-indent-level]]
.in \\n[rst2man-indent\\n[rst2man-indent-level]]u
..
.SH SYNOPSIS
.sp
\fBmyloader\fP \fI\%\-\-directory\fP = /path/to/mydumper/backup [\fI\%OPTIONS\fP]
.SH DESCRIPTION
.sp
\fBmyloader\fP is a tool used for multi\-threaded restoration of mydumper
backups.
.SH OPTIONS
.sp
The \fBmyloader\fP tool has several available options:
.INDENT 0.0
.TP
.B \-\-help, \-?
Show help text
.UNINDENT
.INDENT 0.0
.TP
.B \-\-defaults\-file
Use the given option file. If the file does not exist or is otherwise inaccessible, no failure occurs
.UNINDENT
.INDENT 0.0
.TP
.B \-\-host, \-h
Hostname of MySQL server to connect to (default localhost)
.UNINDENT
.INDENT 0.0
.TP
.B \-\-user, \-u
MySQL username with the correct privileges to execute the restoration
.UNINDENT
.INDENT 0.0
.TP
.B \-\-password, \-p
The corresponding password for the MySQL user
.UNINDENT
.INDENT 0.0
.TP
.B \-\-port, \-P
The port for the MySQL connection.
.sp
\fBNOTE:\fP
.INDENT 7.0
.INDENT 3.5
For localhost TCP connections use 127.0.0.1 for \fI\%\-\-host\fP\&.
.UNINDENT
.UNINDENT
.UNINDENT
.INDENT 0.0
.TP
.B \-\-socket, \-S
The UNIX domain socket file to use for the connection
.UNINDENT
.INDENT 0.0
.TP
.B \-\-threads, \-t
The number of threads to use for restoring data, default is 4
.UNINDENT
.INDENT 0.0
.TP
.B \-\-version, \-V
Show the program version and exit
.UNINDENT
.INDENT 0.0
.TP
.B \-\-compress\-protocol, \-C
Use client protocol compression for connections to the MySQL server
.UNINDENT
.INDENT 0.0
.TP
.B \-\-directory, \-d
The directory of the mydumper backup to restore
.UNINDENT
.INDENT 0.0
.TP
.B \-\-database, \-B
An alternative database to load the dump into
.sp
\fBNOTE:\fP
.INDENT 7.0
.INDENT 3.5
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
\fI\%\-\-overwrite\-tables\fP\&.
.UNINDENT
.UNINDENT
.UNINDENT
.INDENT 0.0
.TP
.B \-\-source\-db, \-s
Database to restore, useful in combination with –database
.UNINDENT
.INDENT 0.0
.TP
.B \-\-queries\-per\-transaction, \-q
Number of INSERT queries to execute per transaction during restore, default
is 1000.
.UNINDENT
.INDENT 0.0
.TP
.B \-\-overwrite\-tables, \-o
Drop any existing tables when restoring schemas
.UNINDENT
.INDENT 0.0
.TP
.B \-\-enable\-binlog, \-e
Log the data loading in the MySQL binary log if enabled (off by default)
.UNINDENT
.INDENT 0.0
.TP
.B \-\-verbose, \-v
The verbosity of messages.  0 = silent, 1 = errors, 2 = warnings, 3 = info.
Default is 2.
.UNINDENT
.SH AUTHOR
Andrew Hutchings
.SH COPYRIGHT
2021, Andrew Hutchings
.\" Generated by docutils manpage writer.
.