WARNING: This will cause inconsistent backups -l, -long-query-guard Set long query timer in seconds, default 60 -kill-long-queries Kill long running queries (instead of aborting) -b, -binlogs Get a snapshot of the binary logs as well as dump data -D, -daemon Enable daemon mode -I, -snapshot-interval Interval between each dump snapshot (in minutes), requires -daemon, default 60 -L, -logfile Log file name to use, by default stdout is used -h, -host The host to connect to -u, -user Username with privileges to run the dump -p, -password User password -P, -port TCP/IP port to connect to -S, -socket UNIX domain socket file to use for connection -t, -threads Number of threads to use, default 4 -C, -compress-protocol Use compression on the MySQL connection -V, -version Show the program version and exit -v, -verbose Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2 In order to use mydumper and myloader you can use the following sample commands:įor dumping/exporting database: mydumper -u -p -B -d /path/to/dumpįor importing database (for percona or master-master replication): myloader -u -p -B -d /dump/path -enable-binlogįor importing database (for standalone mysql): myloader -u -p -B -d /dump/pathĭetailed Syntax: Syntax mydumper Applicat=ion Options: -B, -database Database to dump -T, -tables-list Comma delimited table list to dump (does not exclude regex option) -o, -outputdir Directory to output files to -s, -statement-size Attempted size of INSERT statement in bytes, default 1000000 -r, -rows Try to split tables into chunks of this many rows -c, -compress Compress output files -e, -build-empty-files Build dump files even if no data available from table -x, -regex Regular expression for ‘db.table' matching -i, -ignore-engines Comma delimited list of storage engines to ignore -m, -no-schemas Do not dump table schemas with the data -k, -no-locks Do not execute the temporary shared read lock. If you want to execute logical backups using an alternative to mysqldump that works with parallel threads giving faster execution times mydumper is the correct tool.