Skip to content

Latest commit

 

History

History
103 lines (57 loc) · 2.31 KB

myloader_usage.rst

File metadata and controls

103 lines (57 loc) · 2.31 KB
Raw

Myloader Usage

Synopsis

:program:`myloader` :option:`--directory <myloader --directory>` = /path/to/mydumper/backup [:ref:`OPTIONS <myloader-options-label>`]

Description

:program:`myloader` is a tool used for multi-threaded restoration of mydumper backups.

Options

The :program:`myloader` tool has several available options:

.. program:: myloader


.. option:: --help, -?

   Show help text


.. option:: --defaults-file

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


.. option:: --host, -h

   Hostname of MySQL server to connect to (default localhost)


.. option:: --user, -u

   MySQL username with the correct privileges to execute the restoration


.. option:: --password, -p

   The corresponding password for the MySQL user


.. option:: --port, -P

   The port for the MySQL connection.

   .. note::

      For localhost TCP connections use 127.0.0.1 for :option:`--host`.


.. option:: --socket, -S

   The UNIX domain socket file to use for the connection


.. option:: --threads, -t

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


.. option:: --version, -V

   Show the program version and exit


.. option:: --compress-protocol, -C

   Use client protocol compression for connections to the MySQL server


.. option:: --directory, -d

   The directory of the mydumper backup to restore


.. option:: --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
      :option:`--overwrite-tables`.


.. option:: --source-db, -s

   Database to restore, useful in combination with --database


.. option:: --queries-per-transaction, -q

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


.. option:: --overwrite-tables, -o

   Drop any existing tables when restoring schemas


.. option:: --enable-binlog, -e

   Log the data loading in the MySQL binary log if enabled (off by default)


.. option:: --verbose, -v

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