我可以自动从PHP找到MySQL可执行文件吗？

Question

I need to run Shell_exec to import a dump into my MYSQL database. Today I do this:

$shellExec = 'C:\wamp\bin\mysql\mysql5.1.36\bin\mysql -h localhost -u root mertero_decicare < D:\localhost\sql\decisions.sql';

$out = shell_exec($shellExec .' 2> output');

Which works. But is there a way to 'find' the location of the mysql executable from PHP? SO I don't need to hardcaord my mysql location?

Ron

Answer 1

On Windows to could add C:\wamp\bin\mysql\mysql5.1.36\bin\ to you Environment Variables path. See: http://en.wikipedia.org/wiki/Environment_variable

That way you could just call shell_exec('mysql ...');

Alernatively you could not use mysqldump, you could use SELECT INTO OUTFILE in MySQL although you'd need to do it for each table. Not as elegant as mysqldump.