Skip to main content

Import and export TiDB data

Use NineData Data Import and Data Export to move TiDB data through a task-based workflow. The same workflow can support one-time data exchange, initial data loading, and controlled file-based import or export operations.

Why Use A Task-Based Workflow​

TiDB provides native tools for different operational scenarios, including Dumpling, Lightning, Data Migration, Backup & Restore, and TiCDC. Those tools are powerful, but teams may still need a web-based workflow for routine import and export tasks, especially when approvals, task records, and standardized operations are required.

NineData provides a console-based workflow for TiDB import and export:

  • Export data by SQL statement or by selecting database objects.
  • Export data, structure, or structure plus data.
  • Export to SQL, CSV, or Excel files.
  • Import SQL, CSV, Excel, or compressed files.
  • Configure import mapping and conflict-handling options.
  • Route import and export tasks through approval when required by the organization.

Before you begin​

Before you import or export TiDB data, make sure that:

  • The TiDB data source has been added to NineData.
  • You have permission to create Data Import or Data Export tasks.
  • The export target or import file format has been confirmed.
  • Any required SQL development policy or approval workflow is configured.
  • For imports, the target database and table structure are ready, unless the task also creates the required structure.

Export TiDB Data​

  1. Sign in to the NineData console.

  2. Choose Database DevOps > Data Export.

  3. Select Create Data Export.

  4. Configure the export task, including the TiDB data source, export scope, export content, file format, and advanced settings.

  5. Select Create Data Export.

    Create a TiDB data export task

  6. After the task finishes, open the task details page and select Download to download the exported file.

    Download exported TiDB data

Import TiDB Data​

  1. Choose Database DevOps > Data Import.

  2. Select Create Data Import.

  3. Configure the import task, including the TiDB target data source, target database, import type, file, mapping, conflict-handling option, and executor.

  4. Select Create Data Import.

    Create a TiDB data import task

  5. Wait for the task to finish.

    Review TiDB data import status

Result​

After the export task succeeds, the TiDB data is available as a downloadable file. After the import task succeeds, NineData writes the imported data to the target TiDB database. Review the task details for execution status, row counts, approval records, and any error messages.

Next Steps​