myloader --directory = /path/to/mydumper/backup [OPTIONS]
myloader is a tool used for multi-threaded restoration of mydumper backups.
The myloader tool has several available options:
Show help text
Hostname of MySQL server to connect to (default localhost)
MySQL username with the correct privileges to execute the restoration
The corresponding password for the MySQL user
The port for the MySQL connection.
Note
For localhost TCP connections use 127.0.0.1 for --host.
The UNIX domain socket file to use for the connection
The number of threads to use for restoring data, default is 4
Show the program version and exit
Use client protocol compression for connections to the MySQL server
The directory of the mydumper backup to restore
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 --overwrite-tables.
Number of INSERT queries to execute per transaction during restore, default is 1000.
Drop any existing tables when restoring schemas
Log the data loading in the MySQL binary log if enabled (off by default)
The verbosity of messages. 0 = silent, 1 = errors, 2 = warnings, 3 = info. Default is 2.