List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 15 2001 11:12pm
Subject:Re: MySQL Variables
View as plain text  
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. | tritan@stripped
># 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:mcollins@stripped
>||| Seattle, WA, USA      |||      http://www.lassodev.com


-- 
Paul DuBois, paul@stripped
Thread
MySQL VariablesMike<mickalo>Blezien14 Jul
  • Re: MySQL VariablesPaul DuBois14 Jul
    • Re: MySQL VariablesMichael Collins14 Jul
      • Re: MySQL VariablesPaul DuBois14 Jul
        • Re: MySQL VariablesMichael Collins14 Jul
          • Re: MySQL VariablesPaul DuBois14 Jul
            • Re: MySQL VariablesMichael Collins15 Jul
              • Re: MySQL VariablesMichael Collins15 Jul
                • Re: MySQL VariablesPaul DuBois16 Jul
    • Re: MySQL VariablesMike<mickalo>Blezien14 Jul
      • Re: MySQL VariablesPaul DuBois14 Jul
      • Re: MySQL VariablesMichael Collins14 Jul
Re: MySQL VariablesMichael Collins16 Jul