Documentation for upgrading MySQL 5.1.* to MySQL5.5.* missing

[JensErikWeber@…]

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.

[pixilla (Bradley Giesbrecht)]

The process of enhancing ports to make use of the mysql51, mysql55, mariadb and percona mysql ports is ongoing.

Everyone is welcome to add their list of the mysql dependent ports they would like to use with mysql55 and I will work on it.

[eborisch (Eric A. Borisch)]

Cc Me!

[mf2k (Frank Schima)]

See #57827