[gentoo-user] mysql DB file

[gentoo-user] mysql DB file

[Nick Smith]

where is the actual mysql DB file stored? what it the name as well?
found info on the net that pointed to either /usr/local/mysql/data or
/usr/local/var neither of which contain a mysql dir, the latter doesnt
even exsist on gentoo.

TIA

nick

--
Linux, because I'd rather own a free OS than steal one that's not
worth paying for.

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] mysql DB file

[Sarpy Sam]

On 2/21/06, Nick Smith <nick.smith79@gmail.com> wrote:
> where is the actual mysql DB file stored? what it the name as well?
> found info on the net that pointed to either /usr/local/mysql/data or
> /usr/local/var neither of which contain a mysql dir, the latter doesnt
> even exsist on gentoo.
>

/var/lib/mysql

Kirby

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] mysql DB file

[Daniel da Veiga]

On 2/21/06, Nick Smith <nick.smith79@gmail.com> wrote:
> where is the actual mysql DB file stored? what it the name as well?
> found info on the net that pointed to either /usr/local/mysql/data or
> /usr/local/var neither of which contain a mysql dir, the latter doesnt
> even exsist on gentoo.

The default behavior is /usr/lib/mysql... And that is distro independent.

>
> TIA
>
> nick
>
> --
> Linux, because I'd rather own a free OS than steal one that's not
> worth paying for.
>
> --
> gentoo-user@gentoo.org mailing list
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] mysql DB file

[John Jolet]

On 2/21/06 2:52 PM, "Nick Smith" <nick.smith79@gmail.com> wrote:

> where is the actual mysql DB file stored? what it the name as well?
> found info on the net that pointed to either /usr/local/mysql/data or
> /usr/local/var neither of which contain a mysql dir, the latter doesnt
> even exsist on gentoo.
It should say in /etc/my.cnf where the data dir is.
> 
> TIA
> 
> nick
> 
> --
> Linux, because I'd rather own a free OS than steal one that's not
> worth paying for.


-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] mysql DB file

[Daniel da Veiga]

On 2/21/06, Daniel da Veiga <danieldaveiga@gmail.com> wrote:
> On 2/21/06, Nick Smith <nick.smith79@gmail.com> wrote:
> > where is the actual mysql DB file stored? what it the name as well?
> > found info on the net that pointed to either /usr/local/mysql/data or
> > /usr/local/var neither of which contain a mysql dir, the latter doesnt
> > even exsist on gentoo.
>
> The default behavior is /usr/lib/mysql... And that is distro independent.

Silly me, sorry about that, it is in fact /var/lib/mysql...

>
> >
> > TIA
> >
> > nick
> >
> > --
> > Linux, because I'd rather own a free OS than steal one that's not
> > worth paying for.
> >
> > --
> > gentoo-user@gentoo.org mailing list
> >
> >
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
> ------END GEEK CODE BLOCK------
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] mysql DB file

[kashani]

Nick Smith wrote:
> where is the actual mysql DB file stored? what it the name as well?
> found info on the net that pointed to either /usr/local/mysql/data or
> /usr/local/var neither of which contain a mysql dir, the latter doesnt
> even exsist on gentoo.
> 

Gentoo default is /var/lib/mysql/ or you can try a locate <somedbname> 
assuming you have slocate installed. IIRC /var/lib/mysql is the Mysql 
default as well, but I can seem to find any reference to that or any 
other location.

kashani

-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] mysql DB file

[Martins Steinbergs]

On Tuesday 21 February 2006 22:52, Nick Smith wrote:
> where is the actual mysql DB file stored? what it the name as well?
> found info on the net that pointed to either /usr/local/mysql/data or
> /usr/local/var neither of which contain a mysql dir, the latter doesnt
> even exsist on gentoo.
>
> TIA
>
> nick
>
> --
> Linux, because I'd rather own a free OS than steal one that's not
> worth paying for.

cat /etc/mysql-500/my.cnf | grep datadir
datadir                                         = /var/lib/mysql-500


m
-- 
Linux 2.6.15-ck3-r1 AMD Athlon(tm) 64 Processor 3200+
 23:07:22 up 1 day, 17 min,  6 users,  load average: 2.09, 1.92, 1.77
-- 
gentoo-user@gentoo.org mailing list