Re: XAMPP MySql on XP 6mb csv file

From	Jerry Stuckle <jstucklex@attglobal.net>
Newsgroups	comp.databases.mysql
Subject	Re: XAMPP MySql on XP 6mb csv file
Date	2014-06-23 21:25 -0400
Organization	A noiseless patient Spider
Message-ID	<loak2h$2bn$1@dont-email.me> (permalink)
References	<lo7l18$pso$1@reader1.panix.com> <lo7ti1$g1o$1@dont-email.me> <183dl0wxwb5f2$.gasabhefnsox$.dlg@40tude.net> <lo9q6g$bh5$1@dont-email.me> <MPG.2e129b4f5c0986c298a78e@news.newsguy.com>

Show all headers | View raw

On 6/23/2014 9:15 PM, J. Clarke wrote:
> In article <lo9q6g$bh5$1@dont-email.me>, jstucklex@attglobal.net says...
>>
>> On 6/23/2014 1:19 PM, richard wrote:
>>> On Sun, 22 Jun 2014 20:49:06 -0400, Jerry Stuckle wrote:
>>>
>>>> On 6/22/2014 6:23 PM, vjp2.at@at.BioStrategist.dot.dot.com wrote:
>>>>> I have a 6MB csv file, 15 million records. I need to put it into an SQL
>>>>> database on XP. I got XAMPP but it says I need an earlier version for XP.
>>>>> About half the fields are not needed, so I can see the actual input data
>>>>> being less, assuming it imports one line at a time. I have broken it into 1MB
>>>>> chunks using GNU32 split. I can also limit the data by excluding the records
>>>>> with some fields beyond a certain value if I could do that during import, or
>>>>> before merging the chunks.
>>>>>
>>>>
>>>> XP is no longer supported, per Microsoft.  The first thing you need to
>>>> do is upgrade to a supported OS.
>>>>
>>>>> Which version of XAMPP works on XP?
>>>>>
>>>>
>>>> See above.
>>>>
>>>>
>>>>> Can it import a 6MB text file? 
>>>>>
>>>>
>>>> MySQL will handle a 6MB file quite nicely.  In fact, it's a pretty small
>>>> file.  6TB might be a bit more complicated.
>>>>
>>>>> Do any of the above techniques make sence or need improvement?
>>>>>
>>>>
>>>> First of all, upgrade to a supported OS.  You can still install MySQL
>>>> (either with XAMPP or separately), but the fact is - you need to update
>>>> your OS.
>>>>
>>>>> 				    - = -
>>>>>  Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
>>>>> 		    http://www.panix.com/~vjp2/vasos.htm
>>>>>   ---{Nothing herein constitutes advice.  Everything fully disclaimed.}---
>>>>>    [Homeland Security means private firearms not lazy obstructive guards]
>>>>>  [Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>> Do you know how to comprehend what was asked?
>>> Xampp has been around for some 20 years.
>>> So there is a version out there for XP.
>>> Why should he spend big bucks just to make xaampp work on a system he does
>>> not want?
>>>
>>> Hell, Xampp was available for windows 95 even.
>>> And here you are DEMANDING he change his OS.
>>> Horsehockey!
>>>
>>
>> I'm not demanding he change his OS, stoopid.  Microsoft is.  They no
>> longer support it.  The fact this was going to happen has been well
>> documented for a couple of years.
> 
> Since MySQL is not a Microsoft product, please explain how the 
> willingness of Microsoft to support or not support something is 
> relevant.  If he were asking about SQL Server it would be a different 
> matter.
> 

Are you a troll, or do you have problems with reading comprehension?

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex@attglobal.net
==================

Thread

XAMPP MySql on XP 6mb csv file vjp2.at@at.BioStrategist.dot.dot.com - 2014-06-22 22:23 +0000
  Re: XAMPP MySql on XP 6mb csv file Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-22 20:49 -0400
    Re: XAMPP MySql on XP 6mb csv file richard <noreply@example.com> - 2014-06-23 13:19 -0400
      Re: XAMPP MySql on XP 6mb csv file Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-23 14:04 -0400
        Re: XAMPP MySql on XP 6mb csv file "J. Clarke" <jclarkeusenet@cox.net> - 2014-06-23 21:15 -0400
          Re: XAMPP MySql on XP 6mb csv file Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-23 21:25 -0400
            Re: XAMPP MySql on XP 6mb csv file "J. Clarke" <jclarkeusenet@cox.net> - 2014-06-25 07:08 -0400
              Re: XAMPP MySql on XP 6mb csv file Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-25 09:48 -0400
  Re: XAMPP MySql on XP 6mb csv file Michael Vilain <vilain@NOspamcop.net> - 2014-06-22 18:10 -0700
  Re: XAMPP MySql on XP 6mb csv file Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-23 01:33 +0000
    Re: XAMPP MySql on XP 6mb csv file vjp2.at@at.BioStrategist.dot.dot.com - 2014-06-23 07:56 +0000
      Re: XAMPP MySql on XP 6mb csv file "J. Clarke" <jclarkeusenet@cox.net> - 2014-06-23 21:21 -0400
        Re: XAMPP MySql on XP 6mb csv file Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-23 21:28 -0400
          Re: XAMPP MySql on XP 6mb csv file "J. Clarke" <jclarkeusenet@cox.net> - 2014-06-25 07:18 -0400
            Re: XAMPP MySql on XP 6mb csv file Jerry Stuckle <jstucklex@attglobal.net> - 2014-06-25 09:49 -0400
    Re: XAMPP MySql on XP 6mb csv file "J. Clarke" <jclarkeusenet@cox.net> - 2014-06-25 07:17 -0400
      Re: XAMPP MySql on XP 6mb csv file Denis McMahon <denismfmcmahon@gmail.com> - 2014-06-25 20:34 +0000
  Re: XAMPP MySql on XP 6mb csv file Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-24 21:21 +0200
    Re: XAMPP MySql on XP 6mb csv file "J. Clarke" <jclarkeusenet@cox.net> - 2014-06-25 07:33 -0400
      Re: XAMPP MySql on XP 6mb csv file Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-25 14:52 +0200
        Re: XAMPP MySql on XP 6mb csv file "J. Clarke" <jclarkeusenet@cox.net> - 2014-06-25 09:35 -0400
          Re: XAMPP MySql on XP 6mb csv file Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-25 16:51 +0200
  Re: XAMPP MySql on XP 6mb csv file "J.O. Aho" <user@example.net> - 2014-06-24 22:20 +0200
    Re: XAMPP MySql on XP 6mb csv file "J. Clarke" <jclarkeusenet@cox.net> - 2014-06-25 07:36 -0400
      Re: XAMPP MySql on XP 6mb csv file "Peter H. Coffin" <hellsop@ninehells.com> - 2014-06-25 07:51 -0500
      Re: XAMPP MySql on XP 6mb csv file Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-25 14:58 +0200
        Re: XAMPP MySql on XP 6mb csv file "J. Clarke" <jclarkeusenet@cox.net> - 2014-06-25 09:52 -0400
          Re: XAMPP MySql on XP 6mb csv file Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2014-06-25 16:29 +0200
  Re: XAMPP MySql on XP 6mb csv file "J. Clarke" <jclarkeusenet@cox.net> - 2014-06-25 07:05 -0400

csiph-web