MYSQL Fresh Reinstall, How?

[Jack L. Stone]

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 at sage-one.net