Usage¶
Synopsis¶
mydumper [OPTIONS]
myloader --directory
= /path/to/mydumper/backup [OPTIONS]
Description¶
mydumper is a tool used for backing up MySQL database servers much faster than the mysqldump tool distributed with MySQL. The advantages of mydumper are:
Parallelism (hence, speed) and performance (avoids expensive character set conversion routines, efficient code overall)
Easier to manage output (separate files for tables, dump metadata, etc, easy to view/parse data)
Consistency - maintains snapshot across all threads, provides accurate master and slave log positions, etc
Manageability - supports PCRE for specifying database and tables inclusions and exclusions