MySQL update

[Matthew Seaman]

On 07/06/2011 13:37, Chris Rees wrote:
> On 7 June 2011 12:56, Glenn McCalley <glenn at mail.bnetmd.net> wrote:
>> Trying to update MySQL from 4.1 to 5.5.
>> Updating mysql-client first.
>> Make works great, but make install refuses to install saying 5.5 conflicts
>> with 4.1, run
>> pkg_delete for 4.1.
>> pkg_delete for 4.1 refuses to deinstall as all the php52 packages
>> (extensions, mysql, mysqli, pdo_mysql etc.) depend on mysql 4.1.
>>
>> Question:  Do I have to deinstall everything, and then put it all back
>> together, or can I force the mysql 5.5 client and 5.5 server to install?
>>
> 
> I'm at work at the moment, so I can't test these, sorry.
> 
> Firstly, get portmaster:
> 
> # pkg_add -r portmaster
> 
> Then read the manpage:
> 
> % man portmaster
> 
> Try something like:
> 
> # portmaster -o databases/mysql55-client mysql-client
> 
> # portmaster -o databases/mysql55-server mysql-server
> 
> Then, because you haven't read the manpage you'll have to confirm
> everything. Read the manpage!
> 
> If it doesn't work (because I made a mistake with the -o syntax), read
> the manpage and then let us have the output.

After doing that, you will also need to:

   portmaster -fr databases/mysql55-client

to relink everything against the new libmysql.so -- portmaster defaults
to simply deleting any old shlibs when there is an ABI version bump, so
anything dependent on the older version will cease to function
corrrectly[*] from that point.  There is a '-w' option which can help
smooth over such transitions, but even that is no panacea.  If you
accidentally end up trying to load two different versions of libmysql.so
into the same application, it will result in crashyness.

	Cheers,

	Matthew

[*] ie. you can't /start/ it: stuff that is already running will mostly
be OK.

-- 
Dr Matthew J Seaman MA, D.Phil.                   7 Priory Courtyard
                                                  Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey     Ramsgate
JID: matthew at infracaninophile.co.uk               Kent, CT11 9PW

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 267 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20110607/22fd895f/signature.pgp