summaryrefslogtreecommitdiff
blob: 39f7d1dab5a1806008ef2923c5a06655b350383c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
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 ""