NYCPHP Meetup

NYPHP.org

[nycphp-talk] XAMPP: Upgrading MySQL

Joe Crawford jcrawford at codebowl.com
Sat Jul 24 19:40:52 EDT 2004


Hans,

thanks for this information.

i have noticed there are some people on this list that work for
reputable companies, maybe one day i will be there ;)

Joe Crawford Jr.


On Sat, 2004-07-24 at 19:36, Hans Zaunere wrote:
> > anyone here know how hard/easy it is to upgrade the mysql version that
> > is pre-packed with XAMPP?
> 
> Not sure... certainly doable, I'd imagine, but you'd probably be getting
> into the realm of installing a separate MySQL instance on the box and
> disabling that which comes with XAMPP.
> 
> > they have version 4.0.20 and i would like to upgrade to 4.1
> 
> Be careful here... there's a major difference between the two.  Chances
> are, your code will break.
> 
> MySQL 4.1.x uses a new binary protocol, and requires the
> http://php.net/mysqli extension to work.  You can set MySQL to be
> backwards compatible, but then you'll miss the benefits of the binary
> protocol (prepared statements, no escaping, etc).
> 
> > also anyone here used the SQLite extension?  Is this better to use
> than
> > MySQL?
> 
> It really depends what you need.  In a word (and disclaimer: I work for
> MySQL :)  SQLite isn't a RDBMS.  It's strictly a local file-system based
> SQL system; it's truly a SQL enabled file system.  MySQL allows users to
> connect remotely, has much more functionality, and is much faster as
> load scales up.  If your application has any significant load,
> especially that of write-queries, you should go with MySQL.  MySQL is
> also very common on hosting platforms (more so than SQLite).
> 
> H
> 
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk
> 
> 


>From hans not junk at nyphp.com  Sat Jul 24 19:43:02 2004
Return-Path: <hans not junk at nyphp.com>
Received: from smtp11.intermedia.net (smtp11.intermedia.net [64.78.21.10])
	by virtu.nyphp.org (Postfix) with ESMTP id 40942A8633
	for <talk at lists.nyphp.org>; Sat, 24 Jul 2004 19:43:02 -0400 (EDT)
Received: from ehost011-1.exch011.intermedia.net ([64.78.21.3]) by
	smtp11.intermedia.net with Microsoft SMTPSVC(6.0.3790.0); 
	Sat, 24 Jul 2004 16:43:01 -0700
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: [nycphp-talk] $_SESSION, session_unset(), unset($_SESSION['var']),
	register_globals and the PHP Manual
Date: Sat, 24 Jul 2004 16:42:59 -0700
Message-ID: <41EE526EC2D3C74286415780D3BA9F870334B2DD at ehost011-1.exch011.intermedia.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [nycphp-talk] $_SESSION, session_unset(), unset($_SESSION['var']),
	register_globals and the PHP Manual
Thread-Index: AcRw+rKV3QO12duYQwCMg02VaPvUUwA3IbmA
From: "Hans Zaunere" <hans not junk at nyphp.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
X-OriginalArrivalTime: 24 Jul 2004 23:43:01.0730 (UTC)
	FILETIME=[F51AD420:01C471D7]
X-BeenThere: talk at lists.nyphp.org
X-Mailman-Version: 2.1.4
Precedence: list
Reply-To: NYPHP Talk <talk at lists.nyphp.org>
List-Id: NYPHP Talk <talk.lists.nyphp.org>
List-Unsubscribe: <http://lists.nyphp.org/mailman/listinfo/talk>,
	<mailto:talk-request at lists.nyphp.org?subject=unsubscribe>
List-Archive: <http://lists.nyphp.org/pipermail/talk>
List-Post: <mailto:talk at lists.nyphp.org>
List-Help: <mailto:talk-request at lists.nyphp.org?subject=help>
List-Subscribe: <http://lists.nyphp.org/mailman/listinfo/talk>,
	<mailto:talk-request at lists.nyphp.org?subject=subscribe>
X-List-Received-Date: Sat, 24 Jul 2004 23:43:02 -0000


> <?php
> unset($_SESSION['Phil']);
> header('Location: http://www.apa.org/journals/psp/psp7761121.html');
> ?>

That should have been:

<?php
unset($_SESSION['Phil']);
header('Location: http://php.net/session');
?>


Let's keep it clean





More information about the talk mailing list