From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.43) id 1EEUKk-00032t-6r for garchives@archives.gentoo.org; Sun, 11 Sep 2005 16:05:34 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.4/8.13.4) with SMTP id j8BG0H38010397; Sun, 11 Sep 2005 16:00:17 GMT Received: from smtp.gentoo.org (smtp.gentoo.org [134.68.220.30]) by robin.gentoo.org (8.13.4/8.13.4) with ESMTP id j8BFw5aI002172 for ; Sun, 11 Sep 2005 15:58:05 GMT Received: from zh034160.ppp.dion.ne.jp ([222.3.34.160] helo=opteron246.suzuki-stubbs.home) by smtp.gentoo.org with esmtpa (Exim 4.43) id 1EEUHa-0003FM-IS for gentoo-dev@lists.gentoo.org; Sun, 11 Sep 2005 16:02:18 +0000 Received: by opteron246.suzuki-stubbs.home (Postfix, from userid 1000) id 2200B101F3E; Mon, 12 Sep 2005 01:02:27 +0900 (JST) From: Jason Stubbs To: gentoo-dev@lists.gentoo.org Subject: Re: [gentoo-dev] MySQL 4.0 => 4.1 upgrade Date: Mon, 12 Sep 2005 01:02:25 +0900 User-Agent: KMail/1.8.90 References: <43201B96.7050209@gentoo.org> <20050911000132.11bd8564@localhost> <432447CC.9070703@gentoo.org> In-Reply-To: <432447CC.9070703@gentoo.org> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@gentoo.org Reply-to: gentoo-dev@lists.gentoo.org MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart1857307.kg2LoPZK3Z"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200509120102.26848.jstubbs@gentoo.org> X-Archives-Salt: dde38a58-086f-43de-8331-f883c704befe X-Archives-Hash: 18fd13ac6bc3aea2f008024f7423ce0c --nextPart1857307.kg2LoPZK3Z Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Monday 12 September 2005 00:05, Francesco R wrote: > http://dev.gentoo.org/~vivo/doc/mysql-update.html With step 2, you should probably mention the issues that can arise with=20 non-ASCII data in char fields. The character set really needs to specified= =20 in the dump. After the upgrade to 4.1, the default charset of the server=20 should be set to something compatible and then the charset of the data=20 should be specified to mysql when re-importing the backup. Just another one of the many gotchas... =2D-=20 Jason Stubbs --nextPart1857307.kg2LoPZK3Z Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iD8DBQBDJFUSxvWNPsk/ZP4RAvszAKC/SvWXlFmo0ZWGLjYOru+Ki8wNfACgjRBv o6SR2nMIvh6JNiJT3gzIvUQ= =PnQL -----END PGP SIGNATURE----- --nextPart1857307.kg2LoPZK3Z-- -- gentoo-dev@gentoo.org mailing list