Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.mysql > #5482

Re: XAMPP MySql on XP 6mb csv file

Show all headers | View raw

On 6/25/2014 7:08 AM, J. Clarke wrote:
> In article <loak2h$2bn$1@dont-email.me>, jstucklex@attglobal.net says...
>>
>> 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?
> 
> The only one I see around here who has a problem with reading 
> comprehension is the one who doesn't understand the question posed, 
> which is "which verson of XAMPP works on XP".
> 
> 

You just answered the question.  Now go away, troll.

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

Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

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