CODEWITHSUNDEEP
mysqldatabaseamazon-web-services
Jingci Wang
Jingci Wang

Reputation: 11

How to copy a database from my laptop into AWS

I have defined a schema and populated with data into MySql on my laptop. 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.

Upvotes: 0

Views: 46

Answers (2)

Harsh Manvar
Harsh Manvar

Reputation: 30178

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.

Upvotes: 1

Icehorn
Icehorn

Reputation: 1347

You may be interested in AWS Database Migration Service.

Upvotes: 1

Related Questions