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 ...