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

       --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

       2011, Andrew Hutchings