Importing files > 2GB

Author: MB Software Solutions, LLC

Posted: 2012-02-21 at 20:07:45

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)

--

Mike Babcock, MCP

MB Software Solutions, LLC

President, Chief Software Architect

http://mbsoftwaresolutions.com

http://fabmate.com

http://twitter.com/mbabcock16

_______________________________________________

Post Messages to: ProFox@leafe.com

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/4F443FE1.7030701@mbsoftwaresolutions.com

** 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.

©2012 MB Software Solutions, LLC