[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