At 12:39 PM -0700 7/15/01, Michael Collins wrote:
>At 11:09 AM -0700 7/15/01, Michael Collins wrote:
>>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.
>>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?
>
>Hey, maybe I answered part of my own question (thanks to the book
>"Essential System Administration from O'Reilly). There is a file on
>Mac OS X at:
>/usr/share/init/tcsh/rc that starts with the following:
>
>##
># TCSH Expanded C-Shell INITIALIZATION FILE
>#
># Wilfredo Sanchez Jr. | [EMAIL PROTECTED]
># July 09, 1992
>#
># MIT Project Athena
>#
># ORIGINAL SOURCES: /usr/athena/lib/init/cshrc (ATHENA REL 7.3P)
>##
>
>Adding the following and restarting the telnet session seems to work:
>
>alias specialmysqldump
>/Applications/Special/SpecialMySQL/bin/mysqldump
>--socket=/tmp/SpecialMySQL.sock
>alias specialmysqladmin
>/Applications/Special/SpecialMySQL/bin/mysqladmin
>--socket=/tmp/SpecialMySQL.sock
>alias specialmysql /Applications/Special/SpecialMySQL/bin/mysql
>--socket=/tmp/SpecialMySQL.sock
>
>I now get the list of databases for the Special installation when
>using specialmysql as a command.
>
>And if I use with parameters or redirect to a file it also works:
>
>specialmysqldump --opt special_site_1 > /temp.mysql
>
>And this actually added a database called special:
>
>root% specialmysqladmin create special
>
>Hurray!
Sounds like that should do it. (O'Reilly also has a book "Using csh & tcsh"
specifically on the shell that you're using that has a chapter on startup
files and another on aliases. It's written by, er ... never mind.)
>
>--
>Michael
>__
>||| Michael Collins |||
>||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
>||| Seattle, WA, USA ||| http://www.lassodev.com
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php