From owner-freebsd-questions@FreeBSD.ORG Fri Aug 29 13:59:48 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 2883016A4BF for ; Fri, 29 Aug 2003 13:59:48 -0700 (PDT) Received: from hotmail.com (law11-f88.law11.hotmail.com [64.4.17.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6932A43F3F for ; Fri, 29 Aug 2003 13:59:47 -0700 (PDT) (envelope-from nuckingfutsto@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 29 Aug 2003 13:59:47 -0700 Received: from 24.195.167.45 by lw11fd.law11.hotmail.msn.com with HTTP; Fri, 29 Aug 2003 20:59:47 GMT X-Originating-IP: [24.195.167.45] X-Originating-Email: [nuckingfutsto@hotmail.com] From: "Ben Dover" To: freebsd@soith.com, freebsd-questions@FreeBSD.ORG Date: Fri, 29 Aug 2003 16:59:47 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 29 Aug 2003 20:59:47.0289 (UTC) FILETIME=[7AD83C90:01C36E70] 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 20:59:48 -0000 I just don't understand what your talking about. When I start mysql I get the following below error so I guess its not running enough to do what your talking about? Could you please explain a little more in detail where I would type that command if it is a command. Thanks >From: "Aaron Wohl" >To: "Ben Dover" ,freebsd-questions@FreeBSD.ORG >Subject: Re: MYSQL Fresh Reinstall, How? >Date: Fri, 29 Aug 2003 02:22:08 -0600 > >Yeah I ran into that yesterday myself. The mysql_install_db doesnt leave >you with a working mysql database lately. What did to fix it was mysqld >-u mysql --skip-grant & > >(Im assuming you have your mysql firewalled off, if not do that first ;) > >At that point mysql is up enough to restore the mysql database. I ran >msyql mysql < mysql.sql where mysql.sql was made from mysqldump of a >working mysql. Then mysqladmin shutdown. Then your fine after that for >normal operations. > >I am using innodb as the default table type. I dont know if you are or >if that matters. > >On Fri, 29 Aug 2003 02:52:56 -0400, "Ben Dover" > said: > > 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. > > > > _________________________________________________________________ > > MSN 8: Get 6 months for $9.95/month. > > http://join.msn.com/?page=dept/dialup > > > > _______________________________________________ > > freebsd-questions@freebsd.org mailing list > > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > > To unsubscribe, send any mail to > > "freebsd-questions-unsubscribe@freebsd.org" _________________________________________________________________ Get MSN 8 and enjoy automatic e-mail virus protection. http://join.msn.com/?page=features/virus