DB

Recommended way of moving DB in AWS(RDS)

Recommended way of moving DB in AWS(RDS)

How can we apply data from local environment to RDS of AWS.
Moving data is a problem for AWS beginner.
So this article shows recommended way of moving DB in AWS(RDS).



How to move DB

Regarding AWS site, it is recommended to export and import.

To import data from an existing database to an RDS DB instance:
1. Export data from the source database.
2. Upload the exported data.
3. Import the uploaded data into an RDS DB instance.
Amazon RDS Import Data

It is written like using a command-line utility. It means to use mysqldump command.

You can use several different techniques to import data into an Amazon RDS for MySQL DB instance. The best approach depends on the source of the data, the amount of data, and whether the import is done one time or is ongoing.
[Source] Existing MySQL or MariaDB database
[Technique] Copy the data directly to your Amazon RDS MySQL DB instance using a command-line utility.
Importing Data into a MySQL DB Instance - Amazon Relational Database Service


Using GUI instead of command

If you use tool, I recommend you to use MySQL Workbench.
You can execute this 2 steps.

  1. Connect source DB (local). Then export data.
  2. Connect destination DB. Then import data.


Finally

  • For moving data to AWS(RDS), it is recommended to export and import.
  • If you use tool, I recommend you to use MySQL Workbench.


コチラもオススメ

KRSW

駆け出し機械学習エンジニア。機械学習、DB、WEBと浅く広い感じ。 Junior machine learning engineer. Not a specialist but a generalist who knows DB, WEB too.

If you felt this article is useful, please share.

にほんブログ村 IT技術ブログへ

-DB
-, ,

Translate »

Copyright© ITips , 2020 All Rights Reserved.