Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.mysql > #5456
| From | Thomas 'PointedEars' Lahn <PointedEars@web.de> |
|---|---|
| Newsgroups | comp.databases.mysql |
| Subject | Re: XAMPP MySql on XP 6mb csv file |
| Date | 2014-06-24 21:21 +0200 |
| Organization | PointedEars Software (PES) |
| Message-ID | <3753568.iRdZ5AsjcD@PointedEars.de> (permalink) |
| References | <lo7l18$pso$1@reader1.panix.com> |
vjp2.at@at.BioStrategist.dot.dot.com wrote:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
The “From” header field value must contain a proper e-mail address; it also
should contain your real name.
> 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.
<http://windows.microsoft.com/en-us/windows/end-support-help>
> 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.
You can pick the fields which to import.
> Which version of XAMPP works on XP?
Hopefully, none. But there are probably outdated, unsupported versions (of
Apache, MySQL, PHP, and Perl) interspersed with security vulnerabilities
that would still work. You do not want to use them.
> Can it import a 6MB text file?
Yes.
> Do any of the above techniques make sence or need improvement?
^s
Yes.
> - = -
Should be hyphen-hyphen-space.
> [signature]
Should be no longer than 4 lines.
--
PointedEars
Twitter: @PointedEars2
Please do not Cc: me. / Bitte keine Kopien per E-Mail.
Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll 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