MySQL Forums :: Newbie :: uploading 300+MB files to MySQL db


Advanced Search

uploading 300+MB files to MySQL db
Posted by: B A ()
Date: November 07, 2011 08:36PM

hi, I have 5 .csv data files that are approx. 300MB+ in size and I need to write the data to MySQL tables to do my analysis.
I have written a perl program but unfortunately, even after 5 hours, it has only uploaded 75MB in the first file.
Could someone please recommend a faster way of uploading the data into the DB. thx!

Options: ReplyQuote


Subject Written By Posted
uploading 300+MB files to MySQL db B A 11/07/2011 08:36PM
Re: uploading 300+MB files to MySQL db Peter Brawley 11/07/2011 10:12PM
Re: uploading 300+MB files to MySQL db B A 11/08/2011 06:28PM
Re: uploading 300+MB files to MySQL db Peter Brawley 11/08/2011 06:50PM
Re: uploading 300+MB files to MySQL db Barry Galbraith 11/08/2011 08:03PM
Re: uploading 300+MB files to MySQL db B A 11/09/2011 05:37PM
Re: uploading 300+MB files to MySQL db Shawn Taylor 11/09/2011 09:08AM
Re: uploading 300+MB files to MySQL db B A 11/09/2011 05:39PM
Re: uploading 300+MB files to MySQL db Rick James 11/12/2011 02:09PM
Re: uploading 300+MB files to MySQL db B A 11/17/2011 05:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.