MyDumper's logo MyDumper's logo

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