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

Groups > comp.databases.mysql > #5415 > unrolled thread

XAMPP MySql on XP 6mb csv file

Back to article view | Back to comp.databases.mysql

Contents

  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

Page 2 of 2 — ← Prev page 1 [2]

#5481

In article <28677317.keV2ABPPcp@PointedEars.de>, PointedEars@web.de 
says...
> 
> J. Clarke wrote:
> ^^
> Please add your first name.

I have been "J. Clarke" for more than 20 years now and I am not going to 
change because some net whiner says so.

> > In article <3753568.iRdZ5AsjcD@PointedEars.de>, PointedEars@web.de
> > says...
> 
> It's attribution *line*, _not_ attribution novel.

Pity.
  
> >> vjp2.at@at.BioStrategist.dot.dot.com wrote:
> >> > Which version of XAMPP works on XP?
> >> 
> >> Hopefully, none.
> > 
> > Then your hope is dashed.  From the README for XAMPP 1.8.2:
> > 
> > "* System Requirements:
> >  
> >   + 64 MB RAM (RECOMMENDED)
> >   + 750 MB free fixed disk
> >   + Windows 2003, XP (RECOMMENDED), VISTA, Windows 7"
> 
> That README needs an update.

Then I suggest you inform the maintainers.
  
> >> 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.
> > 
> > 1.8.2 includes Apache 2.4.9, which according to the Apache site is the
> > latest stable release, MySQL 5.5.36 which is one release back from the
> > current one, and PHP 5.4.27, again one release back.  These are hardly
> > the outdated antiques that you suggest.  XP has only been EOL for two
> > months you know.
> 
> Please do not write about things you do not understand.

Such as?  What I understand clearly is that you are an idiot-savant who 
seems to know a great deal about ECMAscript and a lot of trivia about 
the latest releases of everything but very little about the practical 
operation of systems in the real world.
 
> Windows XP Service Pack 3 (the latest one) is strongly recommended for 
> running Apache 2.4 on Windows XP:
> 
> <http://mirror.switch.ch/mirror/apache/dist//httpd/binaries/win32/README.html>

So you admit that it runs on XP.  Or perhaps you believe that obtaining 
Service Pack 3 for XP is an insurmountable obstacle?  If so you should 
learn something about Microsoft before you shoot off your ignorant 
mouth.  <http://www.microsoft.com/en-us/download/details.aspx?id=24>
 
> The current MySQL Community Server GA release is 5.6.19, released 
> 2014-05-30.  The latest MySQL Community Server GA release for 5.5.x is 
> 5.5.38 of 2014-05-30.  5.5.36 was released on 2014-01-31.

And so the utility of 5.5.36 is forever destroyed?  Do tell us what 
specific  horrible thing will happen if one runs 5.5.36 vs 5.5.38.
 
> <http://dev.mysql.com/doc/relnotes/mysql/5.5/en/>
> <http://dev.mysql.com/doc/relnotes/mysql/5.6/en/>
> 
> The latest stable PHP version is PHP 5.5.13, released 2014-05-29, which 
> fixes several bugs, and security vulnerabilities CVE-2014-0238 and 
> CVE-2014-0237.  The latest version of PHP 5.4.x is 5.4.29, to which the same 
> applies.  PHP 5.4.28 fixes several bugs as well.  Finally, PHP support for 
> Windows XP and 2003 has been discontinued as of PHP 5.5.0 (2013-06-20).

And this prevents 5.4.29 from running because?

You really need to get this bug about "Microsoft support" out of your 
system.

[toc] | [prev] | [next] | [standalone]

#5486

J. Clarke wrote:

> [Thomas 'PointedEars' Lahn] says...
>> J. Clarke wrote:
>> >> vjp2.at@at.BioStrategist.dot.dot.com wrote:
>> >> > Which version of XAMPP works on XP?
>> >> Hopefully, none.
>> > 
>> > Then your hope is dashed.  From the README for XAMPP 1.8.2:
>> > 
>> > "* System Requirements:
>> >  
>> >   + 64 MB RAM (RECOMMENDED)
>> >   + 750 MB free fixed disk
>> >   + Windows 2003, XP (RECOMMENDED), VISTA, Windows 7"
>> 
>> That README needs an update.
> 
> Then I suggest you inform the maintainers.

You go ahead bothering them about the README of an outdated version that you 
suggested.
   
>> Windows XP Service Pack 3 (the latest one) is strongly recommended for
>> running Apache 2.4 on Windows XP:
>> 
>> 
<http://mirror.switch.ch/mirror/apache/dist//httpd/binaries/win32/README.html>
> 
> So you admit that it runs on XP.

There is nothing to admit as the opposite was not claimed.

> Or perhaps you believe that obtaining Service Pack 3 for XP is an
> insurmountable obstacle?

No, but it will be harder to get as time passes.  It is not logical that 
Microsoft would provide the Windows XP Service Pack 3 download indefinitely 
now that they have discontinued Windows XP Service Pack 3 support, which 
they BTW announced more than a year ago (because Service Pack 3 is that 
old).

And the security vulnerabilities in Service Pack 3 will not be fixed.

> If so you should learn something about Microsoft before you shoot off your
> ignorant mouth.
> <http://www.microsoft.com/en-us/download/details.aspx?id=24>

As for ignorant mouth, …
  
>> The current MySQL Community Server GA release is 5.6.19, released
>> 2014-05-30.  The latest MySQL Community Server GA release for 5.5.x is
>> 5.5.38 of 2014-05-30.  5.5.36 was released on 2014-01-31.
> 
> And so the utility of 5.5.36 is forever destroyed?  Do tell us what
> specific  horrible thing will happen if one runs 5.5.36 vs 5.5.38.

… learn to read:
  
>> <http://dev.mysql.com/doc/relnotes/mysql/5.5/en/>
>> <http://dev.mysql.com/doc/relnotes/mysql/5.6/en/>
>> 
>> The latest stable PHP version is PHP 5.5.13, released 2014-05-29, which
>> fixes several bugs, and security vulnerabilities CVE-2014-0238 and
>> CVE-2014-0237.  The latest version of PHP 5.4.x is 5.4.29, to which the
>> same applies.  PHP 5.4.28 fixes several bugs as well.  Finally, PHP
>> support for Windows XP and 2003 has been discontinued as of PHP 5.5.0
>> (2013-06-20).
> 
> And this prevents 5.4.29 from running because?

It does not prevent PHP 5.4.29 from running, but it makes running PHP 5.4.27 
as in XAMPP 1.8.2 a liability:

<https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2014-0237>
<https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2014-0238>

And XAMPP 1.8.3 contains PHP 5.5.x which does not support Windows XP.

It might be possible to install the old XAMPP version on Windows XP and 
upgrade PHP and all other outdated parts to a working setup.  But if you can 
do that you do not need XAMPP in the first place, yes?
 
> You really need to get this bug about "Microsoft support" out of your
> system.

You really need to get a minimum clue, especially about computer security.

*PLONK*, F'up2 poster

-- 
PointedEars

Twitter: @PointedEars2
Please do not Cc: me. / Bitte keine Kopien per E-Mail.

[toc] | [prev] | [next] | [standalone]

#5457

On 23/06/14 00:23, 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.
>
> Which version of XAMPP works on XP?

Some outdated version which was released while MS-Windows-XP was still 
supported by Microsoft. This version will most likely have other 
security related issues, there been a few nasty ones in old versions of 
PHP, MySQL and Apache.

I would recommend you to do as Jerry already said, upgrade, you have 
plenty of options at distrowatch.com if you don't want to spend money on 
buying a new version of microsoft product.


> Can it import a 6MB text file?

Sure you can.


-- 

  //Aho

[toc] | [prev] | [next] | [standalone]

#5474

In article <c0u4rmFc1ocU1@mid.individual.net>, user@example.net says...
> 
> On 23/06/14 00:23, 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.
> >
> > Which version of XAMPP works on XP?
> 
> Some outdated version which was released while MS-Windows-XP was still 
> supported by Microsoft. This version will most likely have other 
> security related issues, there been a few nasty ones in old versions of 
> PHP, MySQL and Apache.

Just to be clear, you are saying tha there are nasty security related 
issues in two-month-old versions of PHP, MySQL, and Apache?

[toc] | [prev] | [next] | [standalone]

#5479

On Wed, 25 Jun 2014 07:36:02 -0400, J. Clarke wrote:
> In article <c0u4rmFc1ocU1@mid.individual.net>, user@example.net says...
>> Some outdated version which was released while MS-Windows-XP was still 
>> supported by Microsoft. This version will most likely have other 
>> security related issues, there been a few nasty ones in old versions of 
>> PHP, MySQL and Apache.
>
> Just to be clear, you are saying tha there are nasty security related 
> issues in two-month-old versions of PHP, MySQL, and Apache?

Just to be clear, you are saying that you have an XAMPP installation
using current version of the included components that works on Windows
XP?

-- 
86. I will make sure that my doomsday device is up to code and properly 
    grounded.
	--Peter Anspach's list of things to do as an Evil Overlord

[toc] | [prev] | [next] | [standalone]

#5480

J. Clarke wrote:
^^

> […] user@example.net says...
>> On 23/06/14 00:23, vjp2.at@at.BioStrategist.dot.dot.com wrote:
>> > Which version of XAMPP works on XP?
>> 
>> Some outdated version which was released while MS-Windows-XP was still
>> supported by Microsoft. This version will most likely have other
>> security related issues, there been a few nasty ones in old versions of
>> PHP, MySQL and Apache.
> 
> Just to be clear, you are saying tha there are nasty security related
> issues in two-month-old versions of PHP, MySQL, and Apache?

Yes, and I second that at least for PHP.  See my other answer.

-- 
PointedEars

Twitter: @PointedEars2
Please do not Cc: me. / Bitte keine Kopien per E-Mail.

[toc] | [prev] | [next] | [standalone]

#5484

In article <1670230.1bNPDtH8kO@PointedEars.de>, PointedEars@web.de 
says...
> 
> J. Clarke wrote:
> ^^
> 
> > [?] user@example.net says...
> >> On 23/06/14 00:23, vjp2.at@at.BioStrategist.dot.dot.com wrote:
> >> > Which version of XAMPP works on XP?
> >> 
> >> Some outdated version which was released while MS-Windows-XP was still
> >> supported by Microsoft. This version will most likely have other
> >> security related issues, there been a few nasty ones in old versions of
> >> PHP, MySQL and Apache.
> > 
> > Just to be clear, you are saying tha there are nasty security related
> > issues in two-month-old versions of PHP, MySQL, and Apache?
> 
> Yes, and I second that at least for PHP.  See my other answer.

You have only come up with examples from PHP and those were fixed in a 
release that runs on XP so what is your point other than the one on your 
ears?

[toc] | [prev] | [next] | [standalone]

#5485

J. Clarke wrote:
^^

> In article <1670230.1bNPDtH8kO@PointedEars.de>, PointedEars@web.de
> says...

Sigh. [psf 10.1]  Which part of “first name” and “attribution _line_” did 
you not understand?

>> J. Clarke wrote:
>> > [?] user@example.net says...
>> >> On 23/06/14 00:23, vjp2.at@at.BioStrategist.dot.dot.com wrote:
>> >> > Which version of XAMPP works on XP?
>> >> 
>> >> Some outdated version which was released while MS-Windows-XP was still
>> >> supported by Microsoft. This version will most likely have other
>> >> security related issues, there been a few nasty ones in old versions
>> >> of PHP, MySQL and Apache.
>> > 
>> > Just to be clear, you are saying tha there are nasty security related
>> > issues in two-month-old versions of PHP, MySQL, and Apache?
>> 
>> Yes, and I second that at least for PHP.  See my other answer.
> 
> You have only come up with examples from PHP and those were fixed in a
> release that runs on XP so what is your point other than the one on your 
> ears?

I have answered your question.  There *are* “nasty security related issues
in two-month-old versions of PHP”, particularly in the PHP version that is 
contained in the XAMPP version that you suggested (1.8.2).

And the next XAMPP version (1.8.3) contains a PHP version that does not 
support Windows XP anymore, confirmed by your own observations in 
<news:MPG.2e14770caf8edcad98a7a0@news.newsguy.com>.

So, what is *your* point?

-- 
PointedEars

Twitter: @PointedEars2
Please do not Cc: me. / Bitte keine Kopien per E-Mail.

[toc] | [prev] | [next] | [standalone]

#5469

In article <lo7l18$pso$1@reader1.panix.com>, 
vjp2.at@at.BioStrategist.dot.dot.com says...
> 
> 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.

It appears that with 1.8.3 XAMPP went to the Visual C++ 2013 runtime 
that does not work with XP.  1.8.2 uses the Visual C++ 2008 runtime 
which should work fine with XP.

1.8.2 and 1.8.3 both use Apache 2.4.9 but 1.8.2 uses MySQL 5.5 vs 5.6 in 
1.8.3 and PHP 5.4 vs 5.5.

[toc] | [prev] | [standalone]

Page 2 of 2 — ← Prev page 1 [2]

Back to top | Article view | comp.databases.mysql

csiph-web