[ASK] Masalah #1286 - Unknown table engine 'InnoDB'

Discussion in 'Masalah Teknik dan Keamanan' started by cyberidiot, 10 Jul 2013.

Thread Status:
Not open for further replies.
  1. cyberidiot

    cyberidiot Poster 2.0

    Messages:
    126
    Likes Received:
    12
    Trophy Points:
    18
    Selamat pagi,


    Mohon bantuannya kenapa mau backup mysql dari phpmyadmin root,

    ada table yg tulisannya in use, tapi ga bisa dibackup,


    kalau di klik keluar:

    #1286 - Unknown table engine 'InnoDB'

    [​IMG]

    masalahnya di mana ya?

    mohon pencerahannya :o
     

    Attached Files:

    • sql.jpg
      sql.jpg
      File size:
      35.8 KB
      Views:
      40
  2. voezie

    voezie Hosting Guru

    Messages:
    1,771
    Likes Received:
    212
    Trophy Points:
    63
    itu gak support innodb, coba cek di file /etc/my.cfg
     
  3. cyberidiot

    cyberidiot Poster 2.0

    Messages:
    126
    Likes Received:
    12
    Trophy Points:
    18
    file tersebut kosong pak,

    kalau /etc/my.cnf

    isinya cuman ini:

    [mysqld]


    :o
     
  4. cyberidiot

    cyberidiot Poster 2.0

    Messages:
    126
    Likes Received:
    12
    Trophy Points:
    18
    upgrade my sql error:

    [20130712.143405] The following RPMs are unneeded on your system and should be uninstalled:
    [20130712.143405] MySQL51-server.5.1.70-1.cp1136
    [20130712.143405] MySQL51-shared.5.1.70-1.cp1136
    rpmdb: tmp_open: /var/tmp/BDB24030: Read-only file system
    rpmdb: unable to create temporary backing file
    rpmdb: tmp_open: /var/tmp/BDB24030: Read-only file system
    rpmdb: unable to create temporary backing file
    rpmdb: tmp_open: /var/tmp/BDB24030: Read-only file system
    rpmdb: unable to create temporary backing file
    rpmdb: tmp_open: /var/tmp/BDB24030: Read-only file system
    rpmdb: unable to create temporary backing file
    [20130712.143406] Removing 0 broken rpms:
    [20130712.143406] rpm: no packages given for erase

    kenapa ya itu?
     
  5. jagoan

    jagoan Apprentice 1.0 Web Hosting (Company)

    Messages:
    207
    Likes Received:
    20
    Trophy Points:
    18
    Untuk error innodb tersebut, silakan dilakukan pengecekan untuk status innodbnya, apakah innodb running atau tidak?
    dengan menggunakan syntax : "show innodb status;"

    serta silakan dilakukan pengecekan pada file ibdata1 yg digunakan oleh engine innodbnya :)
     
  6. mustafaramadhan

    mustafaramadhan Hosting Guru

    Messages:
    3,237
    Likes Received:
    857
    Trophy Points:
    113
    Jika ada 'skip-innodb' di /etc/my.cnf, hapus atau inaktifkan dengan '#skip-innodb' dan kemudian restart mysql dengan 'service mysqld restart'.
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...