myloader Usage

Synopsis

myloader --directory = /path/to/mydumper/backup [OPTIONS]

Description

myloader is a tool used for multi-threaded restoration of mydumper backups.

Options

The myloader tool has several available options:

Connection Options

-h, --host

The host to connect to

-u, --user

Username with the necessary privileges

-p, --password

User password

-a, --ask-password

Prompt For User password

-P, --port

TCP/IP port to connect to

-S, --socket

UNIX domain socket file to use for connection

-C, --compress-protocol

Use compression on the MySQL connection

--ssl

Connect using SSL

--ssl-mode

Desired security state of the connection to the server: DISABLED, PREFERRED, REQUIRED, VERIFY_CA, VERIFY_IDENTITY

--key

The path name to the key file

--cert

The path name to the certificate file

--ca

The path name to the certificate authority file

--capath

The path name to a directory that contains trusted SSL CA certificates in PEM format

--cipher

A list of permissible ciphers to use for SSL encryption

--tls-version

Which protocols the server permits for encrypted connections

Filter Options

-x, --regex

Regular expression for ‘db.table’ matching

-s, --source-db

Database to restore

--skip-triggers

Do not import triggers. By default, it imports triggers

--skip-post

Do not import events, stored procedures and functions. By default, it imports events, stored procedures nor functions

--no-data

Do not dump or import table data

-O, --omit-from-file

File containing a list of database[.table] entries to skip, one per line (skips before applying regex option)

-T, --tables-list

Comma delimited table list to dump (does not exclude regex option). Table name must include database name. For instance: test.t1,test.t2

PMM Options

--pmm-path

which default value will be /usr/local/percona/pmm2/collectors/textfile-collector/high-resolution

--pmm-resolution

which default will be high

Execution Options

-e, --enable-binlog

Enable binary logging of the restore data

--innodb-optimize-keys

Creates the table without the indexes and it adds them at the end. Options: AFTER_IMPORT_PER_TABLE and AFTER_IMPORT_ALL_TABLES. Default: AFTER_IMPORT_PER_TABLE

--purge-mode

This specify the truncate mode which can be: NONE, DROP, TRUNCATE and DELETE

--disable-redo-log

Disables the REDO_LOG and enables it after, doesn’t check initial status

-o, --overwrite-tables

Drop tables if they already exist

--serialized-table-creation

Table recreation will be executed in series, one thread at a time. This means –max-threads-for-schema-creation=1. This option will be removed in future releases

--stream

It will receive the stream from STDIN and creates the file in the disk before start processing. Since v0.12.7-1, accepts NO_DELETE, NO_STREAM_AND_NO_DELETE and TRADITIONAL which is the default value and used if no parameter is given

Threads Options

--max-threads-per-table

Maximum number of threads per table to use, default 4

--max-threads-per-table-hard

Maximum hard number of threads per table to use, we are not going to use more than this amount of threads per table, default 4

--max-threads-for-index-creation

Maximum number of threads for index creation, default 4

--max-threads-for-schema-creation

Maximum number of threads for schema creation. When this is set to 1, is the same than –serialized-table-creation, default 4

--exec-per-thread

Set the command that will receive by STDIN from the input file and write in the STDOUT

--exec-per-thread-extension

Set the input file extension when –exec-per-thread is used. Otherwise it will be ignored

Statement Options

-r, --rows

Split the INSERT statement into this many rows.

-q, --queries-per-transaction

Number of queries per transaction, default 1000

--append-if-not-exist

Appends IF NOT EXISTS to the create table statements. This will be removed when https://bugs.mysql.com/bug.php?id=103791 has been implemented

--set-names

Sets the names, use it at your own risk, default binary

--skip-definer

Removes DEFINER from the CREATE statement. By default, statements are not modified

Application Options

-?, --help

Show help options

-d, --directory

Directory of the dump to import

-L, --logfile

Log file name to use, by default stdout is used

-B, --database

An alternative database to restore into

--resume

Expect to find resume file in backup dir and will only process those files

-t, --threads

Number of threads to use, default 4

-V, --version

Show the program version and exit

--identifier-quote-character

This set the identifier quote character that is used to INSERT statements onlyon mydumper and to split statement on myloader. Use SQL_MODE to change theCREATE TABLE statementsPosible values are: BACKTICK and DOUBLE_QUOTE. Default: BACKTICK

-v, --verbose

Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2

--defaults-file

Use a specific defaults file. Default: /etc/mydumper.cnf

--defaults-extra-file

Use an additional defaults file. This is loaded after –defaults-file, replacing previous defined values