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

Jaka telah dibaca : 105692 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
9515 Komentar :

arrots

10 Mei 2018 - 17:34:19

online cialis
[url=http://cialisonlnrx.com/#]buy cheap cialis online[/url]
india generic cialis
generic cialis

RobertRiz

10 Mei 2018 - 17:29:04

cialis e aspirina

[url=http://candiancialisuy.com/]buy cialis online[/url]

cialis genericis 10mg viagra enough

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

buy generic viagraviagra scadenza

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

viagra online

IngaRiz

10 Mei 2018 - 17:27:46

drug online viagra|viagra price in sydney|dangers of viagra for men|viagra men uk|cheap viagra viagra buy deal|viagra generico preco rj|best site get viagra|viagra come acquistare|viagra netist|generic viagrakamagra uk|viagra tauranga|viagra tablets buy online|viagra russian|look here branded viagra|cheap herbal viagra uk|buy viagra low price|cheap viagra tablets for sale|ap kgr 100 viagra|viagra libre nz muestras|viagra levitra calvizi|viagra ratiopharm kaufen|pillole campione di viagra|viagra nitric oxide|how do i buy viagra in canada|precio viagra generico espaa|viagra generico online|good choice viagra buy now|viagra e tumor|tab viagra|buy viagra online paypal vipps|viagra mg india|viagra price in paris|viagraproben amerika|viagra was ist das|india viagra precio|best viagra to buy|pfizer viagra 0 pills sale|viagra safe dosage|viagra online pharmacies|viagra generika oder pfizer|buy safe viagra|viagra fr den mann kaufen|viagra en europe|boots viagra price|medicare part d viagra|viagra argentina|pfizer viagra kaufen|onde comprar viagra barato|viagra trial offer free|very good site women viagra|viagra online il piu economico|acheter viagra canada|viagra at tescoscost|acquisto viagra femminile|selling viagra in spain|viagra et libido|get sample viagra|canada viagra office|viagra rezeptfrei schnell|beginning dosage viagra|viagra orosolubile pfizer|viagra in new york kaufen|only for you order viagra pill|viagra nombre comercial|viagramg|viagra and cialis combined|with viagra cheap dapoxetine|viagra 100mg risks|brand viagra dose|do u need prescription viagra|tilaa viagraa|candy looks like viagra|generico viagra mg|sex on viagra|pfizer viagra canada patent|cost of viagra generic|viagra bieffekter|il viagra per cardiopatic|achat viagra tunisie|we choice uk viagra sales|viagra original bestellen|viagra homme effet|only here buy viagra in us|cialis vs viagra mg|buy viagra in usa online|price comparisons of viagra|viagra zagreb|where to buy viagra hong kong|female natural viagra|legitimate sites buy viagra|viagrande di sicilia|geniune viagra no prescription|viagra kaufen in den usa|generic viagra in stores|buy viagra perth|only today low cost viagra uk|preis fr generisches viagra|kaufen viagra online|brand viagra soft for sale|viagra increase|siege social viagra canada|viagrande villa di bella|viagra prezzi farmaci|is viagra free for diabetics|venta viagra espa|brand viagra pfizer wholesale|online cheap viagra buy|cheap viagra vipps|wow take viagra|viagra pills price australia|where to buy viagra for women|real viagra internet|viagra discount prices online|viagra patent abgelaufen|none generic viagra sale|i recommend pfizer viagra uk|what is soft viagra tabs|when to take viagra|viagra werbung deutschland|viagra 50 ml|buy viagra in cape town|viagra sin receta andorr|preisvergleich viagra generika|viagra condom buy online|viagra free trial offer|costo de la viagra|viagra most common dosage|herbal viagra compare prices|try it online viagra sale|viagra bon ou mauvais|online pharmacy uk viagra|buy viagra online fast|craigslist viagra for sale|viagra look alike pills|orden genrica viagra|costo di una pillola viagra|viagra mail order usa reviews|viagra now cheaper|viagra bodybuilding forum|viagra on sale|can you purchase viagra online|viagra versand packstation|we like it ordering viagra|viagra for market indian women|compra barata viagra|buy legal viagra in uk|viagra malaysia distributor|buy viagra professional 40|compra viagra india|where to buy viagra at manila|only here cheap 25mg viagra|buying viagra in spain|viagra weak heart|ou peut ton acheter du viagra|generic of viagra wikipedia|no prescripcin viagra de uk|viagra da farmacia del canada|we use it viagra for women|good viagra for men|look there free viagra|mejor viagra generico|generic viagra online no per|venta viagra mendoz|price viagra lloyds pharmacy|need viagra free where get it|viagra sterreich ohne rezept|viagra in drink prank|only here buy viagra online uk|i want to buy viagra online|novo sildenafil vs viagra|buy you in viagra canada can|comparatif cialis viagra|viagra efekti|buy viagra online dublin|criteria viagra prescription|mex select viagra products|viagra super active uk site|teens take viagra|link for you viagra price|buy viagra perth australia|viagra lawsuit canada|viagra canada online|etiqueta viagra barata|pfizer viagra discount program|look there budget viagra|do stores sell viagra|viagra online bestellen serios|viagra in india brands|viagra nicaragua|pfizer viagra sale australia|precio viagra en mexico|i am 18 can i take viagra|viagra today|viagra berber|online viagra germany|healthyman viagra|best quality viagra|viagra preisvergleich onlin|best viagra pills women|viagra i grekland|reviews on viagra sublingual|prix viagra 25 mg|buy online brand viagra au now|viagra femini|canadian law selling viagra|generico do viagra suvvia|boots stores sell viagra|online viagra and cialis|best natural viagra for women|generic viagra indian pharmacy|kamagra cialis viagra|cost of viagra walgreens|weiblich viagra|brand viagra en zaragoza|viagra puissant|herb viagra 6800mg|generic viagra 20mg|viagra brand for sale|vendita online viagra generico|viagra script online|buy viagra online in the us|viagra tablets online india|viagra in canada for sale|can viagra be taken by women|can u buy viagra dubai|viagra le meilleur prix le ru|buy 150mgviagra in canada|viagra tablet prices|viagra 25 mg predaj|generic viagra good original|we use it viagra generico|look here get viagra in canada|viagra sildenafil side effects|viagra drug classification uk|look here online viagra canada|viagra tiempo de efecto|only for you buy viagra uk|viagra pfizer de|low price viagra generica|the best place mexico viagra|viagra used by date|farmacia viagra senza ricett|wow 100 mg generic viagra|viagra ou cialis|viagra price drops|viagra mejor uk precio|buy generic viagra in canada|viagra e antibiotico|viagra generic e bay|can i buy viagra in japan

[url=http://viagrauyr.com/]buy viagra[/url]
viagra cheap

drug online viagra|viagra price in sydney|dangers of viagra for men|viagra men uk|cheap viagra viagra buy deal|viagra generico preco rj|best site get viagra|viagra come acquistare|viagra netist|generic viagrakamagra uk|viagra tauranga|viagra tablets buy online|viagra russian|look here branded viagra|cheap herbal viagra uk|buy viagra low price|cheap viagra tablets for sale|ap kgr 100 viagra|viagra libre nz muestras|viagra levitra calvizi|viagra ratiopharm kaufen|pillole campione di viagra|viagra nitric oxide|how do i buy viagra in canada|precio viagra generico espaa|viagra generico online|good choice viagra buy now|viagra e tumor|tab viagra|buy viagra online paypal vipps|viagra mg india|viagra price in paris|viagraproben amerika|viagra was ist das|india viagra precio|best viagra to buy|pfizer viagra 0 pills sale|viagra safe dosage|viagra online pharmacies|viagra generika oder pfizer|buy safe viagra|viagra fr den mann kaufen|viagra en europe|boots viagra price|medicare part d viagra|viagra argentina|pfizer viagra kaufen|onde comprar viagra barato|viagra trial offer free|very good site women viagra|viagra online il piu economico|acheter viagra canada|viagra at tescoscost|acquisto viagra femminile|selling viagra in spain|viagra et libido|get sample viagra|canada viagra office|viagra rezeptfrei schnell|beginning dosage viagra|viagra orosolubile pfizer|viagra in new york kaufen|only for you order viagra pill|viagra nombre comercial|viagramg|viagra and cialis combined|with viagra cheap dapoxetine|viagra 100mg risks|brand viagra dose|do u need prescription viagra|tilaa viagraa|candy looks like viagra|generico viagra mg|sex on viagra|pfizer viagra canada patent|cost of viagra generic|viagra bieffekter|il viagra per cardiopatic|achat viagra tunisie|we choice uk viagra sales|viagra original bestellen|viagra homme effet|only here buy viagra in us|cialis vs viagra mg|buy viagra in usa online|price comparisons of viagra|viagra zagreb|where to buy viagra hong kong|female natural viagra|legitimate sites buy viagra|viagrande di sicilia|geniune viagra no prescription|viagra kaufen in den usa|generic viagra in stores|buy viagra perth|only today low cost viagra uk|preis fr generisches viagra|kaufen viagra online|brand viagra soft for sale|viagra increase|siege social viagra canada|viagrande villa di bella|viagra prezzi farmaci|is viagra free for diabetics|venta viagra espa|brand viagra pfizer wholesale|online cheap viagra buy|cheap viagra vipps|wow take viagra|viagra pills price australia|where to buy viagra for women|real viagra internet|viagra discount prices online|viagra patent abgelaufen|none generic viagra sale|i recommend pfizer viagra uk|what is soft viagra tabs|when to take viagra|viagra werbung deutschland|viagra 50 ml|buy viagra in cape town|viagra sin receta andorr|preisvergleich viagra generika|viagra condom buy online|viagra free trial offer|costo de la viagra|viagra most common dosage|herbal viagra compare prices|try it online viagra sale|viagra bon ou mauvais|online pharmacy uk viagra|buy viagra online fast|craigslist viagra for sale|viagra look alike pills|orden genrica viagra|costo di una pillola viagra|viagra mail order usa reviews|viagra now cheaper|viagra bodybuilding forum|viagra on sale|can you purchase viagra online|viagra versand packstation|we like it ordering viagra|viagra for market indian women|compra barata viagra|buy legal viagra in uk|viagra malaysia distributor|buy viagra professional 40|compra viagra india|where to buy viagra at manila|only here cheap 25mg viagra|buying viagra in spain|viagra weak heart|ou peut ton acheter du viagra|generic of viagra wikipedia|no prescripcin viagra de uk|viagra da farmacia del canada|we use it viagra for women|good viagra for men|look there free viagra|mejor viagra generico|generic viagra online no per|venta viagra mendoz|price viagra lloyds pharmacy|need viagra free where get it|viagra sterreich ohne rezept|viagra in drink prank|only here buy viagra online uk|i want to buy viagra online|novo sildenafil vs viagra|buy you in viagra canada can|comparatif cialis viagra|viagra efekti|buy viagra online dublin|criteria viagra prescription|mex select viagra products|viagra super active uk site|teens take viagra|link for you viagra price|buy viagra perth australia|viagra lawsuit canada|viagra canada online|etiqueta viagra barata|pfizer viagra discount program|look there budget viagra|do stores sell viagra|viagra online bestellen serios|viagra in india brands|viagra nicaragua|pfizer viagra sale australia|precio viagra en mexico|i am 18 can i take viagra|viagra today|viagra berber|online viagra germany|healthyman viagra|best quality viagra|viagra preisvergleich onlin|best viagra pills women|viagra i grekland|reviews on viagra sublingual|prix viagra 25 mg|buy online brand viagra au now|viagra femini|canadian law selling viagra|generico do viagra suvvia|boots stores sell viagra|online viagra and cialis|best natural viagra for women|generic viagra indian pharmacy|kamagra cialis viagra|cost of viagra walgreens|weiblich viagra|brand viagra en zaragoza|viagra puissant|herb viagra 6800mg|generic viagra 20mg|viagra brand for sale|vendita online viagra generico|viagra script online|buy viagra online in the us|viagra tablets online india|viagra in canada for sale|can viagra be taken by women|can u buy viagra dubai|viagra le meilleur prix le ru|buy 150mgviagra in canada|viagra tablet prices|viagra 25 mg predaj|generic viagra good original|we use it viagra generico|look here get viagra in canada|viagra sildenafil side effects|viagra drug classification uk|look here online viagra canada|viagra tiempo de efecto|only for you buy viagra uk|viagra pfizer de|low price viagra generica|the best place mexico viagra|viagra used by date|farmacia viagra senza ricett|wow 100 mg generic viagra|viagra ou cialis|viagra price drops|viagra mejor uk precio|buy generic viagra in canada|viagra e antibiotico|viagra generic e bay|can i buy viagra in japan

RobertRiz

10 Mei 2018 - 17:27:00

cialis cannabis together

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

cheap cialiscialis vs viagra effectiveness

[url=http://viagralkas.com/]buy generic viagra[/url]

canadian viagrafr verkauf viagra

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

generic viagra online

RobertRiz

10 Mei 2018 - 17:17:03

cialis buy best

[url=http://candiancialisuy.com/]buy cialis online[/url]

buy cialis onlineis it illegal to take viagra

[url=http://viagralkas.com/]generic viagra online[/url]

generic viagra onlineviagra pagamento alla consegn

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

viagra online