Now Trending:

Cara Mudah Import Database Berukuran Besar di Xampp | Localhost

September 17, 2013 Uncategorized 4 Comments
Hallo, kali ini saya akan berbagi sedikit tutorial cara impor database besar di Xampp. tadi sempet bingung mau impor database forum JCT gagal karena default nya ukuran db yang bisa di impor di Localhost xampp cuma 2mb. Muter muter di google nemunya tutor buat nambah ukuran tapi pake linux :'( . Untung bisa nemu artikel cara simpel impor database yang ukurannya lebih dari 2mb di Xampp .

Langsung saja, buka config.inc.php yang letaknya di CXamppphpmyadmin
Lalu cari baris berikut :
/* Advanced phpMyAdmin features */
$cfg[‘Servers’][$i][‘pmadb’] = ‘phpmyadmin’;
$cfg[‘Servers’][$i][‘bookmarktable’] = ‘pma_bookmark’;
$cfg[‘Servers’][$i][‘relation’] = ‘pma_relation’;
$cfg[‘Servers’][$i][‘table_info’] = ‘pma_table_info’;
$cfg[‘Servers’][$i][‘table_coords’] = ‘pma_table_coords’;
$cfg[‘Servers’][$i][‘pdf_pages’] = ‘pma_pdf_pages’;
$cfg[‘Servers’][$i][‘column_info’] = ‘pma_column_info’;
$cfg[‘Servers’][$i][‘history’] = ‘pma_history’;
$cfg[‘Servers’][$i][‘designer_coords’] = ‘pma_designer_coords’;
$cfg[‘Servers’][$i][‘tracking’] = ‘pma_tracking’;
$cfg[‘Servers’][$i][‘userconfig’] = ‘pma_userconfig’;
$cfg[‘Servers’][$i][‘recent’] = ‘pma_recent’;
$cfg[‘Servers’][$i][‘table_uiprefs’] = ‘pma_table_uiprefs’;

Nah, tambahkan kode berikut di bawahnya ;
$cfg[‘UploadDir’] = ‘akicha’;

sehingga menjadi :
/* Advanced phpMyAdmin features */
$cfg[‘Servers’][$i][‘pmadb’] = ‘phpmyadmin’;
$cfg[‘Servers’][$i][‘bookmarktable’] = ‘pma_bookmark’;
$cfg[‘Servers’][$i][‘relation’] = ‘pma_relation’;
$cfg[‘Servers’][$i][‘table_info’] = ‘pma_table_info’;
$cfg[‘Servers’][$i][‘table_coords’] = ‘pma_table_coords’;
$cfg[‘Servers’][$i][‘pdf_pages’] = ‘pma_pdf_pages’;
$cfg[‘Servers’][$i][‘column_info’] = ‘pma_column_info’;
$cfg[‘Servers’][$i][‘history’] = ‘pma_history’;
$cfg[‘Servers’][$i][‘designer_coords’] = ‘pma_designer_coords’;
$cfg[‘Servers’][$i][‘tracking’] = ‘pma_tracking’;
$cfg[‘Servers’][$i][‘userconfig’] = ‘pma_userconfig’;
$cfg[‘Servers’][$i][‘recent’] = ‘pma_recent’;
$cfg[‘Servers’][$i][‘table_uiprefs’] = ‘pma_table_uiprefs’;
$cfg[‘UploadDir’] = ‘akicha’;

lalu save config.inc.php
Langkah selanjutnya adalah membuat folder akicha di direktori phpmyadmin

Sampai disinis emuanya beres.
Lalu cara impor databasenya gimana ?
Letakkan file database nya di folder akicha tadi.
Lihat ss :

Langkah selanjutnya, tinggal masuk localhost/phpmyadmin
Buat db, lalu klik impor

Tuh, ada opsi lain selain impor menggunakan fitur upload :v
Ya tinggal di impor dan…

Jrenggggg…
Impor database sukses 😀

Sekian, mohon maaf bila ada kekurangan.

NB : folder akicha bisa diganti sesuai keinginan. Sesuaikan juga dengan config nya.

Shares

Related Posts

About The Author

Yoo Cherry

sysadmin / blogger / geek / ubuntu user

Tags:

4 Comments

  1. cak oni September 20, 2013 Reply

    Patut dicoba nih kang

  2. hendaru hermawan December 29, 2013 Reply

    thanks Gan sangat bermanfaat

  3. CITRA SHOP February 11, 2014 Reply

    Produk yang Kami tawarkan semuanya aslyOriginal,
    Ada Garansi Resmi Distributor dan Semua Produk Kami Baru dan Msh Tersegel dLm BOX_nya.dan Buruan belanja dan dapatkan promo dari kami untuk semua produk kami.Dijual> BlackBerry> Nokia> Samsung> Apple> Acer> Dell> Nikon. beminat hub/sms 0857-3103-0120 atau klik website resmi kami http:/Citra-shopelektroniik.blogspot.com

    Ready Stock !
    BlackBerry 9380 Orlando – Black
    Rp.900.000,-

    Ready Stock !
    BlackBerry Curve 8520 Gemini
    Rp.500.000,-

    Ready Stock !
    BlackBerry Bold 9780 Onyx 2
    Rp.800.000,-

    Ready Stock !
    Blackberry Curve 9320
    Rp.700.000,-

    Ready Stock !
    Samsung Galaxy Tab 2 (7.0)
    Rp. 1.000.000

    Ready Stock !
    Samsung Galaxy Nexus I9250 – Titanium Si
    Rp.1.500.000,-

    Ready Stock !
    Samsung Galaxy Note N7000 – Pink
    Rp.1.700.000

    Ready Stock !
    Samsung Galaxy Y S5360 GSM – Pure White
    Rp.500.000,-

    Nokia Lumia 800 MORE PICTURES
    Ready Stock !
    Nokia Lumia 800 – Matt Black
    Rp.1.700.000,-

    Ready Stock !
    Nokia Lumia-710-white
    Rp. 900.000,-

    Ready Stock ! Nokia C2-06 Touch & Type – Dual GSMRp.450.000,-

    Nokia Lumia 710 T-Mobile MORE PICTURES
    Ready Stock !
    Nokia Lumia 710 – Black
    Rp. 900.000,-
    Ready Stock !
    Apple iPhone 4S 16GB (dari XL) – Black
    Rp.1.200.000,-

    Ready Stock !
    Apple iPhone 4S 16GB (dari Telkomsel)
    Rp.1.200.000,-

    Ready Stock !
    Apple iPod Touch 4 Gen 8GB
    Rp.700.000

    Ready Stock !
    APPLE iPod Nano 8GB – Pink
    Rp.500.000,-

    Ready Stock !
    Acer Aspire 4755G Core i5 2430 Linux Blue
    Rp 1.700.000

    Acer Aspire One AOD270 10.1" Netbook
    Ready Stock !
    Acer Aspire One AOD270 10.1
    Rp. 1.000.000,-

    Acer TravelMate TM8481-2462G32 14" Notebook
    Ready Stock !
    Acer TravelMate TM8481-2462G32
    Rp. 1.400.000

    Ready Stock !
    Acer ICONIA Tab W500 10.1" Tablets Notebook
    Rp. 1.100.000,-

    Ready Stock !
    Nikon D7000 kit 18-105mmRp.1.700.000

    Ready Stock !
    Nikon D90 Kit 18-105mm Vr
    Rp 1.300.000

    Ready Stock !
    Nikon Coolpix L 120 Red
    Rp. 900.000

    Ready Stock !
    Nikon Coolpix P 500 Black
    Rp 1.000.000 Ready Stock !

  4. Anonim June 19, 2014 Reply

    Thanks gan..
    ilmunya bermanfaat..
    ane dah coba dan berhasil

Leave a Reply