Create Database, Import(Backup) dan Export(Restore) Database pada MySQL

Jaka telah dibaca : 105697 kali

Tutorial ini adalah lanjutan dari tutorial sebelumnya (cara Install xampp 1.7.3), sekarang saya akan membahas Create Database, Import(Backup) dan Export(Restore) Database pada MySQL, pada tutorial ini saya menggunakan software PhpMyAdmin yang sudah ada dalam paket instalasi xampp 1.7.3 yang sudah diinstall seperti pada sebelumnya (cara Install xampp 1.7.3). sebelum melanjutkan, agar tidak terjadi kesalahan persepsi kita akan bahas dulu apa itu xampp, PhpMyAdmin dan MySQL.

phpMyAdmin adalah perangkat lunak bebas yang ditulis dalam bahasa pemrograman PHP yang digunakan untuk menangani administrasi MySQL melalui Jejaring Jagat Jembar (World Wide Web). phpMyAdmin mendukung berbagai operasi MySQL, diantaranya (mengelola basis data, tabel-tabel, bidang (fields), relasi (relations), indeks, pengguna (users), perizinan (permissions), dan lain-lain).

Sumber : https://id.wikipedia.org/wiki/PhpMyAdmin

 

XAMPP (/icon?zæmp/ atau /??ks.æmp/) adalah perangkat lunak bebas, yang mendukung banyak sistem operasi, merupakan kompilasi dari beberapa program.

Fungsinya adalah sebagai server yang berdiri sendiri (localhost), yang terdiri atas program Apache HTTP Server, MySQLdatabase, dan penerjemah bahasa yang ditulis dengan bahasa pemrograman PHP dan Perl. Nama XAMPP merupakan singkatan dari X (empat sistem operasi apapun), Apache, MySQL, PHP dan Perl. Program ini tersedia dalam GNU General Public License dan bebas, merupakan web server yang mudah digunakan yang dapat melayani tampilan halaman web yang dinamis.

Sumber : https://id.wikipedia.org/wiki/XAMPP

 

MySQL adalah sebuah perangkat lunak sistem manajemen basis data SQL (bahasa Inggris: database management system) atau DBMS yang multithreadmulti-user, dengan sekitar 6 juta instalasi di seluruh dunia. MySQL AB membuat MySQL tersedia sebagaiperangkat lunak gratis dibawah lisensi GNU General Public License (GPL), tetapi mereka juga menjual dibawah lisensi komersial untuk kasus-kasus di mana penggunaannya tidak cocok dengan penggunaan GPL.

Tidak sama dengan proyek-proyek seperti Apache, di mana perangkat lunak dikembangkan oleh komunitas umum, dan hak ciptauntuk kode sumber dimiliki oleh penulisnya masing-masing, MySQL dimiliki dan disponsori oleh sebuah perusahaan komersialSwedia MySQL AB, di mana memegang hak cipta hampir atas semua kode sumbernya. Kedua orang Swedia dan satu orangFinlandia yang mendirikan MySQL AB adalah: David Axmark, Allan Larsson, dan Michael "Monty" Widenius.

MySQL adalah sebuah implementasi dari sistem manajemen basisdata relasional (RDBMS) yang didistribusikan secara gratis dibawah lisensi GPL (General Public License). Setiap pengguna dapat secara bebas menggunakan MySQL, namun dengan batasan perangkat lunak tersebut tidak boleh dijadikan produk turunan yang bersifat komersial. MySQL sebenarnya merupakan turunan salah satu konsep utama dalam basisdata yang telah ada sebelumnya; SQL (Structured Query Language). SQL adalah sebuah konsep pengoperasian basisdata, terutama untuk pemilihan atau seleksi dan pemasukan data, yang memungkinkan pengoperasian data dikerjakan dengan mudah secara otomatis.

Kehandalan suatu sistem basisdata (DBMS) dapat diketahui dari cara kerja pengoptimasi-nya dalam melakukan proses perintah-perintah SQL yang dibuat oleh pengguna maupun program-program aplikasi yang memanfaatkannya. Sebagai peladen basis data, MySQL mendukung operasi basisdata transaksional maupun operasi basisdata non-transaksional. Pada modus operasi non-transaksional, MySQL dapat dikatakan unggul dalam hal unjuk kerja dibandingkan perangkat lunak peladen basisdata kompetitor lainnya. Namun pada modus non-transaksional tidak ada jaminan atas reliabilitas terhadap data yang tersimpan, karenanya modus non-transaksional hanya cocok untuk jenis aplikasi yang tidak membutuhkan reliabilitas data seperti aplikasi blogging berbasis web (wordpress), CMS, dan sejenisnya. Untuk kebutuhan sistem yang ditujukan untuk bisnis sangat disarankan untuk menggunakan modus basisdata transaksional, hanya saja sebagai konsekuensinya unjuk kerja MySQL pada modus transaksional tidak secepat unjuk kerja pada modus non-transaksional.

Sumber : https://id.wikipedia.org/wiki/MySQL

Bila ingin memahami lengkap tentang perintah – perintah MySQL bisa dipelajari di sini. 

Ok, selanjutnya kita mulai, buka browser (Mozilla, Chrome, Internet Explore, dsb), ketikkan url http://localhost/phpmyadmin/

 

 

A.   MEMBUAT DATABASE (Create Database)

 

1. Untuk membuat Database baru pada halaman Beranda (Home), ketikkan nama database lalu click Create

2. Berikut tampilan bila Create database telah berhasil

 

B.    IMPORT (Restore) DATABASE

 

1. Click tab Import

2. Click Choose file (mungkin bisa berbeda tulisan bila menggunakan browser selain chrome atau menggunakan browser dengan bahasa selain English)

 

 

3. Pilih File backup yang berextensi .sql lalu click Open

4. Click Go

 

B.   Export(Backup) DATABASE

 

1 .Click tab Export

2. Pilih Jenis file export lalu click Go, file Export akan tersimpan di folde Download default pada settingan browser

Catatan : File Backup yang dapat di Import/Restore kembali hanya file dalam bentuk .sql

Demikian tutorial kali ini, terimakasih sudah mampir di web saya.

 


Instalasi Hamachi dan Koneksi Program Ji-software untuk Kontrol jarak jauh (VIA INTERNET)


Tinggalkan Komentar
9517 Komentar :

RobertRiz

26 Mei 2018 - 07:03:41

dosa cialis

[url=http://candiancialisuy.com/]cialis cheap[/url]

generic cialis onlineviagra in deutschland online

[url=http://viagralkas.com/]viagra cheap[/url]

viagra cheapcialis viagra oder levitra

[url=http://viagranelius.com/]generic viagra[/url]

buy generic viagra

SelekhovaRiz

26 Mei 2018 - 07:02:22

viagra sin receta pharmacy uk|viagra hypotension|cialis viagra venta|if a woman takes viagra|viagra vra|viagra occhi gonfi|viagra geneve|nous gnrique pour viagra|generic viagra from australia|we like it viagra in mexico|viagra cheap kanada|craigslist viagra bust|limbaugh costa rica viagra|viagra kaufen seris|best way purchase viagra|tesco pharmacy viagra price|buy viagra pill bangalore|viagra terapia antipertensiva|what drugs work like viagra|click here viagra in uk|avis achat viagra en ligne|only here order cheap viagra|visit web site cheapest viagra|var kan man bestalla viagra|apotheke viagra turkei|150 mg viagra for sale|viagra schweiz|preis fr viagra an walmart|viagra rezeptfrei wo|viagra dosis tabletas|preis viagra|marque gnrique de viagra|we use it online order viagra|viagra online kaufen zoll|2 generic viagra day|click here viagra on sale|viagra online pharmacy germany|real viagra internet|irlanda viagra barata|toronto viagra|viagra a domicili|xlpharmacy generic viagra|viagra barato profesional|discount canadian viagra|costo del viagra in farmacia|reliable generic viagra|viagra kostenlo|buying viagra from craigslist|phucom viagra|online viagra kaufen|generic viagra in stores|only today viagra label|viagra for sale on ebay|viagra limbiate|buy viagra cuprus|cialis cost vs viagra|pfizer canada viagra price|viagra rezeptfrei kaufen com|viagra home office|viagra online espa|viagra dealers in japanese|good choice pfizer viagra uk|click here viagra 10mg|pink viagra women uk|natural herbs viagra|viagra shop in karachi|viagra bestellung|abra 100 viagra|viagra kaufen pillendienst|billige viagra cialis|viagra viagra 34434 cheap buy|content levitra or viagra|viagra for sale toronto|look there brand viagra|viagra for sale in uk|gibt viagra kaufen|importing viagra to canada|viagra lo mismo es el que|viagra et professionnel|como conseguir viagra gratis|viagra and heart attacks|viagra por favor|viagra di vendite|online purchase of viagra|order viagra py phone|viagra online us|t make viagra|usa viagra cheap info|viagra kaufen holland apotheke|diferencia viagra generico|how much will viagra soft cost|wow top viagra online sales|buy viagra for women cheap|just try get viagra in canada|viagra tmoignage|online viagra preise|buy original viagra|viagra food|buy super viagra|what does 100mg of viagra do|viagra preis sterreich|viagra rezeptfrei 25m|viagra achat discret|generico viagra nome|gold viagra wholesale|viagra pill looks like|does viagra pills in pregnancy|acheter vrai viagra en ligne|cdiscount viagra|viagra tablet bestellen|mouse found viagra|medicinale generico del viagra|viagra placebo kaufen|low cost canadian viagra|buy viagra in san antonio|online viagra sales australia|viagra medical store india|try it viagra to order|viagra aus kanada bestellen|vigour golden viagra 800mg|viagra in sri lanka|buy one viagra sample|i recommend viagra 30 mg|viagra prices philippines|what is viagra super active|viagra 20mg|bonuses buy viagra sale|viagra 100mg sildenafil kaufen|mail order pharmacy viagra|directions for use viagra|viagra a prezzi bassissim|buy unprescribed viagra|american express viagra|only for you india viagra|order viagra soft overnight|viagra vs cialis side effects|la prescrizione per viagra nz|buy viagra soft fast shipping|viagraprice in bangalore 2011|try it natural viagra|c g v cheap generic viagra|viagra generiques|in toronto viagra|viagra more drug side effects|prix du viagra au luxembourg|viagra from canada|stay up viagra sample|generische viagra bestellen|best website to buy viagra|we use it buy viagra tablet|viagra femminile vendita|viagra generika amazon|viagra 50mg billig kaufen|gold viagra cialis levitr|tadalafil viagra gnrique|sildenafil viagra 100m|viagra en pharmacie belgique|viagra alpha pharma|viagra uk luogo al sicuro|viagra 50mg cost|how to buy viagra at tesco|canada buy viagra|chantillon de viagra rapide|order viagra mastercard|viagra vs other drugs|viagra probe online|usefull link viagra overnite|where to buy viagra in uk|cocaina viagra|viagra kapseln|viagra et kamagra|toronto viagra store|visit web site cheap viagra uk|viagra levitra generique|viagra en lnea en suisse|cheap brand viagra online|costo del viagra en chile|cheappfizer viagra 100gm|online viagra female pink|no usa prescription viagra|buy viagra suisse|dr x viagra discount|can i buy viagra in india|generic viagra priligy|150 mg viagra too much|viagra canada|google viagra discounts|prince william viagra beer|viagralike pills|viagra dure|viagra super on line sales|viagra canadien|ab wann kann man viagra kaufen|genuine pfizer viagra online|purchase viagra sample|softtabs viagra|herbal viagra for men india|donde comprar viagra gold 100|enter site generic viagra|pfizer viagra online india|try it 5mg viagra|cosa costa viagra farmacia|buy viagra sublingual pills|picture of viagra|lowest prices for viagra o|viagra in the water|viagra fr die frau flssig|only now generic viagra cheap|phizer viagra canada|viagra 50 mg prezzo farmacia|viagra preise apotheke|viagra strips australia|click now buy viagra pills|precios en viagra britnico|dosage of liquid viagra|acheter du viagra doctissimo|acquistare cialis viagra|viagra soft barato|viagra walgreens price|viagra for free|viagra cialis deutschland|viagra generika hollan|pastilla de viagra de usa|can buy you viagra|viagra 25 mg tabletki|compra viagra generico espana|viagra para jovenes|acheter viagra europe|buy real viagra pills usa|viagra movie|viagra 100mg how many pills|viagra 50mg for sale ireland|best viagra websites|viagra ricetta medica svizzer|what age takes viagra|alternative zu viagra wirkun|watermelon viagra rines|buy sample generic viagra|genericviagra org choice|can you take viagra just once|how do i buy lady viagra|viagra femenina espaa|buy legitimate viagra online|follow link gel viagra|viagra gels online|viagra indiano prezzi|sample of viagra prescription|look there viagra 50 mg|wellcare viagra costs|viagra pfizer teva

[url=http://viagraonbizw.com/]buy viagra online[/url]
buy viagra

viagra sin receta pharmacy uk|viagra hypotension|cialis viagra venta|if a woman takes viagra|viagra vra|viagra occhi gonfi|viagra geneve|nous gnrique pour viagra|generic viagra from australia|we like it viagra in mexico|viagra cheap kanada|craigslist viagra bust|limbaugh costa rica viagra|viagra kaufen seris|best way purchase viagra|tesco pharmacy viagra price|buy viagra pill bangalore|viagra terapia antipertensiva|what drugs work like viagra|click here viagra in uk|avis achat viagra en ligne|only here order cheap viagra|visit web site cheapest viagra|var kan man bestalla viagra|apotheke viagra turkei|150 mg viagra for sale|viagra schweiz|preis fr viagra an walmart|viagra rezeptfrei wo|viagra dosis tabletas|preis viagra|marque gnrique de viagra|we use it online order viagra|viagra online kaufen zoll|2 generic viagra day|click here viagra on sale|viagra online pharmacy germany|real viagra internet|irlanda viagra barata|toronto viagra|viagra a domicili|xlpharmacy generic viagra|viagra barato profesional|discount canadian viagra|costo del viagra in farmacia|reliable generic viagra|viagra kostenlo|buying viagra from craigslist|phucom viagra|online viagra kaufen|generic viagra in stores|only today viagra label|viagra for sale on ebay|viagra limbiate|buy viagra cuprus|cialis cost vs viagra|pfizer canada viagra price|viagra rezeptfrei kaufen com|viagra home office|viagra online espa|viagra dealers in japanese|good choice pfizer viagra uk|click here viagra 10mg|pink viagra women uk|natural herbs viagra|viagra shop in karachi|viagra bestellung|abra 100 viagra|viagra kaufen pillendienst|billige viagra cialis|viagra viagra 34434 cheap buy|content levitra or viagra|viagra for sale toronto|look there brand viagra|viagra for sale in uk|gibt viagra kaufen|importing viagra to canada|viagra lo mismo es el que|viagra et professionnel|como conseguir viagra gratis|viagra and heart attacks|viagra por favor|viagra di vendite|online purchase of viagra|order viagra py phone|viagra online us|t make viagra|usa viagra cheap info|viagra kaufen holland apotheke|diferencia viagra generico|how much will viagra soft cost|wow top viagra online sales|buy viagra for women cheap|just try get viagra in canada|viagra tmoignage|online viagra preise|buy original viagra|viagra food|buy super viagra|what does 100mg of viagra do|viagra preis sterreich|viagra rezeptfrei 25m|viagra achat discret|generico viagra nome|gold viagra wholesale|viagra pill looks like|does viagra pills in pregnancy|acheter vrai viagra en ligne|cdiscount viagra|viagra tablet bestellen|mouse found viagra|medicinale generico del viagra|viagra placebo kaufen|low cost canadian viagra|buy viagra in san antonio|online viagra sales australia|viagra medical store india|try it viagra to order|viagra aus kanada bestellen|vigour golden viagra 800mg|viagra in sri lanka|buy one viagra sample|i recommend viagra 30 mg|viagra prices philippines|what is viagra super active|viagra 20mg|bonuses buy viagra sale|viagra 100mg sildenafil kaufen|mail order pharmacy viagra|directions for use viagra|viagra a prezzi bassissim|buy unprescribed viagra|american express viagra|only for you india viagra|order viagra soft overnight|viagra vs cialis side effects|la prescrizione per viagra nz|buy viagra soft fast shipping|viagraprice in bangalore 2011|try it natural viagra|c g v cheap generic viagra|viagra generiques|in toronto viagra|viagra more drug side effects|prix du viagra au luxembourg|viagra from canada|stay up viagra sample|generische viagra bestellen|best website to buy viagra|we use it buy viagra tablet|viagra femminile vendita|viagra generika amazon|viagra 50mg billig kaufen|gold viagra cialis levitr|tadalafil viagra gnrique|sildenafil viagra 100m|viagra en pharmacie belgique|viagra alpha pharma|viagra uk luogo al sicuro|viagra 50mg cost|how to buy viagra at tesco|canada buy viagra|chantillon de viagra rapide|order viagra mastercard|viagra vs other drugs|viagra probe online|usefull link viagra overnite|where to buy viagra in uk|cocaina viagra|viagra kapseln|viagra et kamagra|toronto viagra store|visit web site cheap viagra uk|viagra levitra generique|viagra en lnea en suisse|cheap brand viagra online|costo del viagra en chile|cheappfizer viagra 100gm|online viagra female pink|no usa prescription viagra|buy viagra suisse|dr x viagra discount|can i buy viagra in india|generic viagra priligy|150 mg viagra too much|viagra canada|google viagra discounts|prince william viagra beer|viagralike pills|viagra dure|viagra super on line sales|viagra canadien|ab wann kann man viagra kaufen|genuine pfizer viagra online|purchase viagra sample|softtabs viagra|herbal viagra for men india|donde comprar viagra gold 100|enter site generic viagra|pfizer viagra online india|try it 5mg viagra|cosa costa viagra farmacia|buy viagra sublingual pills|picture of viagra|lowest prices for viagra o|viagra in the water|viagra fr die frau flssig|only now generic viagra cheap|phizer viagra canada|viagra 50 mg prezzo farmacia|viagra preise apotheke|viagra strips australia|click now buy viagra pills|precios en viagra britnico|dosage of liquid viagra|acheter du viagra doctissimo|acquistare cialis viagra|viagra soft barato|viagra walgreens price|viagra for free|viagra cialis deutschland|viagra generika hollan|pastilla de viagra de usa|can buy you viagra|viagra 25 mg tabletki|compra viagra generico espana|viagra para jovenes|acheter viagra europe|buy real viagra pills usa|viagra movie|viagra 100mg how many pills|viagra 50mg for sale ireland|best viagra websites|viagra ricetta medica svizzer|what age takes viagra|alternative zu viagra wirkun|watermelon viagra rines|buy sample generic viagra|genericviagra org choice|can you take viagra just once|how do i buy lady viagra|viagra femenina espaa|buy legitimate viagra online|follow link gel viagra|viagra gels online|viagra indiano prezzi|sample of viagra prescription|look there viagra 50 mg|wellcare viagra costs|viagra pfizer teva

WilliamTal

26 Mei 2018 - 07:00:38

price of viagra 50mg
best canadian mail order pharmacies
is viagra going generic in 2012
[url=http://canadamdonlineget.com/#]canadian online pharmacies[/url]
does viagra target
viagra without prescription
best viagra pills uk
[url=http://viagradcvy.com/#]viagra without a prior doctor prescription[/url]
easy buy viagra thailand

Blakepoone

26 Mei 2018 - 06:59:07

comprare cialis comprare cialis
[url=http://acquistarecialisitalia.net/]cialis[/url] costo cialis farmacia

AbltaDraps

26 Mei 2018 - 06:54:00

casino online casino online jupiters casino [url=https://onlinecasinoauss24.com/]crown casino[/url]