Updating MySQL

[Ryan Schmidt]

On Feb 27, 2009, at 06:19, Marion Dumas wrote:

> Hello!
> The mysql4 server is active,

The mysql4 port is active, I see that, but is the mysql4 server also  
running? For example, can you connect to it using the mysql command,  
or can you see it in Activity Monitor or by running the following in  
the Terminal?

ps auxww | grep mysql | grep -v grep


> so I tried to stop this server in order to install mysql5 by typing  
> in mysqladmin shutdown, but this returns  the following error message
> mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/opt/ 
> local/var/run/mysqld/mysqld.sock' (2)'
> Check that mysqld is running and that the socket: '/opt/local/var/ 
> run/mysqld/mysqld.sock' exists!

Does /opt/local/var/run/mysqld/mysqld.sock exist? If not, is your  
socket usually somewhere else? Have you moved it in your my.cnf?


> How else can I shutdown the server?
> Thank you
>
> On Feb 26, 2009, at 12:52 PM, Ryan Schmidt wrote:
>
>> On Feb 25, 2009, at 12:47, Marion Dumas wrote:
>>
>>> I am new to macports,
>>
>> Welcome!
>>
>>> so sorry for my perhaps naive question. I need
>>> to build a database in mySQL so I'm checking I have the newest
>>> version. Mysql is pre-installed on mac os x (new versions),
>>
>> It is? I didn't think Apple provided MySQL on Mac OS X at all,  
>> only on Mac OS X Server. In any case, MacPorts does not use any  
>> MySQL provided by Apple.
>>
>>> but it was
>>> also re-installed by macports automatically when I installed the  
>>> port
>>> dia a few weeks ago.
>>
>> Hmm, I can't find a mysql in any of dia's dependencies.
>>
>>> So I ran selfupdate to get any mysql port update.
>>> Now, when I search for mysql5, I find it under
>>> /opt/local/var/macports/build/ 
>>> _opt_local_var_macports_sources_rsync.macports.org_release_ports_dat 
>>> abases_mysql5/work/destroot/opt/local/bin/mysql5.
>>
>> That's the destroot directory where mysql5 gets staged before it's  
>> installed. The directory should get cleaned up after installation  
>> (unless you have turned autoclean off in macports.conf) so the  
>> fact that the directory is still around suggests mysql5  
>> installation did not complete.
>>
>> What does "port installed | grep mysql" say?
>>
>>
>>> But when I launch mySQL from the terminal, it starts off mysql4  
>>> (which
>>> I can find under both /opt/local/etc/mysql4 AND
>>> /opt/local/var/macports/sources/rsync.macports.org/release/ports/ 
>>> databases/mysql4/).
>>
>> /opt/local/etc/mysql4 is probably where MySQL 4 configuration  
>> files are kept. The second location in the ports directory is the  
>> mysql4 portfile. You will find all of our 5576 portfiles in there.
>>
>>
>>> So my question is the following:
>>> 1) Is it a problem that I have mysql installed in different  
>>> places due
>>> to the fact that it was pre-installed and then installed again
>>> elsewhere by macports when installing another application?
>>
>> I'm not sure yet what mysqls you have installed. Show us what the  
>> "port installed" command above outputs.
>>
>>
>>> 2) How do I actually get the newer version to run instead of the  
>>> older one?
>>
>> To get the MacPorts mysql5 server to run, first stop any other  
>> mysql server you're running, then install mysql5 with the server  
>> variant:
>>
>> sudo port install mysql5 +server
>>
>> Then you configure it and start the launch daemon using the  
>> instructions the port prints.
>>
>> You may also want to consult the MAMP wiki page. It contains more  
>> detailed instructions:
>>
>> http://trac.macports.org/wiki/howto/MAMP#Step3:InstallMySQL
>>
>>
>