Import gentoo-doc-doc repository

1 files changed, 601 insertions, 0 deletions

diff --git a/doc/gettext/ru/mysql-upgrading.xml.po b/doc/gettext/ru/mysql-upgrading.xml.po
new file mode 100644
index 0000000..39f7d1d
--- /dev/null
+++ b/doc/gettext/ru/mysql-upgrading.xml.po
@@ -0,0 +1,601 @@
+msgid ""
+msgstr ""
+"Project-Id-Version: PACKAGE VERSION\n"
+"POT-Creation-Date: 2010-10-21 23:56+0600\n"
+"PO-Revision-Date: 2010-10-21 23:46+0600\n"
+"Last-Translator: Automatically generated\n"
+"Language-Team: none\n"
+"Language: ru\n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: 8bit\n"
+"Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n%10>=2 && n"
+"%10<=4 && (n%100<10 || n%100>=20) ? 1 : 2);\n"
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(guide:link):5
+msgid "/doc/en/mysql-upgrading.xml"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(title):6
+msgid "Upgrade guide to MySQL 4.* or 5.0.*"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(author:title):8
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(author:title):11
+msgid "Author"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(mail:link):9
+msgid "citizen428@gentoo.org"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(mail):9
+msgid "Michael Kohl"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(mail:link):12
+msgid "vivo@gentoo.org"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(mail):12
+msgid "Francesco Riosa"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(abstract):15
+msgid ""
+"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 to MySQL 4.* "
+"and to 5.0.*."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(version):25
+msgid "1.17"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(date):26
+msgid "2007-06-04"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(title):29
+msgid "Straight upgrade, suggested for 4.1 =&gt; 5.0 migration"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):33
+msgid ""
+"The myisam storage engine in version 4.1 was already mature enough to allow "
+"a direct upgrade to the next major version of MySQL."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(note):38
+msgid ""
+"This is not true for MERGE tables. You will likely run into trouble if you "
+"attempt a direct upgrade for this (rarely used) type of table. You should "
+"dump and recreate those tables and restore their contents in the process of "
+"upgrading. If unsure, you should begin with <uri link="
+"\"#doc_chap2\">Upgrading from old versions of MySQL</uri>."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):46
+msgid ""
+"For this step two shells are required because locks belong to the mysql "
+"session."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):51
+msgid "Straight upgrade from 4.1 to 5.0.*"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):51
+#, no-wrap
+msgid ""
+"\n"
+"# <i>quickpkg dev-db/mysql</i>\n"
+"# <i>alias MYSQL=\"mysql --user=root --password=</i><comment>'your_password'</comment><i>\"</i>\n"
+"# <i>DATADIR=$(MYSQL --batch --raw --silent --skip-column-names \\</i>\n"
+"     <i>--execute='SHOW variables LIKE \"datadir\";' \\</i>\n"
+"     <i>| sed -e 's|datadir[ \\t]||')</i>\n"
+"\n"
+"<comment>(This next step should be done in the second shell)</comment>\n"
+"# <i>mysql --user=root --password=</i><comment>'your_password'</comment>\n"
+"mysql&gt; <i>FLUSH TABLES WITH READ LOCK;</i>\n"
+"\n"
+"<comment>(Return to the first shell to run this command)</comment>\n"
+"# <i>tar -cjpvf ~/mysql.$(date +%F\"T\"%H-%M).tar.bz2 \\</i>\n"
+"     <i>/etc/conf.d/mysql /etc/mysql/my.cnf \"${DATADIR}\"</i>\n"
+"\n"
+"<comment>(The following commands should be done in the second shell)</comment>\n"
+"mysql&gt; <i>UNLOCK TABLES;</i>\n"
+"mysql&gt; <i>quit</i>\n"
+"\n"
+"<comment>(Return to the first shell for the rest of the upgrade)</comment>\n"
+"# <i>tar -tjvf ~/mysql.*.tar.bz2</i>\n"
+"# <i>emerge -av \"&gt;dev-db/mysql-5.0\"</i>\n"
+"# <i>dispatch-conf</i>\n"
+"# <i>revdep-rebuild</i>\n"
+"# <i>/etc/init.d/mysql restart</i>\n"
+"# <i>mysql_upgrade_shell --user=root --password=</i><comment>'your_password'</comment><i> \\</i>\n"
+"     <i>--protocol=tcp --datadir=\"${DATADIR}\"</i>\n"
+"# <i>/etc/init.d/mysql restart</i>\n"
+"# <i>unset DATADIR</i>\n"
+"# <i>unalias MYSQL</i>\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(title):88
+msgid "Upgrading from old versions of MySQL"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):92
+msgid ""
+"Users upgrading from an old version (&lt;4.0.24) of MySQL will first have to "
+"install MySQL 4.0.25. If you are already running a more recent version, you "
+"can skip this section and continue with the <uri link=\"#backup\">next one</"
+"uri>."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):98
+msgid "Simple upgrade"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):98
+#, no-wrap
+msgid ""
+"\n"
+"# <i>emerge -av --buildpkg \"&lt;mysql-4.1\"</i>\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(title):107
+msgid "Creating a backup of your current data"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(impo):111
+msgid ""
+"Values inside primary keys are handled differently in various MySQL "
+"versions, see <uri link=\"http://bugs.gentoo.org/108502\">bug #108502</uri> "
+"for more details, it is higly recommended to scan your tables for values of "
+"\"0\" (zero) or less and update them to a value greater than or equal to "
+"\"1\"."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):118
+msgid ""
+"One of the most important tasks that every database administrator has to "
+"perform is backing up data. Here we go:"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):123
+msgid "Dump of all databases"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):123
+#, no-wrap
+msgid ""
+"\n"
+"# <i>mysqldump \\</i>\n"
+"  <i>-uroot \\</i>\n"
+"  <i>--password=</i><comment>'your_password'</comment><i> \\</i>\n"
+"  <i>-hlocalhost \\</i>\n"
+"  <i>--all-databases \\</i>\n"
+"  <i>--opt \\</i>\n"
+"  <i>--allow-keywords \\</i>\n"
+"  <i>--flush-logs \\</i>\n"
+"  <i>--hex-blob \\</i>\n"
+"  <i>--master-data \\</i>\n"
+"  <i>--max_allowed_packet=16M \\</i>\n"
+"  <i>--quote-names \\</i>\n"
+"  <i>--result-file=BACKUP_MYSQL_4.0.SQL</i>\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):139
+msgid ""
+"Now a file named <path>BACKUP_MYSQL_4.0.SQL</path> should exist, which can "
+"be used later to recreate your data. The data is described in the MySQL "
+"dialect of SQL, the Structured Query Language."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):145
+msgid ""
+"Now would also be a good time to see if the backup you have created is "
+"working."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(title):154
+msgid "Upgrading from recent versions of MySQL"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):158
+msgid ""
+"If you have skipped step #1, you now have to create a backup package (of the "
+"database server, not the data) of the currently installed version:"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):163
+msgid "Binary package backup"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):163
+#, no-wrap
+msgid ""
+"\n"
+"# <i>quickpkg dev-db/mysql</i>\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):167
+msgid "Now it's time to clean out the current version and all of its data:"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):171
+msgid "Uninstall MySQL"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):171
+#, no-wrap
+msgid ""
+"\n"
+"# <i>/etc/init.d/mysql stop</i>\n"
+"# <i>emerge -C mysql</i>\n"
+"# <i>tar cjpvf ~/mysql.$(date +%F\"T\"%H-%M).tar.bz2 /etc/mysql/my.cnf /var/lib/mysql/</i>\n"
+"# <i>ls -l ~/mysql.*</i>\n"
+"# <i>rm -rf /var/lib/mysql/ /var/log/mysql</i>\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(note):179
+msgid ""
+"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 document in "
+"more detail."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):185
+msgid ""
+"After you get rid of your old MySQL installation, you can now install the "
+"new version. Note that <c>revdep-rebuild</c> is necessary for rebuilding "
+"packages linking against MySQL."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):191
+msgid "Upgrading the binaries"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):191
+#, no-wrap
+msgid ""
+"\n"
+"# <i>emerge -av \"&gt;mysql-4.1\"</i>\n"
+"<comment>(Update your config files, you may also use dispatch-conf)</comment>\n"
+"# <i>etc-update</i>\n"
+"# <i>revdep-rebuild</i>\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):198
+msgid ""
+"Now configure the newly installed version of MySQL and restart the daemon:"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):202
+msgid "Configure MySQL 4.1 base setup"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):202
+#, no-wrap
+msgid ""
+"\n"
+"# <i>emerge --config =mysql-4.1.<comment>&lt;micro_version&gt;</comment></i>\n"
+"# <i>/etc/init.d/mysql start</i>\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):207
+msgid "Finally you can import the backup you have created during step #2."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(impo):211
+msgid ""
+"The default <path>/etc/mysql/my.cnf</path> file sets binary logging on "
+"(<c>log-bin</c>) by default. This will log every single transaction that "
+"modifies data. If run on a very large database (1GB or more), this could "
+"create extremely large files that take up disk space rather quickly. If you "
+"are low on space, disabling binary logging might be a good idea."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(impo):219
+msgid ""
+"The default character set in MySQL 4.1 and above is <c>utf8</c>. If the data "
+"contain <e>non</e>-ASCII characters, you may want to preserve the default "
+"character set of the database replacing all occurrences of <c>utf8</c> with "
+"<c>latin1</c> in the <path>/etc/mysql/my.cnf</path> config file. More "
+"information can be found <uri link=\"#On_charset_conversion\">Charset "
+"conversion</uri> chapter."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(impo):228
+msgid ""
+"The administrative <c>mysql</c> database that contains user names, passwords "
+"amongst other things is and <b>must</b> be encoded in utf8."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):233
+msgid ""
+"Older mysqldump utilities may export tables in the wrong order when foreign "
+"keys are involved. To work around this problem, surround the SQL with the "
+"following statements:"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):239
+msgid "Fixing foreign key checks"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):239
+#, no-wrap
+msgid ""
+"\n"
+"SET FOREIGN_KEY_CHECKS=0\n"
+"SET FOREIGN_KEY_CHECKS=1\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):244
+msgid "Next, import the backup."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):248
+msgid "Importing the SQL backup"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):248
+#, no-wrap
+msgid ""
+"\n"
+"# <i>cat BACKUP_MYSQL_4.0.SQL \\</i>\n"
+"     <i>| mysql \\</i>\n"
+"     <i>-uroot \\</i>\n"
+"     <i>--password=</i><comment>'your_password'</comment><i> \\</i>\n"
+"     <i>-hlocalhost \\</i>\n"
+"     <i>--max_allowed_packet=16M</i>\n"
+"\n"
+"# <i>mysql_fix_privilege_tables \\</i>\n"
+"     <i>--defaults-file=/etc/mysql/my.cnf \\</i>\n"
+"     <i>--user=root \\</i>\n"
+"     <i>--password=</i><comment>'your_password'</comment><i></i>\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):262
+msgid ""
+"If you restart your MySQL daemon now and everything goes as expected, you "
+"have a fully working version of 4.1.x."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):267
+msgid "Restart the MySQL instance"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):267
+#, no-wrap
+msgid ""
+"\n"
+"# <i>/etc/init.d/mysql restart</i>\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):271
+msgid ""
+"If you encountered any problems during the upgrade process, please report "
+"them on <uri link=\"http://bugs.gentoo.org\">Bugzilla</uri>."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(title):281
+msgid "Recover the old installation of MySQL 4.0"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):285
+msgid ""
+"If you are not happy with MySQL 4.1, it's possible to go back to MySQL 4.0."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):289
+msgid "Reverting to the previous version"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):289
+#, no-wrap
+msgid ""
+"\n"
+"# <i>/etc/init.d/mysql stop</i>\n"
+"# <i>emerge -C mysql</i>\n"
+"# <i>rm -rf /var/lib/mysql/ /var/log/mysql</i>\n"
+"# <i>emerge --usepkgonly \"&lt;mysql-4.1\"</i>\n"
+"<comment>(Replace &lt;timestamp&gt; with the one used when creating the backup.)</comment>\n"
+"# <i>tar -xjpvf mysql.&lt;timestamp&gt;.tar.bz2 -C /</i>\n"
+"# <i>/etc/init.d/mysql start</i>\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(impo):299
+msgid ""
+"If packages other than <c>dev-db/mysql</c> have been emerged following this "
+"guide, you need to run <c>revdep-rebuild</c> to ensure that every client is "
+"using the correct mysqlclient shared object."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(title):310
+msgid "On charset conversion:"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(title):312
+msgid "Introduction"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):315
+msgid ""
+"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."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):320
+msgid ""
+"Converting a database may be a complex task and difficulty increases with "
+"data variancy. Things like serialized object and blobs are one example where "
+"it's difficult to keeps pieces together."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(title):329
+msgid "Indexes"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):332
+msgid ""
+"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."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):339
+msgid ""
+"MySQL can also create indexes on parts of a column, this can be of some "
+"help. Below are some examples:"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):344
+msgid "Indexing using prefixes"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):344
+#, no-wrap
+msgid ""
+"\n"
+"$ <i>mysql -uroot -p'<comment>your_password</comment>' test</i>\n"
+"\n"
+"mysql&gt; <i>SHOW variables LIKE \"version\" \\G</i>\n"
+"*************************** 1. row ***************************\n"
+"Variable_name: version\n"
+"    Value: <comment>5.0.24-log</comment>\n"
+"1 row in set (0.00 sec)\n"
+"\n"
+"mysql&gt; <i>CREATE TABLE t1 (</i>\n"
+"  -&gt;   <i>c1 varchar(255) NOT NULL default '',</i>\n"
+"  -&gt;   <i>c2 varchar(255) NOT NULL default ''</i>\n"
+"  -&gt;   <i>) ENGINE=MyISAM DEFAULT CHARSET=utf8;</i>\n"
+"Query OK, 0 rows affected (0.01 sec)\n"
+"\n"
+"mysql&gt; <i>ALTER TABLE t1</i>\n"
+"  -&gt;   <i>ADD INDEX idx1 ( c1 , c2 );</i>\n"
+"<comment>ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes</comment>\n"
+"\n"
+"mysql&gt; <i>ALTER TABLE t1</i>\n"
+"  -&gt;   <i>ADD INDEX idx1 ( c1(165) , c2(165) );</i>\n"
+"Query OK, 0 rows affected (0.01 sec)\n"
+"Records: 0  Duplicates: 0  Warnings: 0\n"
+"\n"
+"mysql&gt; <i>CREATE TABLE t2 (</i>\n"
+"  -&gt;   <i>c1 varchar(255) NOT NULL default '',</i>\n"
+"  -&gt;   <i>c2 varchar(255) NOT NULL default ''</i>\n"
+"  -&gt;   <i>) ENGINE=MyISAM DEFAULT CHARSET=sjis;</i>\n"
+"Query OK, 0 rows affected (0.00 sec)\n"
+"\n"
+"mysql&gt; <i>ALTER TABLE t2</i>\n"
+"  -&gt;   <i>ADD INDEX idx1 ( c1(250) , c2(250) );</i>\n"
+"Query OK, 0 rows affected (0.03 sec)\n"
+"Records: 0  Duplicates: 0  Warnings: 0\n"
+"\n"
+"mysql&gt; <i>CREATE TABLE t3 (</i>\n"
+"  -&gt;   <i>c1 varchar(255) NOT NULL default '',</i>\n"
+"  -&gt;   <i>c2 varchar(255) NOT NULL default ''</i>\n"
+"  -&gt;   <i>) ENGINE=MyISAM DEFAULT CHARSET=latin1;</i>\n"
+"Query OK, 0 rows affected (0.00 sec)\n"
+"\n"
+"mysql&gt; <i>ALTER TABLE t3</i>\n"
+"  -&gt;   <i>ADD INDEX idx1 ( c1 , c2 );</i>\n"
+"Query OK, 0 rows affected (0.03 sec)\n"
+"Records: 0  Duplicates: 0  Warnings: 0\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(title):394
+msgid "Environment"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):397
+msgid ""
+"The system must be configured to support the UTF-8 locale. You will find "
+"more information in our <uri link=\"/doc/en/utf-8.xml\">Using UTF-8 with "
+"Gentoo</uri> and <uri link=\"/doc/en/guide-localization.xml\">Localization "
+"Guide</uri> documents."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):404
+msgid ""
+"In this example, we set some shell environment variables to make use of the "
+"English UTF-8 locale in <path>/etc/env.d/02locale</path>:"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):409
+msgid "/etc/env.d/02locale"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):409
+#, no-wrap
+msgid ""
+"\n"
+"LC_ALL=en_US.UTF-8\n"
+"LANG=en_US.UTF-8\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):414
+msgid ""
+"Be sure to run <c>env-update &amp;&amp; source /etc/profile</c> afterward."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(title):421
+msgid "iconv"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):424
+msgid ""
+"<c>iconv</c>, provided by <c>sys-libs/glibc</c>, is used to convert text "
+"files from one charset to another. The <c>app-text/recode</c> package can be "
+"used as well."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre:caption):430
+msgid "Using iconv"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(pre):430
+#, no-wrap
+msgid ""
+"\n"
+"<comment>(From latin1 to utf8)</comment>\n"
+"$ <i>iconv -f ISO-8859-15 -t UTF-8 file1.sql &gt; file2.sql</i>\n"
+"\n"
+"<comment>(From Japanese to utf8)</comment>\n"
+"$ <i>iconv -f ISO2022JP -t UTF-8 file1.sql &gt; file2.sql</i>\n"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):438
+msgid ""
+"<c>iconv</c> can be used to recode a sql dump even if the environment is not "
+"set to utf8."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(title):446
+msgid "SQL Mangling"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):449
+msgid ""
+"It's possible to use the <c>CONVERT()</c> and <c>CAST()</c> MySQL functions "
+"to convert data in your SQL scripts."
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(title):457
+msgid "Apache (webserver)"
+msgstr ""
+
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(p):460
+msgid ""
+"To use utf-8 with apache, you need to adjust the following variables in "
+"<path>httpd.conf</path>: AddDefaultCharset, CharsetDefault, "
+"CharsetSourceEnc. If your source html files aren't encoded in utf-8, they "
+"<b>must</b> be converted with <c>iconv</c> or <c>recode</c>."
+msgstr ""
+
+#. Place here names of translator, one per line. Format should be NAME; ROLE; E-MAIL
+#: ../../gentoo/xml/htdocs/doc/en//mysql-upgrading.xml(None):0
+msgid "translator-credits"
+msgstr ""