How to Export to CSV Format Using Mydumper

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: mydumper怎么导出为csv格式

| username: jingyesi3401

【TiDB Usage Environment】Production\Testing Environment

【TiDB Version】v5.1.0

【Encountered Problem】
Currently using mydumper to export production database data, but the default export data format is SQL. Is it possible to directly export to CSV format? I checked the help, and it seems not supported. Is there any other good conversion method?

2
| username: ablewang_xiaobo | Original post link

You can use Dumpling, it supports CSV format.

3
| username: jingyesi3401 | Original post link

This error has not been resolved yet. Please take a look to see if there is a solution.
dumpling export data error - TiDB / Backup & Data Migration - TiDB Q&A Community (asktug.com)

4
| username: fubinzh | Original post link

It is recommended to use Dumpling. You can export CSV by specifying --filetype csv, and it supports more optimizations specific to TiDB. 使用 Dumpling 导出数据 | PingCAP 文档中心

5
| username: ablewang_xiaobo | Original post link

The above is the command I used for backup, and it can successfully back up.

6
| username: cs58_dba | Original post link

mydumper probably does not support CSV format, you can try setting parameters for dumping.

7
| username: system | Original post link

This topic was automatically closed 1 minute after the last reply. No new replies are allowed.