Author: Michael Madigan
Posted: 2012-02-22 at 00:34:24
That's how I would do it, cut it in half or in quarters.
----- Original Message -----
From: "MB Software Solutions, LLC" <mbsoftwaresolutions@mbsoftwaresolutions.com>
To: ProFox Email List <profox@leafe.com>
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
_______________________________________________
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/4F4470FE.8070905@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.
_______________________________________________
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/1329888864.80272.YahooMailNeo@web125601.mail.ne1.yahoo.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.