1. Halo Guest, pastikan Anda selalu menaati peraturan forum sebelum mengirimkan post atau thread baru.

ASK Cara Upload SQL yang Ukurannya Besar ke VPS

Discussion in 'Komputer' started by yukuisfi, Feb 7, 2016.

  1. yukuisfi

    yukuisfi Ads.id Pro

    Joined:
    Jul 9, 2015
    Messages:
    306
    Likes Received:
    5
    Location:
    Kediri, Japanese
    Maaf nih, saya lagi belajar gunain VPS dan rencana mau mindah blog saya yg di shared hosting ke VPS, tp dr semalem tersendat upload sql ke phpMyAdmin karna file Sql nya terlalu besar..
    Nah gimana ya solusinya biar tetep bisa ipload sql nya.. Help me please.. Terimakasih.
     
    yukuisfi, Feb 7, 2016
    #1
  2. suksesterus

    suksesterus Super Hero

    Joined:
    Oct 12, 2014
    Messages:
    1,042
    Likes Received:
    107
    di compressed kan ada gzip di export phpmyadmin
     
    suksesterus, Feb 7, 2016
    #2
  3. yukuisfi

    yukuisfi Ads.id Pro

    Joined:
    Jul 9, 2015
    Messages:
    306
    Likes Received:
    5
    Location:
    Kediri, Japanese
    Masih besar gan.. 19.056kb
     
    yukuisfi, Feb 7, 2016
    #3
  4. abadhy

    abadhy Super Hero

    Joined:
    Oct 19, 2009
    Messages:
    826
    Likes Received:
    76
    Location:
    Makassar
    pake software namanya SQL DUMP gan.. dulu ane ampe 100an MB database (pernah develop web sosmed).. itu lancar jaya...
     
    abadhy, Feb 7, 2016
    #4
  5. bajuri

    bajuri Ads.id Pro

    Joined:
    Apr 20, 2007
    Messages:
    381
    Likes Received:
    24
    masuk shared hosting via ssh, pindah ke public dir pake cd lalu jalankan perintah ini :
    mysqldump --opt -u userdb -p namadb > namafileoutput.sql [enter]
    ketik password db [enter]
    tar -czf namafileoutput.sql.tgz namafileoutput.sql [enter]

    login ke vps via ssh lalu jalankan perintah ini :
    wget hxxp://namadomain.com/namafileoutput.sql.tgz [enter]
    tar zxvf namafileoutput.sql.tgz [enter]
    mysql -u usernamedbvps -p namadbdivps < namafileoutput.sql [enter]
    ketik password db [enter]


    catatan:
    db = database
    sesuaikan namadb, userdb, password db dst.. dengan milik agan.
     
    bajuri, Feb 7, 2016
    #5
    iidbae likes this.
  6. yukuisfi

    yukuisfi Ads.id Pro

    Joined:
    Jul 9, 2015
    Messages:
    306
    Likes Received:
    5
    Location:
    Kediri, Japanese
    Terimakasih mas gan.. Mau coba dlu
     
    yukuisfi, Feb 7, 2016
    #6
  7. yukuisfi

    yukuisfi Ads.id Pro

    Joined:
    Jul 9, 2015
    Messages:
    306
    Likes Received:
    5
    Location:
    Kediri, Japanese
    Terimakasih, mo nyoba praktekin
     
    yukuisfi, Feb 7, 2016
    #7
  8. biza_aza

    biza_aza Super Hero

    Joined:
    Jan 1, 2008
    Messages:
    1,736
    Likes Received:
    126
    Location:
    Bantul - Jogja
    iya gan pake cara om bajuri ajah kalo mo restore database ke vps
     
    biza_aza, Feb 7, 2016
    #8
  9. feroxy

    feroxy Hero

    Joined:
    Jul 24, 2011
    Messages:
    695
    Likes Received:
    63
    Iya gan make via Command aja paling 5 detik siap.
     
    feroxy, Feb 9, 2016
    #9

Share This Page