Γ—
Community Blog The Basic Use of RDS (Part 3): Import & Export To and From ApsaraDB RDS for MySQL

The Basic Use of RDS (Part 3): Import & Export To and From ApsaraDB RDS for MySQL

In this video tutorial, we will introduce how to import data from ECS-hosted MySQL or on-premise MySQL to ApsaraDB RDS for MySQL through CLI and Alibaba Cloud Data Management Service.

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.

Key Insights

πŸ”₯ 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

Video Demo

More Information

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

0 0 0
Share on

ApsaraDB

261 posts | 24 followers

You may also like

Comments