Opened 12 years ago

Last modified 6 years ago

#36003 assigned enhancement

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

Reported by: JensErikWeber@… Owned by:
Priority: Normal Milestone:
Component: wiki Version:
Keywords: Cc: eborisch (Eric A. Borisch)
Port: mysql55-server

Description

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.

Change History (4)

comment:1 Changed 12 years ago by ryandesign (Ryan Carsten Schmidt)

Component: portswiki
Keywords: documentation removed
Owner: changed from macports-tickets@… to pixilla@…
Type: requestenhancement

comment:2 Changed 12 years ago by 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.

comment:3 Changed 12 years ago by eborisch (Eric A. Borisch)

Cc: eborisch@… added

Cc Me!

comment:4 Changed 6 years ago by mf2k (Frank Schima)

Owner: pixilla deleted
Status: newassigned
Version: 2.1.2

See #57827

Note: See TracTickets for help on using tickets.