Skip to content

Latest commit

 

History

History
52 lines (33 loc) · 1.57 KB

mydumper.md

File metadata and controls

52 lines (33 loc) · 1.57 KB
title summary category
mydumper Instructions
Use mydumper to export data from TiDB.
tools

mydumper Instructions

What is mydumper?

mydumper is a fork of the mydumper project with additional functionality specific to TiDB. It is the recommended method to use for logical backups of TiDB.

It can be downloaded as part of the Enterprise Tools package.

What enhancements does this contain over regular mydumper?

  • Uses tidb_snapshot to provide backup consistency instead of FLUSH TABLES WITH READ LOCK

  • Allows tidb_snapshot to be configurable (i.e. backup data as it appeared at an earlier point in time)

New parameter description

  -z, --tidb-snapshot: Set the tidb_snapshot to be used for the backup.
                       Default: The current TSO (UniqueID from SHOW MASTER STATUS).
                       Accepts either a TSO or valid datetime.  For example: -z "2016-10-08 16:45:26"

Required privileges

  • SELECT
  • RELOAD
  • LOCK TABLES
  • REPLICATION CLIENT

Usage example

Command line parameter:

./bin/mydumper -h 127.0.0.1 -u root -P 4000

FAQ

Is the source code for these changes available?

Source code for PingCAP's mydumper is available on GitHub.

Do you plan to make these changes available to upstream mydumper?

Yes, we intend to make our changes available to upstream mydumper. See PR #155.