myloader
is a tool used for multi-threaded restoration of backups taken using mydumper
. myloader
comes along with mydumper
and you don't need to install it separately. In this section, you will learn the various ways to restore a backup.
The common options for myloader
are the hostname of the MySQL server to connect to (the default is localhost
), username, password, and port.
shell> myloader --directory=/backups --user=<user> --password=<password> --queries-per-transaction=5000 --threads=8 --compress-protocol --overwrite-tables
The options are explained as follows:
--overwrite-tables
: This option drops the tables if they already exist--compress-protocol
: This option uses compression on the MySQL connection--threads
: This option specifies the number of threads to use; the default is4
--queries-per-transaction
: This specifies the number of queries per transaction; the default is1000
--directory
: This...