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.60)
(envelope-from )
id 1GMWaB-0003QE-LO
for garchives@archives.gentoo.org; Sun, 10 Sep 2006 21:11:16 +0000
Received: from robin.gentoo.org (localhost [127.0.0.1])
by robin.gentoo.org (8.13.8/8.13.6) with SMTP id k8ALBPuC003434;
Sun, 10 Sep 2006 21:11:26 GMT
Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183])
by robin.gentoo.org (8.13.8/8.13.6) with ESMTP id k8ALBOJw028197
for ; Sun, 10 Sep 2006 21:11:25 GMT
Received: from lark (lark.gentoo.osuosl.org [140.211.166.177])
(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
(No client certificate requested)
by smtp.gentoo.org (Postfix) with SMTP id E81886466A
for ; Sun, 10 Sep 2006 21:11:23 +0000 (UTC)
Received: by lark (sSMTP sendmail emulation); Sun, 10 Sep 2006 21:11:22 +0000
From: "Josh Saddler"
Date: Sun, 10 Sep 2006 21:11:22 +0000
To: gentoo-doc-cvs@lists.gentoo.org
Subject: [gentoo-doc-cvs] cvs commit: mysql-upgrading.xml
Message-Id: <20060910211123.E81886466A@smtp.gentoo.org>
Precedence: bulk
List-Post:
List-Help:
List-Unsubscribe:
List-Subscribe:
List-Id: Gentoo Linux mail
X-BeenThere: gentoo-doc-cvs@gentoo.org
Reply-to: docs-team@lists.gentoo.org
X-Archives-Salt: fe7b1eb2-8e29-4cd0-8874-c2c8f4b6f03e
X-Archives-Hash: 5009642273e2978de08762a1b59ee5c7
nightmorph 06/09/10 21:11:22
Modified: mysql-upgrading.xml
Log:
numerous fixes for bug 147078
Revision Changes Path
1.14 xml/htdocs/doc/en/mysql-upgrading.xml
file : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml?rev=1.14&view=markup
plain: http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml?rev=1.14&content-type=text/plain
diff : http://sources.gentoo.org/viewcvs.py/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml?r1=1.13&r2=1.14
Index: mysql-upgrading.xml
===================================================================
RCS file: /var/cvsroot/gentoo/xml/htdocs/doc/en/mysql-upgrading.xml,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- mysql-upgrading.xml 10 Sep 2006 01:57:15 -0000 1.13
+++ mysql-upgrading.xml 10 Sep 2006 21:11:22 -0000 1.14
@@ -1,6 +1,6 @@
-
+
Upgrade guide to MySQL 4.* or 5.0.*
@@ -14,16 +14,16 @@
The MySQL herd is proud to announce that MySQL 5.0 will soon be found in
-Gentoo's stable tree. This document describes how to upgrade from MySQL 4.* to
-5.0.*
+Gentoo's stable tree. This document describes how to upgrade to MySQL 4.* and
+to 5.0.*.
-1.10
-2006-09-09
+1.11
+2006-09-10
Straight upgrade, suggested for 4.1 => 5.0 migration
@@ -31,11 +31,11 @@
-The myisam storage engine in 4.1 version was already mature enough to allow a
+The myisam storage engine in version 4.1 was already mature enough to allow a
direct upgrade to the next major version of MySQL.
-
+
# quickpkg dev-db/mysql
# alias MYSQL="mysql --user=root --password='your_password'"
# DATADIR=$(MYSQL --batch --raw --silent --skip-column-names \
@@ -149,11 +149,11 @@
Now two different backups should exist: the SQL one, which is portable between
various versions of MySQL, and the other one that will allow you to quickly
-restore your database. This is covered later in this doc in more detail.
+restore your database. This is covered later in this document in more detail.
-After you got rid of your old MySQL installation, you can now install the new
+After you get rid of your old MySQL installation, you can now install the new
version. Note that revdep-rebuild is necessary for rebuilding packages
linking against MySQL.
@@ -187,16 +187,16 @@
-The default character set in gentoo mysql 4.1 and above is utf8. If the
-data contain non-ASCII characters, you may want to preserve the default
+The default character set in MySQL 4.1 and above is utf8. If the data
+contain non-ASCII characters, you may want to preserve the default
character set of the database replacing all occurrences of utf8 with
-latin1 into the /etc/mysql/my.cnf config file. More
+latin1 in the /etc/mysql/my.cnf config file. More
information can be found Charset
-conversion charapter.
+conversion chapter.
-The administrative mysql database that containins user names, passwords
+The administrative mysql database that contains user names, passwords
amongst other things is and must be in encoded in utf8.
@@ -268,7 +268,7 @@
-This charapter is not intended to be an exhaustive guide on how to do such
+This chapter is not intended to be an exhaustive guide on how to do such
conversions, rather a short list of hints on which the reader can elaborate.
@@ -285,8 +285,8 @@
-Every utf-8 char is considered 3 bytes long within an index. Indexes in MySQL
-can be up to 1000 bytes long (767 bytes for InnoDB tables). Note that the
+Every utf-8 character is considered 3 bytes long within an index. Indexes in
+MySQL can be up to 1000 bytes long (767 bytes for InnoDB tables). Note that the
limits are measured in bytes, whereas the length of a column is interpreted as
number of characters.
@@ -353,7 +353,7 @@
Working in a utf-8 environment, with utf-8 editors and tools help too:
-
+
LC_ALL=en_US.UTF-8
LANG=en_US.UTF-8
export LC_ALL LANG
@@ -409,7 +409,7 @@
-To use utf-8 with apache, you need to adjust the folowing variables in
+To use utf-8 with apache, you need to adjust the following variables in
httpd.conf: AddDefaultCharset, CharsetDefault, CharsetSourceEnc.
If your source html files aren't encoded in utf-8, they must be
converted with iconv or recode.
--
gentoo-doc-cvs@gentoo.org mailing list