[HELP] Database Innodb Corrupt

Discussion in 'Masalah Teknik dan Keamanan' started by Grafitianz, 24 Sep 2013.

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

    Grafitianz New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    malam semuanya..mhon maaf kalau lancang post pertama langsung nanya :(

    Gini ceritanya, udah hampir 3 hari databse saya offline gara2 innodb nya corrupt,udah coba menggunakan tips force recovery dengan meletakkan

    innodb_force_recovery = 4 di file my.cnf

    Proses restart setelah pakai itu mysql udah berjalan normal lagi,tapi setelah innodb_force_recovery = 4 dihapus dan mysql di restart. Mysql bakal error lagi (offline)

    Mohon bantuannya mastah2 :(
     
  2. mustafaramadhan

    mustafaramadhan Hosting Guru

    Messages:
    3,237
    Likes Received:
    857
    Trophy Points:
    113
    Jangan-jangan space HD habis kemakan mysql-bin di /var/lib/mysql.

    Kemarin MariaDB saya (pakai innodb) ngadat dan setelah ditelusuri ternyata space habis karena terbentuk file mysql-bin yang banyak dan besar-besar.

    Setelah saya lakukan mysql stop, delete mysql-bin.0* dan kemudian mysql start kemudian semua berjalan normal kembali.
     
  3. Grafitianz

    Grafitianz New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Space hd masih sisa banyak skitar 80gb lebih kok
    Udh saya coba check table mysqlnya dan nemuin 2 tabel yg corrupt,lalu saya delete itu tabel..tp spertinya masih bermasalah
     
  4. localhost

    localhost Apprentice 2.0

    Messages:
    576
    Likes Received:
    39
    Trophy Points:
    28
    coba begini
    pakai innodb_force_recovery = 4 di file my.cnf restart mysql

    lakukan dump ke file sql dengan mysqldump

    buang lagi innodb_force_recovery = 4 di file my.cnf restart mysql

    import ulang file sql ke database

    kadang saya suka pakai cara itu :)
     
  5. Grafitianz

    Grafitianz New Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    udah dilakukan..dan jalan kembali mysqlnya
    Tapi pas proses import muncul error (import manual pakai bigdump)

    Error at the line xx: ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    Sekalian tanya
    kmarin saya dump pakai command
    Code:
    mysqldump –-all-databases > all_the_bases.sql
    Trus restore dngn command
    Code:
    mysql < all_the_bases.sql
    tapi malah muncul error can't create table
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...