On 2014-09-04 12:17, Virgil Bierschwale wrote: <snipped>
Been having a hard time trying to upload a 442,000 record spreadsheet to mysql, so I wanted to figure out what was wrong by doing it on my box where I have more control over it.
I would suggest you export the spreadsheet to a CSV file and use the LOAD INFILE (usually there's a GUI screen for it to make it easy). I upload tens of millions of rows this way and it works very well and quick.
_______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
