Best way to import large dataset into mysql

Question

Looking for some help. I have a 300GB csv file that I need to import into a mysql database. Database is running on Centos 7.

I don't know if just doing a basic local-infile is the right way or if there is a better way. Should I split up the csv?

Any help is appreciated.

Did you take a look at [this](http://stackoverflow.com/questions/3635166/how-to-import-csv-file-to-mysql-table)? — Gurwinder Singh, Dec 24 '16 at 04:38

score -1 · Accepted Answer · answered Dec 24 '16 at 04:22

-1

You need to divide into parts and import one by one for more help check this post

Thanks

answered Dec 24 '16 at 04:22

R.K.Bhardwaj

You should provide more details in the post. Only providing links to other sites is frowned upon. [Look](http://meta.stackexchange.com/a/8259) – Gurwinder Singh Dec 24 '16 at 04:41
Thanks sir #dkeeper09 – R.K.Bhardwaj Dec 24 '16 at 05:16

1 Answers1