File Transfer is extremely slow between Large CSV file to MySql

[Jayasuryan]

Hi Folks,

I am looking for help with my assignment. The assignment is that I should transfer all the rows in a CSV file which has half a million records(500K rows) into a single table in a Database. Since I have MySql installed in my system, I am trying to transfer those records into it. But the transfer is extremely slow. Could you please provide any suggestions for making the transfer fast or any other ideas? Thanks in advance.

Input : CSV File (86MB) (500K records)

Output: Single table in MySql

ODBC driver: Mysql ODBC 8.0 Unicode Driver (64bit)

[604c6bff826fd3151089]

Hii

I hope you are doing well.

Please share the solution of your assignment, all the 5 questions you have mentioned in our replies.

I am facing the same problem. Thanks in advance

[vaibhavcr7]

Can you send me the solution for this assignment please.

crvaibhav717@gmail.com