MyDumper's logo MyDumper's logo

Configuration

The main configuration of MyDumper is kept in /etc/mydumper.cnf by default.

--defaults-file[=/etc/mydumper.cnf]

Said configuration is found in sections like:

[mydumper]
[mydumper_session_variables]
[myloader]
[myloader_session_variables]

Where the defaults of mydumper, myloader and the session level variables are kept when they are executed. In the case of [myloader_session_variables] , the default setting is:

[myloader_session_variables]
SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /*!40101
UNIQUE_CHECKS=0 /*!40114
FOREIGN_KEY_CHECKS=0 /*!40114

But, when you connect to MariaDB it gets replaced by:

[myloader_session_variables_mariadb]
# This setting replaces the default in the section [myloader_session_variables]. More details in #987
SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /*!40101
UNIQUE_CHECKS=1 /*!40114
FOREIGN_KEY_CHECKS=0 /*!40114

--defaults-extra-file

Using [`database`.`table`] sections may be helpful, since you can add:

  • where: It receives a comparison compatible with the table definition;

  • limit: It receives a number and forces the SELECT statement to avoid reading more reads if it reaches the limit;

  • num_threads: It defines the amount of threads that will be used for the table;

  • object_to_export: It receives a comma delimited list with this options: SCHEMA, DATA, TRIGGER, ALL and NONE. ALL is equal to SCHEMA,DATA,TRIGGER;

  • columns_on_select: The list of columns in the SELECT statement will be replaced by the content of this parameter;

  • columns_on_insert: The columns in the INSERT statemnt will be replace by the content of this parameter;

  • object_to_export: It receives a comma delimited list with this options: SCHEMA, DATA, TRIGGER, ALL and NONE. ALL is equal to SCHEMA,DATA,TRIGGER;

  • partition_regex: It defines a regular expression to filter the partitions to export.

For example:

where = column > 20
limit = 1000
object_to_export = SCHEMA
columns_on_select = qty,price+20
columns_on_insert = qty,price