11 November, 2008

Error code 1289, SQL state HY000: The 'InnoDB' feature is disabled;

Beberapa Minggu silam saya praktek di Lab Sekolah mencoba mengoneksikan database Mysql dengan Netbeans, Sekolah under Windows n pake Netbeans 6.5 Developer Version plus AppServer, senang bisa konek, tapi rasa senang itu tiba2 raib hehehe bersamaan ketika saya selesai mengetikkan dan akan men Eksequsi perintah SQL terjadilah Error yang belum akuw temui di Linux, Error nya seperti pada gambar Di bawah ini :




Executed successfully in 0 s, 0 rows affected.

Line 1, column 1



Error code 1289, SQL state HY000: The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

Line 3, column 1



Error code 1289, SQL state HY000: The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

Line 14, column 1



Error code 1289, SQL state HY000: The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

Line 26, column 1



Error code 1289, SQL state HY000: The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

Line 40, column 1



Error code 1289, SQL state HY000: The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

Line 51, column 1



Error code 1289, SQL state HY000: The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

Line 63, column 1


Execution finished after 0 s, 6 error(s) occurred.

Karena Lab konek Internet ya...Langsung aja cari solusinya
gak lama kemudian kebetulan langsung dapet berikut langkah2 heheh :

Recommended: Enable InnoDB as MySQL Engine on Windows


  1. Matikan MySQL Server
  2. Buka dan Ubahlah dikit file my.ini (mysql config file), di Tempat kejadian Perkar (TKP) Folder Instalasi MySQL
  3. Klo udah Kebuka tekan F3 dan temukan baris
    skip-innodb beri tanda #  menjadi #skip-innodb



  4. Klo udah Save dan Start MySQL server nya..

    Happy Ending .... Met mencoba lo dah Lancar Cobain ke Linux sebagai OS nya Sama aja ko..

0 comments: