That's how I would do it, cut it in half or in quarters.
----- Original Message ----- From: "MB Software Solutions, LLC" <[email protected]> To: ProFox Email List <[email protected]> Cc: Sent: Tuesday, February 21, 2012 11:37 PM Subject: Re: Importing files > 2GB On 2/21/2012 8:07 PM, MB Software Solutions, LLC wrote: > What do you do when you have to import a text file that equates to a > cursor/table too big (beyond 2GB)? I'm using MySQL's import which is > fine for such huge beasts, but the import isn't liking some of the field > formats (related to my last post but not exactly that) and so I was > going to use VFP as the intermediary to massage/fix the data, then put > it into the MySQL table. > > Ideas? tia, > --Mike > > (VFP9SP2) > I know I could physically cut the file in half (or more pieces) and import that way then insert the parts to the final MySQL table, but I wondered if anyone had other ideas? tia, --Mike -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://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. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://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.
