Date: Fri, 29 Aug 2003 08:14:33 -0500 From: "Jack L. Stone" <jackstone@sage-one.net> To: "Ben Dover" <nuckingfutsto@hotmail.com>, freebsd-questions@freebsd.org Subject: Re: MYSQL Fresh Reinstall, How? Message-ID: <3.0.5.32.20030829081433.0137eaf8@sage-one.net> In-Reply-To: <Law11-F32QZaWcOrlVa0000c96b@hotmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3.0.5.32.20030829081433.0137eaf8>