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, |
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. |
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 |
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
|
All times are GMT -5. The time now is 10:55 PM. |