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


Status
Not open for further replies.

cyberidiot

Poster 2.0
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'

attachment.php


masalahnya di mana ya?

mohon pencerahannya :o
 

Attachments

  • sql.jpg
    sql.jpg
    35.8 KB · Views: 40

cyberidiot

Poster 2.0
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?
 

jagoan

Apprentice 1.0
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 :)
 

mustafaramadhan

Hosting Guru
Jika ada 'skip-innodb' di /etc/my.cnf, hapus atau inaktifkan dengan '#skip-innodb' dan kemudian restart mysql dengan 'service mysqld restart'.
 
Status
Not open for further replies.

Top