From owner-freebsd-questions@FreeBSD.ORG Fri Aug 29 13:19:31 2003 Return-Path: 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 7C9F916A4BF for ; Fri, 29 Aug 2003 13:19:31 -0700 (PDT) Received: from franklin-belle.com (adsl-65-68-247-73.dsl.crchtx.swbell.net [65.68.247.73]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0CF1143FE0 for ; Fri, 29 Aug 2003 13:19:29 -0700 (PDT) (envelope-from jackstone@sage-one.net) Received: from sagea (sagea.sage-american [10.0.0.3]) by franklin-belle.com (8.12.8p1/8.12.8) with SMTP id h7TKJRlP024493; Fri, 29 Aug 2003 15:19:28 -0500 (CDT) (envelope-from jackstone@sage-one.net) Message-Id: <3.0.5.32.20030829151935.01394798@sage-one.net> X-Sender: jackstone@sage-one.net X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.5 (32) Date: Fri, 29 Aug 2003 15:19:35 -0500 To: Michelle , freebsd-questions@freebsd.org From: "Jack L. Stone" In-Reply-To: <75C451F8-DA52-11D7-8C70-000393843210@mindspring.com> References: <001e01c36e54$164e14f0$6501a8c0@croydon> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Spam-Status: No, hits=-1.7 required=4.5 tests=AWL,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES, REPLY_WITH_QUOTES version=2.55-fbelle.rules_v1 X-Spam-Checker-Version: SpamAssassin 2.55-fbelle.rules_v1 (1.174.2.19-2003-05-19-exp) Subject: Re: upgrading mysql X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 29 Aug 2003 20:19:31 -0000 At 11:56 AM 8.29.2003 -0700, Michelle wrote: >I would like to upgrade mysql from mysql-server-3.23.54 to >mysql-server-3.23.57 and understand that I will need to do a dump >before upgrading since the upgrade needs to overwrite the databases. >Since I have never done this before, I just want to make sure I have >the correct steps after reading over the mysql site and the man pages. > >First I will dump all of my databases: > >mysqldump -A > backup-file.sql > >Then I will shutdown the mysql server and upgrade the mysql port with >the environment variable OVERWRITE_DB defined when running make install. > >To rebuild the databases do I simply use: > >mysqldump --all-databases > backup-file.sql > >and then restart the mysql server using mysqld_safe > >Am I missing any steps? > >Thank you, >Michelle I posted this just a few hours ago..... Use portugrade and its easy. It is a simple one-line command on FBSD-4.x: # portupgrade -m '-DSKIP_INSTALL_DB' mysql-server-3.23.54 Best regards, Jack L. Stone, Administrator SageOne Net http://www.sage-one.net jackstone@sage-one.net