NYCPHP Meetup

[csnyder at chxo.com]

Quoting Hans Zaunere <hans not junk at nyphp.com>:
 
> http://dev.mysql.com/doc/mysql/en/SET_OPTION.html
> 
> SET FOREIGN_KEY_CHECKS=0;

Seems the best option in this case, thanks.


> http://dev.mysql.com/doc/mysql/en/Backing_up.html

At 390 Eu per server? I'd rather buy a MySQL license. *grin*

>From hans not junk at nyphp.com  Fri Jul  9 14:54:53 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 E5957A87DB
	for <talk at lists.nyphp.org>; Fri,  9 Jul 2004 14:54:52 -0400 (EDT)
Received: from ehost011-1.exch011.intermedia.net ([64.78.21.3]) by
	smtp11.intermedia.net with Microsoft SMTPSVC(6.0.3790.0); 
	Fri, 9 Jul 2004 11:46:24 -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] mysqldump and foreign keys on InnoDB tables
Date: Fri, 9 Jul 2004 11:54:48 -0700
Message-ID: <41EE526EC2D3C74286415780D3BA9F8702F7C650 at ehost011-1.exch011.intermedia.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [nycphp-talk] mysqldump and foreign keys on InnoDB tables
Thread-Index: AcRl5MomH5tUsAyrQvybE5ZGTheEaQAAUKZA
From: "Hans Zaunere" <hans not junk at nyphp.com>
To: "NYPHP Talk" <talk at lists.nyphp.org>
X-OriginalArrivalTime: 09 Jul 2004 18:46:24.0498 (UTC)
	FILETIME=[08EE7D20:01C465E5]
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: Fri, 09 Jul 2004 18:54:53 -0000


> > http://dev.mysql.com/doc/mysql/en/Backing_up.html
>=20
> At 390 Eu per server? I'd rather buy a MySQL license. *grin*

At the top of the link it mentions the backup product, but the rest of
the page describes how to do much of it manually.  You can do it all
with the tools included with MySQL, except for the true hot backup,
since it's an engine level thing (and specific to InnoDB).

H