I have a 70Mb csv with 1.5 million rows with 270 columns and I would like to put it into a MySQL database that is hosted on AWS RDS with the minimum layer. I try to do it with the MySQL Workbench widget locally. But it took me 1 hour to ingest 100 lines. So it will take me 2 years if I do it this way.

Do you know another way to efficiently ingest a CSV on a MySQL instance hosted on AWS?

I tried to do it with an EC2 and using. I have transferred the file to the machine and I am now trying with mysqlimport but I don't have it (yet)

 mysqlimport: command not found

I tried to install it but it seems to be complicated:

[ec2-user@ip-172-31-8-193 ~]$ sudo yum install mysqlimport
Loaded plugins: extras_suggestions, langpacks, priorities, update-motd
amzn2-core                                               | 3.7 kB     00:00
amzn2extra-docker                                        | 3.0 kB     00:00
amzn2extra-kernel-5.10                                   | 3.0 kB     00:00
No package mysqlimport available.

I am now wondering if I should do it locally ...


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.