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

Groups > comp.databases.mysql > #5420

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-23 01:33 +0000
Organization A noiseless patient Spider
Message-ID <lo804u$3mv$1@dont-email.me> (permalink)
References <lo7l18$pso$1@reader1.panix.com>

Show all headers | View raw

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.
> 
> Which version of XAMPP works on XP?
> 
> Can it import a 6MB text file?
> 
> Do any of the above techniques make sence or need improvement?

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.

6Mb of data is easy for mysql.

You could try mariadb which is allegedly mysql compatible and claims to 
install on xp:

https://mariadb.com/kb/en/installing-mariadb-msi-packages-on-windows/

(mariadb is a fork of mysql by people who don't think oracle should be 
running the FOSS mysql project. I make no comment on the politics of it.)

-- 
Denis McMahon, denismfmcmahon@gmail.com

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