From: adobrovolskii <adobrovolskii@gmail.com> To: ALT Linux Community general discussions <community@lists.altlinux.org> Subject: Re: [Comm] mysql in p6 Date: Wed, 29 Feb 2012 17:18:53 +0200 Message-ID: <CAEv1UXzua-Qx30SkJ3JvxPAEe--ogaRSVJP_MyRFJS-dezPDmg@mail.gmail.com> (raw) In-Reply-To: <CAEv1UXzEpRh5sUF+kCBR0xPBaLdqrR0OWbAWdKwVwjjrebn7bg@mail.gmail.com> 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 Есть вариант вылечить базы? Или проще забыть о них? Удалить и начать все заново? -- Regards, Andrii Dobrovol`s`kyj
next prev parent reply other threads:[~2012-02-29 15:18 UTC|newest] Thread overview: 13+ messages / expand[flat|nested] mbox.gz Atom feed top 2012-02-28 18:32 Andrii Dobrovol`s`kii 2012-02-28 19:57 ` Anton Gorlov 2012-02-29 9:19 ` Андрей Черепанов 2012-02-29 11:43 ` adobrovolskii 2012-02-29 11:53 ` adobrovolskii 2012-02-29 12:19 ` Андрей Черепанов 2012-02-29 13:36 ` adobrovolskii 2012-02-29 14:17 ` adobrovolskii 2012-02-29 14:19 ` Андрей Черепанов 2012-02-29 14:45 ` adobrovolskii 2012-02-29 15:18 ` adobrovolskii [this message] 2012-03-02 7:03 ` Sergey 2012-02-28 20:23 ` Michael Shigorin
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=CAEv1UXzua-Qx30SkJ3JvxPAEe--ogaRSVJP_MyRFJS-dezPDmg@mail.gmail.com \ --to=adobrovolskii@gmail.com \ --cc=community@lists.altlinux.org \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
ALT Linux Community general discussions This inbox may be cloned and mirrored by anyone: git clone --mirror http://lore.altlinux.org/community/0 community/git/0.git # If you have public-inbox 1.1+ installed, you may # initialize and index your mirror using the following commands: public-inbox-init -V2 community community/ http://lore.altlinux.org/community \ mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com public-inbox-index community Example config snippet for mirrors. Newsgroup available over NNTP: nntp://lore.altlinux.org/org.altlinux.lists.community AGPL code for this site: git clone https://public-inbox.org/public-inbox.git