In addition, one of the ways to export data from RDS MySQL using Alibaba Cloud DMS will be introduced through a vivid demonstration.
🔥 1. Export from on-premise MySQL in CLI
mysqldump -uroot -p auto_test 》 ~/auto_test_$(date +%F).sql
🔥 2. Import a sql file to ApsaraDB RDS MySQL in CLI
#Connect to RDS mysql -h[rds_endpoint] -p #Create a database create database [new_db_name]; #Import mysql -h[rds_endpoint] -u[db_user] -p [new_db_name] 《 ~/auto_test_2020-12-14.sql
All the methods mentioned in the video are free to achieve the goal but not the best way to your needs of zero downtime especially for large data scenario requiring incremental data transmission. We recommend using Data Transmission Service (DTS) instead. DTS can also be used to export data.
Check the following links to learn the best practices of Data Import and Export with DTS.
🚀For Data Transmission Service (DTS) billing and introduction:.
ApsaraDB - September 9, 2021
Alibaba Clouder - January 7, 2021
JDP - March 17, 2021
ApsaraDB - August 30, 2021
ApsaraDB - October 14, 2021
Alibaba Clouder - July 9, 2020
Fully managed and less trouble database servicesLearn More
Tair is a Redis-compatible in-memory database service that provides a variety of data structures and enterprise-level capabilities.Learn More
An on-demand database hosting service for MySQL with automated monitoring, backup and disaster recovery capabilitiesLearn More
Protect, backup, and restore your data assets on the cloud with Alibaba Cloud database services.Learn More
More Posts by ApsaraDB