tencent cloud

Tencent Cloud TCHouse-D

Product Introduction
Overview
Concepts
Cluster Architecture
Strengths
Scenarios
Purchase Guide
Billing Overview
Renewal Instructions
Overdue Policy
Refund Instructions
Configuration Adjustment Billing Instructions
Getting Started
Using Tencent Cloud TCHouse-D Through the Console
Using Tencent Cloud TCHouse-D Through a Client
Operation Guide
Cluster Operation
Monitoring and Alarm Configuration
Account Privilege Management
Data Management
Query Management
Modify Configurations
Node Management
Log Analysis
SQL Studio
Enabling Resource Isolation
Development Guide
Design of Data Table
Importing Data
Exporting Data
Basic Feature
Query Optimization
Ecological Expansion Feature
API Documentation
History
Introduction
API Category
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
Data Types
Error Codes
Cloud Ecosystem
Granting CAM Policies to Sub-accounts
Query Acceleration for Tencent Cloud DLC
Practical Tutorial
Basic Feature Usage
Advanced Features Usage
Resource Specification Selection and Optimization Suggestions
Naming Specifications and Limits to the Database and Data Table
Table Design and Data Import
Query Optimization
Suggested Usage to Avoid
Accessing TCHouse-D via JDBC over the Public Network
Performance Testing
TPC-H Performance Testing
SSB Performance Testing
TPC-DS Performance Testing
FAQs
Common Operational Issues
Common Errors
Contact Us
Glossary
Product Policy
Service Level Agreement
Privacy Policy
Data Processing And Security Agreement
DocumentaçãoTencent Cloud TCHouse-DDevelopment GuideExporting DataUsing Mysqldump Tool to Export Table Structure or Data

Using Mysqldump Tool to Export Table Structure or Data

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 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.
Anterior: Exporting via the EXPORT StatementPróximo: Export Query Results

Ajuda e Suporte

Esta página foi útil?

comentários