Export Data from TiDB

This page describes how to export data from your cluster in TiDB Cloud.

TiDB does not lock in your data. Sometimes you still want to be able to migrate data from TiDB to other data platforms. Because TiDB is highly compatible with MySQL, any export tool suitable for MySQL can also be used for TiDB.

You can use the tool Dumpling for data export.

1. Download and install TiUP:

   curl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | sh
   

2. Declare the global environment variable:

   Note

   After the installation, TiUP displays the absolute path of the corresponding profile file. You need to modify .bash_profile in following command to the path of your profile file.

   source .bash_profile
   

3. Install Dumpling.

   tiup install dumpling
   

4. Export your data using Dumpling from TiDB.

   You can get the following connection parameters ${tidb_endpoint}, ${port}, and ${user} from the connection string in the Connect dialog.

   • TiDB Serverless
   • TiDB Dedicated

   tiup dumpling -h ${tidb_endpoint} -P 4000 -u ${user} -p ${password} -F 67108864MiB -t 4 -o ${export_dir} --filetype sql --consistency none
   

   Note

   To export TiDB Serverless cluster data, you must ensure that the Dumpling version is at least v6.5.0. If your Dumpling version is v6.5.0, you also need to set --ca=${ca_path} in the command. To find the CA root path on your system, see TLS Connections to TiDB Serverless.

   tiup dumpling:v6.5.2 -h ${tidb_endpoint} -P ${port} -u ${user} -p ${password} -F 67108864MiB -t 4 -o ${export_dir} --filetype sql
   

   Options are described as follows:

   • -h: The TiDB cluster endpoint.

   • -P: The TiDB cluster port.

   • -u: The TiDB cluster user.

   • -p: The TiDB cluster password.

   • -F: The maximum size of a single file.

   • -o: The export directory.

   • --filetype: The exported file type. The default value is sql. You can choose from sql and csv.

   • --consistency: The data consistency. The default value is auto. For TiDB Serverless, you must set it to none.

     For more information about Dumpling options, see Dumpling option list.

     The minimum permissions required are as follows:

   • SELECT

   • RELOAD

   • LOCK TABLES

   • REPLICATION CLIENT

After exporting data using Dumpling, you can import the data to MySQL compatible databases by using TiDB Lightning.