LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 04-18-2003, 06:53 PM   #1
meluser
Member
 
Registered: Mar 2003
Posts: 65

Rep: Reputation: 15
location of MySQL Directory in Red Hat


Hi,

where is the location of MySQL Directory in Red Hat?

i have done this:

[me@cctv me]$ whereis mysql
mysql: /usr/bin/mysql /usr/lib/mysql /usr/share/mysql /usr/share/man/man1/mysql.
1.gz
[me@cctv me]$


i think it is /usr/bin/mysql.

and is there a way i can access the MySQL data outside MySQL, e.g. can i copy the database file and open it in Acess lets say???


thanks,
 
Old 04-19-2003, 01:23 AM   #2
lnxconvrt
Member
 
Registered: Mar 2002
Location: Houston
Distribution: FC3, Manrake 10.x, various others at times
Posts: 113

Rep: Reputation: 18
Post It depends...

on what you mean by "MySQL directory", and possibly on the RH version.

To see the location of the file that executes when you invoke MySQL do a "which MySQL" from a shell prompt. That gets me a response of /usr/bin/mysql on both my RH 7.3 server and on my RH 8.0 workstation.

Try "more /etc/my.cnf" to see where key files are for MySQL. Databases are under /var/lib/mysql for both my RH boxes, as that is defined in the my.cnf file as the "datadir".

I believe that you can export the data, but don't recall specifics. You might consider using ODBC to access MySQL databases with Access. I believe that there is a "MyODBC" that allows this. Probably you can find info on it at www.mysql.com.
 
Old 04-19-2003, 04:19 PM   #3
nakkaya
LQ Guru
 
Registered: Jan 2003
Location: Turkey&USA
Distribution: Emacs and linux is its device driver(Slackware,redhat)
Posts: 1,398

Rep: Reputation: 45
diffrent file located under diffrent directory its not like windows all file are uder same directory to find it
locate mysql

if give error first do updatedb
 
Old 04-20-2003, 12:59 PM   #4
aero
LQ Newbie
 
Registered: Apr 2003
Location: Portugal
Distribution: VMware 4.0 RedHat 9.0
Posts: 29

Rep: Reputation: 15
You must want to see where is Mysqld, that's the server for mysql, do a locate mysqld and start mysqld, first read the manual from mysql to know the parameters well
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Red Hat to Open-Source Netscape Directory t3gah Linux - General 1 05-30-2005 11:36 AM
Active Directory and Red Hat bytebrowser Linux - Software 1 09-14-2004 10:35 PM
Red Hat 7.1 - Where is the directory for Sound Drivers? badger311 Linux - Hardware 1 07-17-2004 09:42 AM
How-to get access to MySQL on Red Hat 9 lothario Red Hat 3 05-19-2004 09:43 PM
MySQL / Red Hat 9 ? novice22 Linux - Software 3 02-09-2004 06:12 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 03:12 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration