Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 03-05-2004, 09:36 PM   #1
Mr Pheer
Retired
 
Mr Pheer's Avatar
 
Industry Role:
Join Date: Dec 2002
Posts: 21,370
MySQL Question

How do i find out where my databases are stored on my server? Using FreeBSD
__________________
2 lifeguards for Jessica
Mr Pheer is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-05-2004, 09:42 PM   #2
frankfortuna
Confirmed User
 
Join Date: Aug 2002
Posts: 1,504
/usr/bin/mysql --user=$sqluser --password=$sqlpass -e "show
databases;"

Remove $variables and insert your real user / pass.
frankfortuna is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-05-2004, 09:44 PM   #3
Juicy D. Links
So Fucking Banned
 
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
Hi MR pHeer
Juicy D. Links is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-05-2004, 09:46 PM   #4
Mr Pheer
Retired
 
Mr Pheer's Avatar
 
Industry Role:
Join Date: Dec 2002
Posts: 21,370
Quote:
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
__________________
2 lifeguards for Jessica
Mr Pheer is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-05-2004, 09:55 PM   #5
fuzebox
making it rain
 
fuzebox's Avatar
 
Industry Role:
Join Date: Oct 2003
Location: seattle
Posts: 22,128
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?
fuzebox is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-05-2004, 09:58 PM   #6
Simon-interaid
Confirmed User
 
Join Date: Sep 2002
Location: Vancouver
Posts: 814
you can do

ps -axf | grep mysqld


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

Easiest way id say
Simon-interaid is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-05-2004, 10:34 PM   #7
Steve
Confirmed User
 
Join Date: Feb 2001
Location: USA
Posts: 6,894
useful shit to know
Steve is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-07-2004, 04:45 PM   #8
wimpy
Confirmed User
 
Industry Role:
Join Date: Jan 2003
Location: Cali
Posts: 607
I want "MySQL for Dummies"
__________________
Fyodor Dostoyevsky wrote: "Every man has reminiscences which he would not tell to everyone but only his friends. He has other matters in his mind which he would not reveal even to his friends, but only to himself, and that in secret. But there are other things which a man is afraid to tell even to himself, and every decent man has a number of such things stored away in his mind."

icq 8243657
wimpy is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-07-2004, 04:46 PM   #9
Naughty
Confirmed User
 
Industry Role:
Join Date: Jul 2001
Location: Utopia
Posts: 6,482
Quote:
Originally posted by wimpy
I want "MySQL for Dummies"
MySQL for Dummies
__________________
seks.ai for sale - ping me
Naughty is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 03-07-2004, 04:46 PM   #10
Illicit
wtf ?
 
Join Date: Dec 2003
Location: GFY
Posts: 11,895
Quote:
Originally posted by wimpy
I want "MySQL for Dummies"

where in RI are you ?
__________________
Insert Sig Here
Illicit is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >

Bookmarks



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.