tencent cloud

Tencent Cloud TCHouse-D

DocumentationTencent Cloud TCHouse-DDevelopment GuideExporting DataUsing Mysqldump Tool to Export Table Structure or Data

Using Mysqldump Tool to Export Table Structure or Data

Download
Focus Mode
Font Size
Last updated: 2024-06-27 11:06:55
Tencent Cloud TCHouse-D has supported exporting data or table structures via the mysqldump tool after version 0.15.

Usage Examples

Export

1. Export the table1 in the test database:mysqldump -h127.0.0.1 -P9030 -uroot --no-tablespaces --databases test --tables table1.
2. Export the table1 structure in the test database:mysqldump -h127.0.0.1 -P9030 -uroot --no-tablespaces --databases test --tables table1 --no-data.
3. Export all tables in the test1, test2 databases:mysqldump -h127.0.0.1 -P9030 -uroot --no-tablespaces --databases test1 test2.
4. Export all databases and tables mysqldump -h127.0.0.1 -P9030 -uroot --no-tablespaces --all-databases.
For more usage parameters, see the mysqldump user manual.

Import

The results exported by mysqldump can be redirected to a file, which can then be imported into Doris using the source command source filename.sql.

Note

1. Since there is no concept of tablespace in mysql in Doris, the --no-tablespaces parameter must be added when using mysqldump.
2. Using mysqldump to export data and table structure is only for development and test or when the amount of data is small. It should not be used in a production environment with a large amount of data.
Previous Topic: Exporting via the EXPORT StatementNext Topic: Export Query Results

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback