From owner-freebsd-questions Tue Dec 17 1:28:41 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id B8EE837B401 for ; Tue, 17 Dec 2002 01:28:40 -0800 (PST) Received: from smtp-relay01.tc.dsvr.net (smtp-relay01.tc.dsvr.net [212.69.192.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id D2DF643E4A for ; Tue, 17 Dec 2002 01:28:39 -0800 (PST) (envelope-from james@stealthnet.co.uk) Received: from [212.69.208.113] (helo=stealthnet.co.uk) by smtp-relay01.tc.dsvr.net with esmtp (Exim 3.33 #3) id 18OE1l-0006sQ-00; Tue, 17 Dec 2002 09:28:37 +0000 Received: from stealthnet.co.uk (hidden-user@[81.6.195.82]) by stealthnet.co.uk (8.11.6/8.11.6) with ESMTP id gBH9SbT12160; Tue, 17 Dec 2002 09:28:37 GMT Message-ID: <3DFEEE41.2090604@stealthnet.co.uk> Date: Tue, 17 Dec 2002 09:28:33 +0000 From: James Green User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Khairil Yusof Cc: questions@freebsd.org Subject: Re: portupgrading mysql-server References: <3DFDD928.1060901@stealthnet.co.uk> <1040047923.478.10.camel@daemon.home.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Khairil Yusof wrote: >On Mon, 2002-12-16 at 21:46, James Green wrote: > > >>How does one portupgrade mysql-server without having to dump it's >>databases first? If you're running a busy server with hundreds of megs >>of databases I'm sure the admin wouldn't want to dump, uninstall, >>install newest, then restore the databases, particularly if like me he's >>merely putting a security fixed release in. >> >> > >portupgrade -m '-DSKIP_INSTALL_DB' mysql-server > >You might not need to reinstall the server, but it's strongly advised >you dump it first anyway in case something goes wrong. ;) > > Thanks for the advice, our upgrade went smoothly using this instructions. James To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message