MySQL Question

[Mr Pheer]

How do i find out where my databases are stored on my server? Using FreeBSD

[frankfortuna]

/usr/bin/mysql --user=$sqluser --password=$sqlpass -e "show
databases;"

Remove $variables and insert your real user / pass.

[Juicy D. Links]

Hi MR pHeer

[Mr Pheer]

Originally posted by frankfortuna
/usr/bin/mysql --user=$sqluser --password=$sqlpass -e "show
databases;"

Remove $variables and insert your real user / pass.

Thanks Mr ForTuna

Hi Juicy

[fuzebox]

In the mysql client type "show variables", and scroll up until you find "datadir"

That's the path to where your databases are physically stored...

Unless you were asking about something different?

[Simon-interaid]

you can do

ps -axf | grep mysqld


in the results it'll show you where its looking for the data.

Easiest way id say

[Steve]

useful shit to know

[wimpy]

I want "MySQL for Dummies"

[Naughty]

Originally posted by wimpy
I want "MySQL for Dummies"

MySQL for Dummies

[Illicit]

Originally posted by wimpy
I want "MySQL for Dummies"

where in RI are you ?