I don't know how long, but. Using fgets, you can get each line. Parse that, and place into a vfp table/cursor. Once you have a large group,. under the 2G barrier, post to mySQL. Zap the VFP table/cursor. Pick up your low level file read, and repeat.
Might work? Mike On 21/02/2012 11:37 PM, MB Software Solutions, LLC wrote: > 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 > _______________________________________________ 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.
