Finding out the absolute mysql path to execute a shell script

Question

How to determine mysql location on server (windows or linux)?

I would like to run

 mysql -u USER -p PASS DATABASE < filename.sql 

but i need an absolute mysql path, how do i know?

Answer 1

Unix / Linux: which mysql returns path to executable mysql

I do not know about windows.

Answer 2

which mysql will not return anything if it is not already in the path.

on linux you can use

updatedb locate mysql

or `find / -name" mysql "-print

Windows just uses its crappy search tool

Answer 3

I wanted to do something similar and found this SQL statement: SHOW VARIABLES LIKE 'basedir'

 $result = mysql_query("SHOW VARIABLES LIKE 'basedir'"); $row = mysql_fetch_assoc($result); echo $row['Variable_name']." = ".$row['Value']; 

It will tell you the base directory of the MySQL server. Add "/ bin /" and then your command.

Enjoy it!

Answer 4

 echo $_SERVER["MYSQL_HOME"];