From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Date: Thu, 2 Feb 2006 00:30:23 +0300 From: "Konstantin A. Lepikhov" To: ALT Linux Sisyphus List Message-ID: <20060201213023.GA15400@lks.home> Mail-Followup-To: ALT Linux Sisyphus List Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="OgqxwSJOaUobr8KG" Content-Disposition: inline X-Operation-System: ALT Linux Sisyphus (20051231) 2.6.14-wks26-up-alt3 User-Agent: Mutt/1.5.11 X-AV-Checked: ClamAV using ClamSMTP Subject: [sisyphus] IA: MySQL X-BeenThere: sisyphus@lists.altlinux.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: ALT Linux Sisyphus discussion list List-Id: ALT Linux Sisyphus discussion list List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 01 Feb 2006 21:31:02 -0000 Archived-At: List-Archive: List-Post: --OgqxwSJOaUobr8KG Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi! =E9=D4=C1=CB, =D3=C5=C7=CF=C4=CE=D1 =D7 i/S =CE=C1=D0=D2=C1=D7=CC=C5=CE =CE= =CF=D7=D9=CA MySQL (=D7=C5=D2=D3=C9=D1 5.0.18). =FE=D4=CF =CE=D5=D6=CE=CF = =D6=C4=C1=D4=D8 =CF=D4 =DC=D4=CF=C7=CF: - =D7=CF=DA=CE=C9=CB=CE=D5=D4 =D0=D2=CF=C2=CC=C5=CD=D9 =D3 =CB=CF=C4=C9=D2= =CF=D7=CB=C1=CD=C9. =F4.=CB. =D4=C5=D0=C5=D2=D8 MySQL =D0=CF=C4=C4=C5=D2=D6= =C9=D7=C1=C5=D4 =D5=CE=C9=CB=CF=C4, =D4=CF =D3=C5=D2=D7=C5=D2=D5 =D4=C5=D0=C5=D2=D8 =D0=D2=C9=C4=C5=D4=D3=D1 = =D1=D7=CE=CF =C7=CF=D7=CF=D2=C9=D4=D8, =D7 =CB=C1=CB=CF=CA =CB=CF=C4=C9=D2= =CF=D7=CB=C5 =C8=D2=C1=CE=C9=D4=D8 =C9 =CF=D4=C4=C1=D7=C1=D4=D8 =C4=C1=CE=CE=D9=C5, =C2=C5=DA =D5=CB=C1=DA=C1=CE= =C9=D1 =DC=D4=C9=C8 =C4=C1=CE=CE=D9=C8, =CF=CE =C2=D5=C4=C5=D4 =CF=D4=C4=C1= =D7=C1=D4=D8 =D7=D3=C5 =D7 latin1 aka "=D7=CF=D0=D2=CF=D3=C9=CB=C9". =FA=C1=D4=CF =D4=C5=D0=C5=D2=D8= =CD=CF=D6=CE=CF =D0=C5=D2=C5=CB=CF=C4=C9=D2=CF=D7=C1=D4=D8 =CF=D4=D7=C5=D4= =D9 =CE=C1 =CC=C5=D4=D5 :) =FA=C1 =C4=C5=D4=C1=CC=D1=CD=C9 =D0=CF =DC=D4=CF=CD=D5 =D7=CF=D0=D2=CF= =D3=D5 =CC=D5=DE=DB=C5 =D3=CD. =DA=C4=C5=D3=D8 - http://dev.mysql.com/doc/refman/4.1/en/charset.html - =D7=D3=C5, =CB=D4=CF =C9=D3=D0=CF=CC=D8=DA=D5=C5=D4 fulltext indexes, =C4= =CF=CC=D6=CE=D9 =D3=C4=C5=CC=C1=D4=D8 optimize/repair table =C4=CC=D1 myisam =C9 dump/restore =C4=CC=D1 innodb =D0=CF=D3=CC=C5 = =CF=C2=CE=CF=D7=CC=C5=CE=C9=D1, =D4.=CB. =C9=DA=CD=C5=CE=C9=CC=D3=D1 =D0=CF=D2=D1=C4=CF=CB =C9=CE=C4=C5=CB=D3=C9= =D2=CF=D7=C1=CE=C9=D1 =C4=CC=D1 TEXT columns. - =EE=C1=DE=C9=CE=C1=D1 =D3 =D7=C5=D2=D3=C9=C9 4.1 =C9=DA=CD=C5=CE=C9=CC=D3= =D1 =C1=CC=CF=C7=CF=D2=C9=D4=CD =C8=C5=DB=C9=D2=CF=D7=C1=CE=C9=D1 =D0=C1=D2= =CF=CC=C5=CA =C6=D5=CE=CB=C3=C9=C5=CA password(), =D3=CD. http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html. =E4=CC=D1 =D3=CF=D7=CD=C5=D3=D4=C9=CD=CF=D3=D4=C9 =D3=CF =D3=D4=C1=D2=D9=CD=C9 =CB= =CC=C9=C5=CE=D4=C1=CD=C9 (<=3D4.0) =D3=C5=D2=D7=C5=D2 =DA=C1=D0=D5=D3=CB=C1= =C5=D4=D3=D1 =D3 =CF=D0=C3=C9=C5=CA old-passwords=3D1, =DE=D4=CF =C4=CF=D0=D5=D3=CB=C1=C5=D4 =C9=D3=D0=CF=CC= =D8=DA=CF=D7=C1=CE=C9=C5 =D3=D4=C1=D2=D9=C8 =C8=C5=DB=C5=CA. - =F7=D3=C5, =CB=D4=CF =C9=D3=D0=CF=CC=D8=DA=D5=C0=D4 AUTOCOMMIT=3D1 =C9 LO= CK TABLES =D7 innodb, =C4=CF=CC=D6=CE=D9 =C4=CF=C2=C1=D7=C9=D4=D8 =D7 /var/lib/mysql/my.cnf =D3=D4=D2=CF=CB=D5 innodb_table_locks=3D0, =C9= =CE=C1=DE=C5 =D7=CF=DA=CD=CF=D6=CE=D9 =C2=CC=CF=CB=C9=D2=CF=D7=CB=C9 =D7 =D2=C1=C2=CF=D4=C5 SQL =D0=D2=C9=CC=CF= =D6=C5=CE=C9=CA. - =CB=C1=CB =C9=DA=D7=C5=D3=D4=CE=CF, =D4=C9=D0 =C8=D2=C1=CE=C9=CC=C9=DD=C1= dbd =CE=C5 =D0=CF=C4=C4=C5=D2=D6=C9=D7=C1=C5=D4 x86_64, =D0=CF=DC=D4=CF=CD= =D5, =D4.=CB. =CD=D9 =D3=CF=C2=C9=D2=C1=C5=CD =D4=C5=D0=C5=D2=D8 =D0=CF=C4 2 =C1=D2=C8=C9=D4= =C5=CB=D4=D5=D2=D9, bdb-storage =CF=D4=CB=CC=C0=DE=C5=CE =D0=CF-=D5=CD=CF= =CC=DE=C1=CE=C9=C0 =D7 /var/lib/mysql/my.cnf. =F4=C5, =CB=D4=CF =C9=D3=D0=CF=CC=D8=DA=D5=C5=D4 b= db =C9 =CF=C2=CE=CF=D7=CC=D1=C5=D4=D3=D1 =CE=C1 =DC=D4=D5 =D7=C5=D2=D3=C9=C0 MySQL =C4=CF=CC=D6=CE=D9 =DA=C1=CB=CF=CD=CD=C5=CE=D4= =C9=D2=CF=D7=C1=D4=D8 =D3=D4=D2=CF=CB=D5 skip-bdb =D7 /var/lib/mysql/my.cnf (=D4=C1=CB=D6=C5 =DC=D4=CF =CD=CF=C7=D5=D4 =D3=C4= =C5=CC=C1=D4=D8 =CF=C2=CC=C1=C4=C1=D4=C5=CC=C9 amd64, =D4.=CB. =D5 =CE=C1=D3 =C5=D3=D4=D8 =D7=CF=CC=DB=C5=C2=CE=D9=CA =D0=C1=D4=DE=C9=CB, = =C4=C5=CC=C1=C0=DD=C9=CA =D7=CF=DA=CD=CF=D6=CE=D9=CD =D2=C1=C2=CF=D4=D5 bdb= =CE=C1 x86_64 =C9 amd64). =FC=D4=C1 =CF=D0=C3=C9=D1 =CF=C2=D3=D5=D6=C4=C1=C5=CD=C1, =D1 =D3= =CB=CC=CF=CE=D1=C0=D3=D8 =CB runtime =D0=D2=C1=D7=CB=C5 my.cnf =D7 =DA=C1=D7=C9=D3=C9=CD=CF=D3=D4=C9 =CF=D4 =D3=C2=CF=D2=CF=DE=CE=CF=CA =C1= =D2=C8=C9=D4=C5=CB=D4=D5=D2=D9. =F5 =CD=C5=CE=D1 =D0=C5=D2=C5=C5=DA=C4 =D0=D2=CF=DB=C5=CC =C2=CF=CC=C5=C5-= =CD=C5=CE=C5=C5 =C7=CC=C1=C4=CB=CF, =CF=D3=CF=C2=D9=C8 =D0=D2=CF=C2=CC=C5= =CD =CE=C5 =DA=C1=CD=C5=D4=C9=CC :) =F4=C1=CB=D6=C5 =D7 i/S =D7=D9=CC=CF=D6=C5=CE libmysqlclient12 =C4=CC=D1 = =D0=CF=C4=C4=C5=D2=D6=C1=CE=C9=D1 =D2=C1=C2=CF=D4=CF=D3=D0=CF=D3=CF=C2=CE= =D9=CD=C9 =D3=D4=C1=D2=D9=C8 =D0=D2=C9=CC=CF=D6=C5=CE=C9=CA, =D0=CF =CB=C1=CB=C9=CD-= =D4=CF =D0=D2=C9=DE=C9=CE=C1=CD =DA=C1=D7=C9=D3=D1=DD=C9=C8 =CF=D4 MySQL 4.= 0.x. =F0=D2=C1=D7=C9=CC=C1 =CF=C2=CE=CF=D7=CC=C5=CE=C9=D1 =D4=C1=CB=CF=D7=D9 (=CB=C1=CB =D0=D2=C5=CC= =CF=D6=C5=CE=C9=C5) - =CB=C1=D6=C4=D9=CA =CD=C1=CE=D4=C5=CA=CE=C5=D2 =D2=C5= =DB=C1=C5=D4 =D3=C1=CD, =D0=C5=D2=C5=D3=CF=C2=C9=D2=C1=D4=D8 =CC=C9 =C5=C7=CF =D0=D2=C9=CC=CF=D6=C5= =CE=C9=C5 =D3 =CE=CF=D7=CF=CA libMySQL =C9=CC=C9 =CE=C5=D4. =E4=CC=D1 =D5= =D3=CB=CF=D2=C5=CE=C9=D1 =D2=C5=DB=C5=CE=C9=D1 =CD=CF=D6=CE=CF =D0=CF=D3=D4=C1=D7=C9=D4=D8 deadline = =C4=CF 3=C8 =CD=C5=D3=D1=C3=C5=D7, =C1 =D0=CF=D4=CF=CD =D0=C5=D2=C5=D3=C2= =D2=C1=D4=D8 =D7=D3=C5=C8 =D2=CF=C2=CF=D4=CF=CD. =FE=D4=CF =CE=C5 =D3=CF=C2=D2=C1=CC=CF=D3=D8 =C9 =CD= =C1=CE=D4=C5=CA=CE=C5=D2=D9 =CE=C5 =CF=D4=CB=CC=C9=CB=CE=D5=CC=C9=D3=D8 - = =D7=D9=CB=C9=CE=D5=D4=D8 =D7 orphaned, =DE=D4=CF =D3=CF=C2=D2=C1=CC=CF=D3=D8, =CE=CF =CE=C5 =DA=C1=D2=C1= =C2=CF=D4=C1=CC=CF/=CE=C5 =D3=CF=C2=D2=C1=CC=CF=D3=D8 =C9 =CD=C1=CE=D4=C5= =CA=CE=C5=D2=D9 =D0=CF=C4=D4=D7=C5=D2=C4=D1=D4 =D0=D2=CF=C2=CC=C5=CD=D5 - =CF=D4=CB=C1=D4= =C9=D4=D8 =CE=C1 libmysqlclient12 =C9 =D0=C9=CE=C1=D4=D8 upstream. PS =EB=C1=CB =D7=D3=C5=C7=C4=C1, =D0=CF=D3=CC=C5 =CF=C2=CE=CF=D7=CC=C5=CE= =C9=D1 =D5=C2=C5=C4=C9=D4=C5=CC=D8=CE=CF =D2=C5=CB=CF=CD=C5=CE=C4=D5=C0 =D3= =CB=C1=DA=C1=D4=D8 mysql_fix_privilege_tables =C9 =D0=CF=D0=D2=C1=D7=C9=D4=D8 =D7=CC=C1=C4=C5= =CC=D8=C3=C1 =CE=C1 mysql =D5 =C6=C1=CA=CC=CF=D7 =D7 /var/lib/mysql/db/mysql/* =F7=CF=DA=CD=CF=D6=CE=CF, =DC=D4=C1 =CF=D0=C5=D2= =C1=C3=C9=D1 =C2=D5=C4=C5=D4 =C1=D7=D4=CF=CD=C1=D4=C9=DA=C9=D2=CF=D7=C1=CE= =C1 =D7 =D3=CC=C5=C4. =D2=C5=CC=C9=DA=C5. --=20 WBR, Konstantin chat with =3D=3D>ICQ: 109916175 Lepikhov, speak to =3D=3D>JID: lakostis@jabber.org aka L.A. Kostis write to =3D=3D>mailto:lakostis@pisem.net.nospam =2E..The information is like the bank... (c) EC8OR --OgqxwSJOaUobr8KG Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iD8DBQFD4Shv3TEpd8GO1nMRAkajAJ97uOesEDlB776q2BrAUQDR1AWjKwCgkQRw sKIqquQjYryZxYSgC1Kll/0= =b7sS -----END PGP SIGNATURE----- --OgqxwSJOaUobr8KG--