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:
    260
    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,362
    Likes Received:
    900
    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:
    386
    Likes Received:
    58
    Trophy Points:
    28
  5. shara nurul

    shara nurul Apprentice 1.0

    Messages:
    260
    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,435
    Likes Received:
    346
    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,872
    Likes Received:
    283
    Trophy Points:
    83
    di split kalau ga salah bisa
     
  9. shara nurul

    shara nurul Apprentice 1.0

    Messages:
    260
    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...