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.204.143.151 as permitted sender) client-ip=10.204.143.151; Authentication-Results: mr.google.com; spf=pass (google.com: domain of adobrovolskii@gmail.com designates 10.204.143.151 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=b6h0KBZcdKDlspemrjyQi8ixnKMJEcSBEZkuAnrVqUk=; b=w0SSdu7qepZbejyj3aN90PHDRLkQvrVJGQxEKXBgM97sbHHCwSYXp/fnUheRo0s3dF rQb3GDmDtvbuuQfJ/ytvsAKIQ86alUb0GjkqK+mqp+zyOTzDjeV0FJ5a3L7xbpJKrrP8 Ce3Pcq7WEYHV7dR43/yNKDSx17xVX1DbbXqc4= MIME-Version: 1.0 In-Reply-To: References: <4F4D1DC2.9010204@iop.kiev.ua> <201202291619.56552.cas@altlinux.ru> <201202291819.58568.cas@altlinux.ru> From: adobrovolskii Date: Wed, 29 Feb 2012 17:18:53 +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 15:19:20 -0000 Archived-At: List-Archive: List-Post: mysql> CHECK TABLE columns_priv FOR UPGRADE; +--------------------+-------+----------+----------------------------------= -----------------------------+ | 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) myisamchk /var/lib/mysql/db/mysql/columns_priv Checking MyISAM file: /var/lib/mysql/db/mysql/columns_priv Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 # myisamchk -r /var/lib/mysql/db/mysql/columns_priv - recovering (with sort) MyISAM-table '/var/lib/mysql/db/mysql/columns_priv= ' Data records: 0 - Fixing index 1 mysqldump --quick mysql > mysql.sql mysqldump: Got error: 1034: Incorrect key file for table 'columns_priv'; try to repair it when using LOCK TABLES =E5=D3=D4=D8 =D7=C1=D2=C9=C1=CE=D4 =D7=D9=CC=C5=DE=C9=D4=D8 =C2=C1=DA=D9? = =E9=CC=C9 =D0=D2=CF=DD=C5 =DA=C1=C2=D9=D4=D8 =CF =CE=C9=C8? =F5=C4=C1=CC=C9=D4=D8 =C9 =CE=C1=DE=C1=D4=D8 =D7=D3=C5 =DA=C1=CE=CF=D7=CF? --=20 Regards, Andrii Dobrovol`s`kyj