In this video tutorial, you will be able to learn how to import data from ECS-hosted MySQL or on-premise MySQL to ApsaraDB RDS for MySQL through both CLI and Alibaba Cloud Data Management (DMS).
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.
π1. Import/Migration:
https://www.alibabacloud.com/help/en/apsaradb-for-rds/latest/t2118579
π2. Export/Download:
https://www.alibabacloud.com/help/en/data-transmission-service/latest/migrate-data-from-an-apsaradb-rds-for-mysql-instance-to-a-self-managed-mysql-database
πFor Data Transmission Service (DTS) billing and introduction:.
https://www.alibabacloud.com/product/data-transmission-service
The Basic Use of RDS (Part 2): Build LAMP Applications With ApsaraDB RDS for MySQL
The Basic Use of RDS (Part 4): Introduction To ApsaraDB RDS MySQL Series
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
ApsaraDB: Faster, Stronger, More Secure
Learn MoreAlibaba Cloud PolarDB for MySQL is a cloud-native relational database service 100% compatible with MySQL.
Learn MoreTair is a Redis-compatible in-memory database service that provides a variety of data structures and enterprise-level capabilities.
Learn MoreAn on-demand database hosting service for MySQL with automated monitoring, backup and disaster recovery capabilities
Learn MoreMore Posts by ApsaraDB