migrate database from my local to AWS

Question

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.

Accepted Answer

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.

Answer

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

migrate database from my local to AWS

相關內容