Loading ...
Sorry, an error occurred while loading the content.
 

Re: [jogja-linux] mysql error

Expand Messages
  • Joshua Jackson
    ... Kalau restart failed? Kalau start gak failed? -- Proud Gentoo User and Java Developer In the free world, why do we need windows and gates? Blog:
    Message 1 of 14 , Jul 1, 2005
      Dedy Hariyadi wrote:
      > Saya menggunakan FC1 ketika service myqld restart kok failed.
      > adakah solusinya?
      >
      Kalau restart failed? Kalau start gak failed?
      --
      Proud Gentoo User and Java Developer
      In the free world, why do we need windows and gates?
      Blog: http://jroller.com/page/thejavafreak
    • milisdad
      ... restart ya failed, start ya failed pa lagi di stop :)
      Message 2 of 14 , Jul 2, 2005
        --- In jogja-linux@yahoogroups.com, Joshua Jackson <joshua@s...> wrote:
        > Dedy Hariyadi wrote:
        > > Saya menggunakan FC1 ketika service myqld restart kok failed.
        > > adakah solusinya?
        > >
        > Kalau restart failed? Kalau start gak failed?
        restart ya failed, start ya failed pa lagi di stop :)
      • fathir hamdi
        ... sapa tahu partisinya penuh buat nyimpen log-nya MySql.. kasus kayak gini pernah kutemuin waktu squid-ku nggak mau nyala gara-gara /var-nya dah 100% :D
        Message 3 of 14 , Jul 2, 2005
          On 7/2/05, milisdad <milisdad@...> wrote:
          > --- In jogja-linux@yahoogroups.com, Joshua Jackson <joshua@s...> wrote:
          > > Dedy Hariyadi wrote:
          > > > Saya menggunakan FC1 ketika service myqld restart kok failed.
          > > > adakah solusinya?
          > > >
          > > Kalau restart failed? Kalau start gak failed?
          > restart ya failed, start ya failed pa lagi di stop :)
          >

          sapa tahu partisinya penuh buat nyimpen log-nya MySql..
          kasus kayak gini pernah kutemuin waktu squid-ku nggak mau nyala
          gara-gara /var-nya dah 100% :D
        • Dedy Hariyadi
          ... tail -f /var/log/mysqld.log to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld]
          Message 4 of 14 , Jul 3, 2005
            Ir. Yahya Kurniawan wrote:

            > Pesan kesalahannya apa?
            > Kayaknya kamu sering tanya error tanpa disertakan pesan kesalahannya, kita
            > jadi susah mau kasih solusi. :)

            tail -f /var/log/mysqld.log

            to the [mysqld] section of init parameters in your my.cnf
            or my.ini. If you want to use InnoDB tables, add to the [mysqld]
            section, for example,
            innodb_data_file_path = ibdata1:10M:autoextend
            But to get good performance you should adjust for your hardware
            the InnoDB startup options listed in section 2 at
            http://www.innodb.com/ibman.html
            050703 23:15:22 /usr/libexec/mysqld: Incorrect information in file:
            './mysql/host.frm'
            050703 23:15:22 mysqld ended

            ini hasil log nya. smoga dapat membantu ku :)
          • Willy Sudiarto Raharjo
            ... coba kamu move direktori /var/lib/mysql/mysql ke nama lain, lalu jalankan mysqld_install_db sebagai user mysql kayaknya file host.frm mu yang corrupt --
            Message 5 of 14 , Jul 3, 2005
              > 050703 23:15:22 /usr/libexec/mysqld: Incorrect information in file:
              > './mysql/host.frm'
              > 050703 23:15:22 mysqld ended
              >
              > ini hasil log nya. smoga dapat membantu ku :)

              coba kamu move direktori /var/lib/mysql/mysql ke nama lain, lalu jalankan
              mysqld_install_db sebagai user mysql
              kayaknya file host.frm mu yang corrupt


              --
              Willy Sudiarto Raharjo
              Registered Linux User : 336579
              Public-key : http://www.informatix.or.id/willy/public-key.txt
              Blog : http://willysr.blogspot.com
              OOo Documentation Project (ID) : http://project.informatix.or.id
              Mandrakelinux Translation Project (ID) :
              http://www.mandrivalinux.com/l10n/id.php3
            Your message has been successfully submitted and would be delivered to recipients shortly.