From owner-freebsd-questions@FreeBSD.ORG Fri Aug 29 06:14:36 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 E46BD16A4BF for ; Fri, 29 Aug 2003 06:14:36 -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 06B8843FE9 for ; Fri, 29 Aug 2003 06:14:36 -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 h7TDERlP021858; Fri, 29 Aug 2003 08:14:27 -0500 (CDT) (envelope-from jackstone@sage-one.net) Message-Id: <3.0.5.32.20030829081433.0137eaf8@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 08:14:33 -0500 To: "Ben Dover" , freebsd-questions@freebsd.org From: "Jack L. Stone" In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Spam-Status: No, hits=-1.2 required=4.5 tests=AWL,EMAIL_ATTRIBUTION,IN_REP_TO 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: MYSQL Fresh Reinstall, How? 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 13:14:37 -0000 At 02:52 AM 8.29.2003 -0400, Ben Dover wrote: > I managed to mess up my MYSQL4.1 on my 5.1 box and I can't seem to get it >straightened out. I think the best way to resolve this would be to do a >fresh install of MYSQL server. I did a pkg_delete of MYSQL-server and >client and installed again from ports but I'm getting the same error >messages. Is there a way to just start out fresh like I never had MYSQL >installed in the first place? The error I'm getting is: >030829 2:36:36 Fatal error: Can't open privilege tables: Can't find file: >'./mysql/host.frm' (errno: 13) >030829 02:36:36 mysqld ended > >This started out from something I did while trying to get Plesk6 to work on >5.1 (which I did) but without MYSQL working I uninstalled Plesk6. I think >what I did was delete the database mysql and I guess it is essential. Any >assistance would be appreciated but I'm leaning toward a fresh install if >possible. > If you can use portugrade, it was always a simple one-line command on FBSD-4.x: # portupgrade -m '-DSKIP_INSTALL_DB' mysql-server-3.xx.xx The above preserves the databases just fine. Haven't tried it on 5.1 though.... Best regards, Jack L. Stone, Administrator SageOne Net http://www.sage-one.net jackstone@sage-one.net