From which databases can dumpling export SQL scripts?

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

Original topic: dumpling可以从哪些数据库导出sql脚本

| username: TiDBer_djgos04V

In which databases can Dumpling export SQL scripts from?

| username: TiDBer_QHSxuEa1 | Original post link

Suitable for MySQL and TiDB export as mentioned in the official documentation.

| username: TiDBer_djgos04V | Original post link

Does that mean it is completely unsupported for other databases?

| username: 啦啦啦啦啦 | Original post link

In theory, anything compatible with the MySQL protocol should work. Since it’s a logical export, protocols like Oracle and SQL Server, which are different, definitely won’t work. However, I remember that higher versions will check TiDB-specific system tables, and using mydumper for MySQL yields similar results.

| username: zhanggame1 | Original post link

Using the data export tool Dumpling, you can export data stored in TiDB or MySQL into SQL or CSV formats for logical full backups. Dumpling also supports exporting data to Amazon S3.

| username: YuchongXU | Original post link

MySQL

| username: tidb菜鸟一只 | Original post link

A library compatible with the MySQL protocol.

| username: Jellybean | Original post link

For content you’re not familiar with, it’s recommended to directly search the official website.

Using the data export tool Dumpling, you can export data stored in TiDB or MySQL into SQL or CSV formats for logical full backups. Dumpling also supports exporting data to Amazon S3.

Official website introduction:

| username: TiDBer_vfJBUcxl | Original post link

Dumpling is a tool for full logical export from MySQL/TiDB.

Basic Information:

  • Dumpling’s Input: MySQL/TiDB cluster
  • Dumpling’s Output: SQL/CSV files
  • Applicable TiDB Versions: All versions
  • Kubernetes Support: Not yet supported
| username: redgame | Original post link

MySQL

| username: 昵称想不起来了 | Original post link

TiDB and MySQL, 使用 Dumpling 导出数据 | PingCAP 文档中心

| username: 大飞哥online | Original post link

As long as it follows the MySQL protocol, it can be exported.