- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Development Guide
- Design of Data Table
- Importing Data
- Import Overview
- Import Methods
- Synchronizing Data with JDBC
- Synchronizing Data Through External Tables
- Real-time or Batch Writing of MySQL Data
- Importing Data from Kafka
- Importing with DataX
- Importing Doris from Logstash
- Data Transformation, Column Mapping and Filtering
- Importing Strict Mode
- Importing Data in JSON Format
- Exporting Data
- Basic Feature
- Query Optimization
- Ecological Expansion Feature
- Product Policy
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Development Guide
- Design of Data Table
- Importing Data
- Import Overview
- Import Methods
- Synchronizing Data with JDBC
- Synchronizing Data Through External Tables
- Real-time or Batch Writing of MySQL Data
- Importing Data from Kafka
- Importing with DataX
- Importing Doris from Logstash
- Data Transformation, Column Mapping and Filtering
- Importing Strict Mode
- Importing Data in JSON Format
- Exporting Data
- Basic Feature
- Query Optimization
- Ecological Expansion Feature
- Product Policy
Using Mysqldump Tool to Export Table Structure or Data
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.
Yes
No
Was this page helpful?