|
|
OpenDB's PublicPIM 5.3 (Default branch)
11-27-2008
|
|
MYLOADER(1) mydumper MYLOADER(1) 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. --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 0.5.1 June 09, 2012 MYLOADER(1)