What is the best way to import bulk data to MySql table on AWS RDS


I have a MySQL database in AWS RDS. I want to import bulk data in to table in database. which contains thousands of rows. I need to do it from my website with also deployed in AWS. Web is developed using ASP.Net MVC.

What is the best ways to achieve this

1 Answer

Hello, The best way to import bulk data into AWS RDS MySQL is depends on the source of the data, the amount of data, whether the import is done one time or is ongoing, and the amount of downtime a business can afford.

You can check AWS documentation to find techniques to import data into an RDS for MySQL DB instance. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.Other.html

Some useful link to improve performance of your bulk data import - https://aws.amazon.com/blogs/database/improve-performance-of-your-bulk-data-import-to-amazon-rds-for-mysql/

answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions