cara import data base dengan file sql 200 M

Discussion in 'Masalah Teknik dan Keamanan' started by shara nurul, 9 Jul 2013.

Thread Status:
Not open for further replies.
  1. shara nurul

    shara nurul Apprentice 1.0

    Messages:
    234
    Likes Received:
    1
    Trophy Points:
    18
    Selamat malam para master,mohon maaf sebelumnya jika salah room

    Bagaimana ya cara import database dengan ukuran file sqlnya 200 mb,karena di share hosting maksimal 50 mb

    search di google ada cara dengan dump mysql db ,tetapi saya ragu ngerjainnya

    mohon pencerahannya para master

    Salam
    Nurul
     
  2. mustafaramadhan

    mustafaramadhan Hosting Guru

    Messages:
    3,237
    Likes Received:
    857
    Trophy Points:
    113
    PhpMyAdmin bisa proses sql dalam bentuk zip.
     
  3. cpserv

    cpserv Expert 1.0

    Messages:
    866
    Likes Received:
    123
    Trophy Points:
    43
    itu di shared hosting? titip sama owner/providernya sih harusnya boleh. udah ditanya sama mereka? atau klo punya akses shell (jailed shell minimal) jalanin ini :

    export : mysqldump -u usernya -p namadbnya > namafilenya.sql
    nanti ditanya buat masukin passwordnya si 'usernya'

    import : mysql -u usernya -p namadbnya < namafilenya.sql
    nanti ditanya buat masukin passwordnya si 'usernya' juga.
     
    erawanarifn and Adhie like this.
  4. mgilank

    mgilank Apprentice 1.0

    Messages:
    263
    Likes Received:
    34
    Trophy Points:
    28
  5. shara nurul

    shara nurul Apprentice 1.0

    Messages:
    234
    Likes Received:
    1
    Trophy Points:
    18
    makasih ya mas akan saya coba dulu
     
  6. geekmedia

    geekmedia Beginner 2.0

    Messages:
    58
    Likes Received:
    3
    Trophy Points:
    8
    bener apa kata mustafaramadhan,

    itu 200 MB sudah dalam bentuk zip belum? biasanya perbandingan yg blm dikompres dengan yang dikompres sekitar 1-2:10
     
  7. PusatHosting

    PusatHosting Hosting Guru Web Hosting

    Messages:
    3,346
    Likes Received:
    326
    Trophy Points:
    83
    Tanyakan sama provider hostingnya, biasanya akan dibantu importkan melalui shell
     
  8. rendy

    rendy Hosting Guru DWH Guardian Web Hosting (Company)

    Messages:
    2,794
    Likes Received:
    241
    Trophy Points:
    63
    di split kalau ga salah bisa
     
  9. shara nurul

    shara nurul Apprentice 1.0

    Messages:
    234
    Likes Received:
    1
    Trophy Points:
    18
    kalau di split caranya gimana mas
     
  10. JuraganWebHosting

    JuraganWebHosting Apprentice 1.0

    Messages:
    226
    Likes Received:
    13
    Trophy Points:
    18
    kalau cara kuno yang pernah saya jalanin itu, di jalanin query SQL nya melalui phpMyAdmin tapi di bagi2 enggak semuanya sekaligus, misalnya ada 12 tabel.. jadi di bagi per tabel.. supaya enggak berat.. mudah2an memberi inspirasi :D
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...