From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <serg-e@ukr.net>
Message-ID: <464C3AB4.7020104@ukr.net>
Date: Thu, 17 May 2007 14:21:24 +0300
From: Serge <serg-e@ukr.net>
User-Agent: Thunderbird 2.0.0.0 (X11/20070423)
MIME-Version: 1.0
To: ALT Linux Sisyphus discussion list <sisyphus@lists.altlinux.org>
Content-Type: text/plain; charset=KOI8-R; format=flowed
Content-Transfer-Encoding: quoted-printable
Subject: [sisyphus] mysql 5.0.34 charsets
X-BeenThere: sisyphus@lists.altlinux.org
X-Mailman-Version: 2.1.9rc1
Precedence: list
Reply-To: ALT Linux Sisyphus discussion list <sisyphus@lists.altlinux.org>
List-Id: ALT Linux Sisyphus discussion list <sisyphus.lists.altlinux.org>
List-Unsubscribe: <https://lists.altlinux.org/mailman/listinfo/sisyphus>,
	<mailto:sisyphus-request@lists.altlinux.org?subject=unsubscribe>
List-Archive: <http://lists.altlinux.org/pipermail/sisyphus>
List-Post: <mailto:sisyphus@lists.altlinux.org>
List-Help: <mailto:sisyphus-request@lists.altlinux.org?subject=help>
List-Subscribe: <https://lists.altlinux.org/mailman/listinfo/sisyphus>,
	<mailto:sisyphus-request@lists.altlinux.org?subject=subscribe>
X-List-Received-Date: Thu, 17 May 2007 11:21:35 -0000
Archived-At: <http://lore.altlinux.org/sisyphus/464C3AB4.7020104@ukr.net/>
List-Archive: <http://lore.altlinux.org/sisyphus/>
List-Post: <mailto:sisyphus@altlinux.ru>

=E4=CF=C2=D2=CF=C7=CF =C4=CE=D1.

=EF=C2=CE=C1=D2=D5=D6=C9=CC =C9=CE=D4=C5=D2=C5=D3=CE=D5=C0 =D3=C9=D4=D5=C1=
=C3=C9=C0:
=C5=D3=D4=D8 2 =CD=C1=DB=C9=CE=CB=C9 =D3 =D3=C9=DA=C9=C6=CF=CD.
=CE=C1 =CF=C2=CF=C9=C8 =D3=D4=CF=C9=D4 mysql 5.0.34 "=C9=DA =CB=CF=D2=CF=C2=
=CB=C9", =D4=CF=C5=D3=D4=D8 apt-get install ...
m1
# mysql mysql
mysql> status
=2E..
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    latin1
Conn.  characterset:    latin1
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=


m2
# mysql mysql
mysql> status

Server characterset:    koi8r
Db     characterset:    koi8r
Client characterset:    latin1
Conn.  characterset:    latin1
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=


=D2=D5=DE=CB=C1=CD=C9 =CE=C9=C7=C4=C5 =CB=CF=CE=C6=C9=C7=C9 =CE=C5 =D4=D2=
=CF=C7=C1=CC.
m1
$ rpm -qa|grep MySQL

MySQL-client-5.0.34-alt1
libMySQL-5.0.34-alt1
MySQL-server-5.0.34-alt1

cat /etc/sysconfig/mysqld
# custom server charset
CHSET=3D
# other server opts
OPT=3D


# cat /var/lib/mysql/my.cnf
[mysqld]
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=3D1
# FIXME! bdb maybe work on x86/Linux and amd64/Linux
#skip-bdb
chroot=3D/var/lib/mysql
datadir=3D/db
bdb-logdir=3D/log
log=3D/log/queries
pid-file=3D/mysqld.pid
skip-locking
skip-networking
socket=3D/mysql.sock
tmpdir=3D/tmp
user=3Dmysql
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

m2
$ rpm -qa|grep MySQL

MySQL-client-5.0.34-alt1
libMySQL-5.0.34-alt1
MySQL-server-5.0.34-alt1

cat /etc/sysconfig/mysqld
# custom server charset
CHSET=3D
# other server opts
OPT=3D


# cat /var/lib/mysql/my.cnf
[mysqld]
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=3D1
# FIXME! bdb maybe work on x86/Linux and amd64/Linux
#skip-bdb
chroot=3D/var/lib/mysql
datadir=3D/db
bdb-logdir=3D/log
#log=3D/log/queries
pid-file=3D/mysqld.pid
skip-locking
skip-networking
socket=3D/mysql.sock
tmpdir=3D/tmp
user=3Dmysql


=CB=C1=CB =D7=D3=C5 =D4=C1=CB=C9 =C4=CF=CC=D6=CE=CF =C2=D9=D4=D8 =C9 =CB=C1=
=CB =C9=D3=D0=D2=C1=D7=C9=D4=D8 =D3=C9=D4=D5=C1=C3=C9=C0???