NAME

myloader - multi-threaded MySQL loader

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:

--help, -?: Show help text

--defaults-file: Use the given option file. If the file does not exist or is otherwise inaccessible, no failure occurs

--host, -h: Hostname of MySQL server to connect to (default localhost)

--user, -u: MySQL username with the correct privileges to execute the restoration

--password, -p: The corresponding password for the MySQL user

--port, -P: The port for the MySQL connection.
NOTE:

For localhost TCP connections use 127.0.0.1 for --host.

--socket, -S: The UNIX domain socket file to use for the connection

--threads, -t: The number of threads to use for restoring data, default is 4

--version, -V: Show the program version and exit

--compress-protocol, -C: Use client protocol compression for connections to the MySQL server

--directory, -d: The directory of the mydumper backup to restore

--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 --overwrite-tables.

--source-db, -s: Database to restore, useful in combination with –database

--queries-per-transaction, -q: Number of INSERT queries to execute per transaction during restore, default is 1000.

--overwrite-tables, -o: Drop any existing tables when restoring schemas

--enable-binlog, -e: Log the data loading in the MySQL binary log if enabled (off by default)

--verbose, -v: The verbosity of messages. 0 = silent, 1 = errors, 2 = warnings, 3 = info. Default is 2.

AUTHOR

Andrew Hutchings

COPYRIGHT

2021, Andrew Hutchings

February 9, 2021

0.10.0