Mailing List Archive

MySQL - where is the db stored?
I've messed up my mysql db and reinstalled. overwrote the config file but
the db mysql is still there and i can't access it. how do i delete it and
recreate it? I've just started messing with it so i have no data to back
up. I just want to nuke it and start over.

Thanks,

~P



--
http://patrickcampbell.us


--
gentoo-user@gentoo.org mailing list
Re: MySQL - where is the db stored? [ In reply to ]
On Wed, 20 Oct 2004 21:18:22 -0400 (EDT)
"J. Patrick Campbell" <patrick@lowmips.com> wrote:

> I've messed up my mysql db and reinstalled. overwrote the config file but
> the db mysql is still there and i can't access it. how do i delete it and
> recreate it? I've just started messing with it so i have no data to back
> up. I just want to nuke it and start over.
>
> Thanks,

/var/lib/mysql

>
> ~P
>
>
>
> --
> http://patrickcampbell.us
>
>
> --
> gentoo-user@gentoo.org mailing list

--
Nick Rout <nick@rout.co.nz>


--
gentoo-user@gentoo.org mailing list
Re: MySQL - where is the db stored? [ In reply to ]
On Thu, 21 Oct 2004 14:24:58 +1300, Nick Rout <nick@rout.co.nz> wrote:
>
> On Wed, 20 Oct 2004 21:18:22 -0400 (EDT)
> "J. Patrick Campbell" <patrick@lowmips.com> wrote:
>
> > I've messed up my mysql db and reinstalled. overwrote the config file but
> > the db mysql is still there and i can't access it. how do i delete it and
> > recreate it? I've just started messing with it so i have no data to back
> > up. I just want to nuke it and start over.
> >
> > Thanks,
>
> /var/lib/mysql
>

If you really want to start over, as root

1. Nuke /var/lib/mysql
2. run 'ebuild /var/db/pkg/dev-db/mysql-????/mysql-????.ebuild config'

HTH,
--
/\/\
(CR) Collins Richey
\/\/ "I hear you're single again." "Spouse 2.0 had fewer bugs than
Spouse 1.0, but the maintenance ... was too much for my OS."
- Glitch (tm)

--
gentoo-user@gentoo.org mailing list