migrate database from my local to AWS

0

I have schema and populated with data into MySql on my local machine. However, due to the large-scale of the datasets, the computing time suffers in the following analysis stage in python. So I decide to try to move all my work to cloud. I'm wondering if there is anyway to let the server in AWS directly connect to the mysql server in my laptop so that I can use the existing datasets without recollect them.

トピック

移行と近代化分析データベース

タグ

Amazon Relational Database Service (RDS)

言語

English

質問済み 5年前244ビュー

2回答

新しい順
投票が多い順
コメントが多い順

これらの回答は役に立ちましたか？コミュニティがあなたの知識を活用できるように、正解に賛成票を投じてください。

0

承認された回答

You can use DMS database migration service of aws which will do everything for you.

https://aws.amazon.com/dms/

But you have to take care about foreign key and other data. sometime it is generating the error.

DMS will transfer all of your data from laptop to aws database which will be on RDS or you can choose.

回答済み 5年前

0

There are several options:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.External.Repl.html

You might want to consider replicating from your laptop directly into an RDS instance:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.Other.html

-Phil

モデレーター

回答済み 5年前

関連するコンテンツ