Re: XAMPP MySql on XP 6mb csv file

From	Denis McMahon <denismfmcmahon@gmail.com>
Newsgroups	comp.databases.mysql
Subject	Re: XAMPP MySql on XP 6mb csv file
Date	2014-06-25 20:34 +0000
Organization	A noiseless patient Spider
Message-ID	<lofbnp$sdo$1@dont-email.me> (permalink)
References	<lo7l18$pso$1@reader1.panix.com> <lo804u$3mv$1@dont-email.me> <MPG.2e1479bf2db011c898a7a2@news.newsguy.com>

Show all headers | View raw

On Wed, 25 Jun 2014 07:17:06 -0400, J. Clarke wrote:

> In article <lo804u$3mv$1@dont-email.me>, denismfmcmahon@gmail.com
> says...
>> 
>> On Sun, 22 Jun 2014 22:23:36 +0000, vjp2.at 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.

>> It may be possible to find an earlier version of mysql that will run
>> under XP, but you may need to hunt for it. You don't need the *ampp
>> unless you also want the webserver and various script interpreters.

> There's no need to "hunt for it".  Just go to the XAMPP sourceforge site
> and download what you need.  The earliest Windows version they have
> available for download is 0.9, dated 2003-07-27.  The most recent
> version is 1.8.3 dated 2014-04-10.  1.8.2 should be fine on XP--they
> changed to the newer Microsoft runtime with 1.8.3.

Note that the OP's stated requirement is for a database that can manage 
this data, it's not clear that he needs the webserver or scripting 
components of most *ampp packages.

Whilst Jerry's concerns might be valid, it is really up to the OP to 
determine if their environment is appropriate for their needs, and this 
includes upgrading the OS as needed.

If the OP just wants a database without all the bells and whistles of a 
*ampp, I still suggest mariadb which is touted as a drop in replacement 
for mysql and has an XP compatible installer.

-- 
Denis McMahon, denismfmcmahon@gmail.com

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