Gentoo Archives: gentoo-server

From: "Daniel Schledermann (TypoConsult A/S)" <daniel@×××××××××××.dk>
To: gentoo-server@l.g.o
Subject: Re: [gentoo-server] mysql upgrade from 4.0.x to 4.1.x or 5.x.x
Date: Tue, 06 Jun 2006 20:18:41
Message-Id: 4485E229.7020702@typoconsult.dk
In Reply to: [gentoo-server] mysql upgrade from 4.0.x to 4.1.x or 5.x.x by Georges Toth
1 Georges Toth wrote:
2
3 >Hi all,
4 >
5 >Is there anything which could break by upgrading (and following the standard
6 >gentoo upgrade guide) from 4.0.x to either 4.1.x or 5.x.x ?
7 >(php scripts for example ?)
8 >
9 >
10 In general lots of things could go wrong. PHP script is a good example.
11 If you use older versions of complex PHP-apps, upgrading mysql might not
12 be a very good idear. One of the things that might go wrong is the
13 charset-stuff. In MySQL 3-4.0 the char set on the server as one. In the
14 newer versions it is on table basis. This for example breaks older
15 versions of TYPO3.
16
17 And remember to follow the upgrade guide. Not doing so will b0rk your
18 server.
19
20 If you can afford it, the safest approach IMO is to have an extra server
21 with the old MySQL-version on, that you keep alive, and then move your
22 databases one at a time.
23
24 /D
25 --
26 gentoo-server@g.o mailing list

Replies

Subject Author
Re: [gentoo-server] mysql upgrade from 4.0.x to 4.1.x or 5.x.x Georges Toth <georges@××××.lu>