[MacPorts] #36003: Documentation for upgrading MySQL 5.1.* to MySQL5.5.* missing

[MacPorts]

#36003: Documentation for upgrading MySQL 5.1.* to MySQL5.5.* missing
-------------------------------------+--------------------------------------
 Reporter:  JensErikWeber@…          |       Owner:  macports-tickets@…                   
     Type:  request                  |      Status:  new                                  
 Priority:  Normal                   |   Milestone:                                       
Component:  ports                    |     Version:  2.1.2                                
 Keywords:  documentation            |        Port:  mysql55-server                       
-------------------------------------+--------------------------------------
 There are no instructions (at least I couldn’t find any) on MacPorts how
 to upgrade MySQL 5.1 to 5.5, i. e. currently mysql5 or mysql51 @5.1.65 ->
 mysql55 @5.5.27, the same for mysql5*-server.

 Installing mysql55(-server) is not the problem, I also ran “sudo port
 select mysql mysql55”.

 But when I start the server with “sudo mysqld_safe --user=mysql &”, the
 server ends some seconds later:


 {{{
 $ 120905 22:25:11 mysqld_safe Logging to
 '/opt/local/var/db/mysql55/mbp.fritz.box.err'.
 120905 22:25:12 mysqld_safe Starting mysqld daemon with databases from
 /opt/local/var/db/mysql55
 120905 22:25:13 mysqld_safe mysqld from pid file
 /opt/local/var/db/mysql55/mbp.fritz.box.pid ended
 }}}


 Probably there is no bug in the package, but I haven’t found any
 documentation about how to upgrade MySQL from 5.1 to 5.5 and make it work
 together with Apache and PHP. When I searched for a documentation I found
 a page [http://scotty-t.com/2012/04/02/intstalling-mysql-5-5-on-os-x
 -mountain-lion/] that recommends not using MacPorts’ MySQL, but the
 install package from Oracle’s/MySQL’s site. Maybe I will do that, on the
 other hand updating “sudo port -vu upgrade outdated” is quite handy, apart
 from the mentioned trouble.

 So please be so kind and write how to get MySQL 5.5 working together with
 Apache and PHP and how to move the tables to the new version.

-- 
Ticket URL: <https://trac.macports.org/ticket/36003>
MacPorts <http://www.macports.org/>
Ports system for Mac OS