Scroll to navigation

MYLOADER(1) mydumper MYLOADER(1)


myloader - multi-threaded MySQL loader


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

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

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.


For localhost TCP connections use 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


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.

Database to restore, useful in combination with –database

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.


Andrew Hutchings


2021, Andrew Hutchings

February 9, 2021 0.10.0