Tencent Cloud TCHouse-D
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Monitoring and Alarm Configuration
- Account Privilege Management
- Data Management
- Query Management
- Modify Configurations
- Development Guide
- Design of Data Table
- Importing Data
- Import Methods
- Exporting Data
- Basic Feature
- Query Optimization
- API Documentation
- Making API Requests
- Cluster Operation APIs
- Database and Table APIs
- Cluster Information Viewing APIs
- Hot-Cold Data Layering APIs
- Database and Operation Audit APIs
- User and Permission APIs
- Resource Group Management APIs
- Practical Tutorial
- Performance Testing
- TPC-H Performance Testing
- SSB Performance Testing
DocumentationTencent Cloud TCHouse-DDevelopment GuideExporting DataUsing Mysqldump Tool to Export Table Structure or Data
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.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No