From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on sa.int.altlinux.org X-Spam-Level: X-Spam-Status: No, score=-2.3 required=5.0 tests=AWL,BAYES_00, RCVD_IN_DNSWL_LOW,SPF_PASS autolearn=ham version=3.2.5 Received-SPF: pass (google.com: domain of adobrovolskii@gmail.com designates 10.205.132.1 as permitted sender) client-ip=10.205.132.1; Authentication-Results: mr.google.com; spf=pass (google.com: domain of adobrovolskii@gmail.com designates 10.205.132.1 as permitted sender) smtp.mail=adobrovolskii@gmail.com; dkim=pass header.i=adobrovolskii@gmail.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:content-transfer-encoding; bh=ah0B3iNCIbkTLS5ZjJZgcNTZHMGDECOGLK54kH1Y1kk=; b=bye6ln8glLlKXOvQM/Lv4XUQ82s6+ODOJLKjpAEr1sRZiP0uecFo4vSpErk+z5WyXL VWF50SmAOBr/H4UlBrQZKHx94oi7SUyXOWgI8PQSWqmHc5TzPTPSYI0fwpPx3MNBHEQ5 ysjNl56FYCsbVpXIyzuISOFbQc/Wi38tqY+ug= MIME-Version: 1.0 In-Reply-To: <201202291819.58568.cas@altlinux.ru> References: <4F4D1DC2.9010204@iop.kiev.ua> <201202291619.56552.cas@altlinux.ru> <201202291819.58568.cas@altlinux.ru> From: adobrovolskii Date: Wed, 29 Feb 2012 16:45:48 +0200 Message-ID: To: ALT Linux Community general discussions Content-Type: text/plain; charset=KOI8-R Content-Transfer-Encoding: quoted-printable Subject: Re: [Comm] mysql in p6 X-BeenThere: community@lists.altlinux.org X-Mailman-Version: 2.1.12 Precedence: list Reply-To: ALT Linux Community general discussions List-Id: ALT Linux Community general discussions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 29 Feb 2012 14:46:14 -0000 Archived-At: List-Archive: List-Post: On Wed, Feb 29, 2012 at 4:19 PM, =E1=CE=C4=D2=C5=CA =FE=C5=D2=C5=D0=C1=CE= =CF=D7 wrote: > 29 =C6=C5=D7=D2=C1=CC=D1 2012 adobrovolskii =CE=C1=D0=C9=D3=C1=CC: >> On Wed, Feb 29, 2012 at 2:19 PM, =E1=CE=C4=D2=C5=CA =FE=C5=D2=C5=D0=C1= =CE=CF=D7 wrote: >> > =F0=CF=D0=D2=CF=C2=D5=CA=D4=C5 >> > >> > http://www.ovaistariq.net/490/a-step-by-step-guide-to-upgrading-to-mys= ql- >> > 5-5/ >> >> =FE=D4=CF =C9=CD=C5=CE=CE=CF =D0=D2=C5=C4=CC=C1=C7=C1=C5=D4=D3=D1 =D0=CF= =D0=D2=CF=C2=CF=D7=C1=D4=D8? >> =F1 =DA=C1=D0=D5=D3=D4=C9=CC =D3=C5=D2=D7=C5=D2 =D3 --skip-grant-tables = =EF=CE =D3=D4=C1=D2=D4=C1=CE=D5=CC. =F4=C5=D0=C5=D2=D8 =C5=D3=CC=C9 >> =D0=CF=D3=CD=CF=D4=D2=C5=D4=D8 >> >> mysql> SHOW PLUGINS; >> +------------+--------+----------------+---------------------+---------+ >> >> | Name =9A =9A =9A | Status | Type =9A =9A =9A =9A =9A | Library =9A =9A= =9A =9A =9A =9A | License | >> >> +------------+--------+----------------+---------------------+---------+ >> >> | binlog =9A =9A | ACTIVE | STORAGE ENGINE | NULL =9A =9A =9A =9A =9A = =9A =9A =9A| GPL =9A =9A | >> | partition =9A| ACTIVE | STORAGE ENGINE | NULL =9A =9A =9A =9A =9A =9A = =9A =9A| GPL =9A =9A | >> | ARCHIVE =9A =9A| ACTIVE | STORAGE ENGINE | NULL =9A =9A =9A =9A =9A = =9A =9A =9A| GPL =9A =9A | >> | BLACKHOLE =9A| ACTIVE | STORAGE ENGINE | NULL =9A =9A =9A =9A =9A =9A = =9A =9A| GPL =9A =9A | >> | CSV =9A =9A =9A =9A| ACTIVE | STORAGE ENGINE | NULL =9A =9A =9A =9A = =9A =9A =9A =9A| GPL =9A =9A | >> | MEMORY =9A =9A | ACTIVE | STORAGE ENGINE | NULL =9A =9A =9A =9A =9A = =9A =9A =9A| GPL =9A =9A | >> | MyISAM =9A =9A | ACTIVE | STORAGE ENGINE | NULL =9A =9A =9A =9A =9A = =9A =9A =9A| GPL =9A =9A | >> | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL =9A =9A =9A =9A =9A =9A = =9A =9A| GPL =9A =9A | >> | InnoDB =9A =9A | ACTIVE | STORAGE ENGINE | ha_innodb_plugin.so | GPL = =9A =9A | >> >> +------------+--------+----------------+---------------------+---------+ >> 9 rows in set (0.00 sec) >> >> =F0=CF=DE=C5=CD=D5 =C1=CB=D4=C9=D7=CE=D9 =D7=D3=C5 =C1 =D5=CB=C1=DA=C1= =D4=C5=CC=D8 =C5=D3=D4=D8 =D4=CF=CC=D8=CB=CF =CE=C1 =D0=D2=C9=CE=D5=C4=C9= =D4=C5=CC=D8=CE=CF >> =DA=C1=C7=D2=D5=D6=C5=CE=CE=D9=CA =D0=CC=C1=C7=C9=CE? =F0=CF=D4=CF=CD=D5= =DE=D4=CF =CF=D3=D4=C1=CC=D8=CE=D9=C5 =D7=D3=D4=D2=CF=C5=CE=CE=D9=C5? > =F0=CF=D4=CF=CD=D5 =DE=D4=CF =CE=C5=D4 =D0=CF=C4=C4=C5=D2=D6=CB=C9. mysql= _upgrade =DA=C1=D0=D5=D3=D4=C9=CC=C9? > =F0=D9=D4=C1=CC=D3=D1. =EF=CE =CF=C2=CC=C1=CD=D9=D7=C1=C5=D4=D3=D1. =F7 =C9=CE=D4=C5=D2=C1=CB=D4=C9=D7=CE=CF=CD =D2=C5=D6=C9=CD=C5 =D4=C1=C2=CC= =C9=C3=C1 =CE=C5 =CC=C5=DE=C9=D4=D3=D1 =D0=CF=DE=C5=CD=D5-=D4=CF... mysql> REPAIR TABLE columns_priv -> ; +--------------------+--------+----------+---------------------------------= ------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------------+--------+----------+---------------------------------= ------------------------------+ | mysql.columns_priv | repair | Error | Incorrect key file for table 'columns_priv'; try to repair it | | mysql.columns_priv | repair | error | Corrupt | +--------------------+--------+----------+---------------------------------= ------------------------------+ 2 rows in set (0.01 sec) mysql> CHECK TABLE columns_priv; +--------------------+-------+----------+----------------------------------= -----------------------------+ | Table | Op | Msg_type | Msg_text | +--------------------+-------+----------+----------------------------------= -----------------------------+ | mysql.columns_priv | check | Error | Incorrect key file for table 'columns_priv'; try to repair it | | mysql.columns_priv | check | error | Corrupt | +--------------------+-------+----------+----------------------------------= -----------------------------+ 2 rows in set (0.01 sec) # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck with default connection arguments Running 'mysqlcheck with default connection arguments ...... Repairing tables mysql.columns_priv Error : Incorrect key file for table 'columns_priv'; try to repair it error : Corrupt mysql.db Error : Incorrect key file for table 'db'; try to repair it error : Corrupt mysql.func Error : Incorrect key file for table 'func'; try to repair it error : Corrupt mysql.host Error : Incorrect key file for table 'host'; try to repair it error : Corrupt mysql.tables_priv Error : Incorrect key file for table 'tables_priv'; try to repair it error : Corrupt mysql.user Error : Incorrect key file for table 'user'; try to repair it error : Corrupt ra.cache_page Error : Incorrect key file for table 'cache_page'; try to repair it error : Corrupt ra.node Error : Incorrect key file for table 'node'; try to repair it error : Corrupt ra.term_synonym Error : Incorrect key file for table 'term_synonym'; try to repair it error : Corrupt Running 'mysql_fix_privilege_tables'... ERROR 1034 (HY000) at line 132: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 136: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 138: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 139: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 140: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 143: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 144: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 145: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 151: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 156: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 161: Incorrect key file for table 'tables_priv'; try to repair it ERROR 1034 (HY000) at line 164: Incorrect key file for table 'tables_priv'; try to repair it ERROR 1034 (HY000) at line 173: Incorrect key file for table 'tables_priv'; try to repair it ERROR 1034 (HY000) at line 188: Incorrect key file for table 'columns_priv'; try to repair it ERROR 1034 (HY000) at line 192: Incorrect key file for table 'columns_priv'; try to repair it ERROR 1034 (HY000) at line 202: Incorrect key file for table 'columns_priv'; try to repair it ERROR 1034 (HY000) at line 210: Incorrect key file for table 'func'; try to repair it ERROR 1034 (HY000) at line 218: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 220: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 231: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 237: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 247: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 250: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 254: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 257: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 258: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 259: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 260: Incorrect key file for table 'func'; try to repair it ERROR 1034 (HY000) at line 264: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 268: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 293: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 298: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 312: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 316: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 330: Incorrect key file for table 'func'; try to repair it ERROR 1034 (HY000) at line 332: Incorrect key file for table 'func'; try to repair it ERROR 1034 (HY000) at line 370: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 375: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 376: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 378: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 379: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 381: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 382: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 387: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 388: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 390: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 391: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 393: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 394: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 399: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 405: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 410: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 411: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 413: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 414: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 416: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 417: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 422: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 423: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 425: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 426: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 428: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 429: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 431: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 432: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 434: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 435: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 440: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 441: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 442: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 447: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 454: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 456: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 457: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 458: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 603: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 605: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 606: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 608: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 610: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 611: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 693: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 695: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 696: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 698: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 699: Incorrect key file for table 'host'; try to repair it ERROR 1034 (HY000) at line 701: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 702: Incorrect key file for table 'db'; try to repair it ERROR 1034 (HY000) at line 704: Incorrect key file for table 'user'; try to repair it ERROR 1034 (HY000) at line 710: Incorrect key file for table 'host'; try to repair it FATAL ERROR: Upgrade failed =F7=C5=D3=D8 =D7=D9=D7=CF=C4 =C4=CC=C9=CE=CE=C5=C5. =E9 =DE=C1=D3=D4=D8 =D4= =C1=C2=CC=C9=C3 =CB=CF=CE=D7=C5=D2=D4=D1=D4=D3=D1 =CE=CF=D2=CD=C1=CC=D8=CE= =CF. =EE=C5=D3=CB=CF=CC=D8=CB=CF =D0=CF=CC=D8=DA=CF=D7=C1=D4=C5=CC=D8=D3=CB=C9=C8 =C2=C1=DA =D0=D2=CF=D3=CB= =C1=CB=C9=D7=C1=C0=D4 =C2=C5=DA =DA=C1=CD=C5=DE=C1=CE=C9=CA. --=20 Regards, Andrii Dobrovol`s`kyj