Use mysqldump data to export table structure or data

1. Export the table1 table in the test database: mysqldump -h127.0.0.1 -P9030 -uroot --no-tablespaces --databases test --tables table1
2. Export all tables in the test1, test2 database:
3. Export all databases and tables mysqldump -h127.0.0.1 -P9030 -uroot --no-tablespaces --all-databases For more usage parameters, please refer to the manual of mysqldump

Import

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

Notice

1. Using mysqldump to export data and table structure is only used for development and testing or when the amount of data is small. Do not use it in a production environment with a large amount of data.