At 1:47 PM -0500 7/14/01, Paul DuBois wrote:
>>>>Any solution I've tried using the LassoMySQL/var/my.cnf or
>>>>~/.my.cnf files affect both the special installation as well as
>>>>the standard MySQL installation. I find I will always get the
>>>>standard port.
>>>
>>>Settings in the [client] group of your ~/.my.cnf file would affect any
>>>client that you run. I would expect that all clients would therefore
>>>connect to the same server...
>
>The clients won't use the option file in the data directory. They will
>only use the shared option file /etc/my.cnf, and the .my.cnf in your home
>directory. You might be better off creating aliases that specify the
>options on the command line.
Thank you Paul with your help so far.
As a reminder my situation is having a Mac OS X server with two MySQL
server binaries installed (with a complete set of MySQL installed
files in the two separate locations). One uses the standard
/usr/local/bin location for MySQL the other installs into the
"Application" directory. I am trying to find an easier way to not
have to specify the socket option each time I use one of the MySQL
client programs for databases hosted by Lasso MySQL. As an example to
run these commands they need to use the form:
root% ./bin/mysql --socket=/tmp/SpecialMySQL.sock MCExample <
/Import_MCExample.mysql
root% ./bin/mysqlshow --socket=/tmp/SpecialMySQL.sock
root% ./bin/mysqladmin --socket=/tmp/SpecialMySQL.sock create newDatabaseName
In short, it becomes burdensome to type
--socket=/tmp/LassoMySQL.sock each time.
So what I am left with is that I will need to create a startup file
to map the command you type in to the actual command with the -socket
specified?
Example, create a .cshrc (Mac OS X uses the tcsh shell) and locate it
in my user directory or in /etc (I am not sure about this?). Set up
the alias lines as follows:
alias mysqldump /Applications/special/specialMySQL/bin/mysqldump
--socket=/tmp/SpecialMySQL.sock
alias mysqladmin /Applications/special/specialMySQL/bin/mysqladmin
--socket=/tmp/SpecialMySQL.sock
alias mysql /Applications/special/specialMySQL/bin/mysql
--socket=/tmp/SpecialMySQL.sock
I would actually need to use a somewhat different name for the alias
as this will interfere with use of the command for the standard
install.
The question though is will parameters be passed in? Will it then
work, for example, to import a file using:
root% mysql MCExample < /Import_MCExample.mysql
I cannot test it since so far the alias file idea does not work, I
put the .cshrc file into my home directory, logged out and started a
new telnet session.
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA ||| http://www.lassodev.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php