Optimize, Repair dan Analize Table MySQL menggunakan phpMyAdmin

Jaka telah dibaca : 24645 kali

Sering kali bita menemukan kasus database MySQL kita error, ada beberapa table yang tidak bisa diakses, penyebabnya biasanya komputer mati atau koneksi terputus saat database sedang melakukan proses CRUD, jangan cemas dulu, mudah -mudahan tuturial berikut bisa menyelesaikan kasus anda.

Berikut cara Optimize, Repair dan Analize Table MySQL menggunakan phpMyAdmin :

*warning : harap hati - hati dan teliti dalam melakukan proses ini, karena bila ada kesalahan dalam proses repair ini dapat menyebabkan rusaknya database, terhapus table dan isi record pada table, saya tidak bertanggung jawab bila terjadi rusaknya database, terhapus table dan isi record pada table, "Do With Your Own Risk"

- Pastikan Komputer sudah terinstall phpMyAdmin, bisa phpMyAdmin bawaan Xampp, Wampp, Appserv, dll (contoh ini saya menggunakan xampp, mungkin tampilan dan tulisan label perintah pada aplikasi bisa sedikit berbeda).

- Buka browser (Chrome, Mozilla, dll).

- ketik URL http://localhost/phpmyadmin.

- akan tampil sebagai berikut :

repair_1

 

- Click database yang ingin di repair pada kolom sebelah kiri, dalam contoh ini saya akan merepair "db_client"

- Click Tab Structure, lalu click check All pada bagian bawah daftar table ata pilih tabel apa saja yang diingin untuk di repair

repair_2

- pada option "With selected", pilih "Check table"

repair_3

 

- berikut tampilannya hasilnya

repair_4

 

- click check All pada bagian bawah daftar table ata pilih tabel apa saja yang diingin untuk di repair, lalu pada option "With selected", pilih "Optimize table"

 repair_5

 

 - berikut tampilannya hasilnya

 

- click check All pada bagian bawah daftar table ata pilih tabel apa saja yang diingin untuk di repair, lalu pada option "With selected", pilih "Repair table"

 

- berikut tampilannya hasilnya

 

- click check All pada bagian bawah daftar table ata pilih tabel apa saja yang diingin untuk di repair, lalu pada option "With selected", pilih "Analyze table"

 

 

- berikut tampilannya hasilnya

 

OK, sudah selesai tutorial Optimize, Repair dan Analize Table MySQL menggunakan phpMyAdmin, silahkan dicoba kembali akses table yang error, bila langkah - langkah di atas sudah benar Insyaa Allah database sudah bisa digunakan kembali.

 

Terimakasih.


Cara Install Framework CodeIgniter

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

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


Tinggalkan Komentar
9210 Komentar :

uWeiche

16 Desember 2017 - 23:13:48

[url=http://viagrabstnrx.com/]cheap viagra online[/url]
adderall and viagra
http://viagrabstnrx.com
how many viagra can you take in a week
buy generic viagra

yoxicle

16 Desember 2017 - 22:47:26

[url=http://buyviagramdrxonline.com/]online viagra[/url]
viagra 25mg cost
http://buyviagramdrxonline.com
viagra jokes cartoons
viagra online

yhallfalp

16 Desember 2017 - 22:39:34

[url=http://buyviagramdrxonline.com/]generic viagra online[/url]
cialis and viagra together
http://buyviagramdrxonline.com
do you need prescription for viagra
generic viagra online

GlintsovaRiz

16 Desember 2017 - 22:01:34

try it cialis dosecialis como salen inglaterrawhat is generic cialis 10mgcialis vegetalbuy one day cialiscialis and trimix togetherwe choice cialis usnow cialis payment paypalcialis 5 mg salefor sale cialis tabletscanadian cialisbilliges cialis bestellenaustralia cialis buycialis 5mg preise osterreichcout du cialisil cialis generico e sicuro?buy cheapest daily cialiswow womans cialiscialis online forucialis nuchtern einnehmencialis kanada bestellen onlineosu cialis generico forum,enter site cialis tabsbuy cialis in sohofarmacia uk cialisprezzo cialis da 5 mgachat cialis 2 5 mgcialis 20 mlacheter cialis suisscialis online express200 cialiswe like it cialis low pricegeneric cialis potencycialis causes me headachecounterfeit cialis ukordering cialis onlinecialis hearing lossblog how to order cialiscialis indiegenerika cialis levitracialis miglior prezzo italiaprescription cialis canadacialis 5 mg generikacialis historicialis per duratacialis discounts and couponscialis or genericcialis free printable coupongeneric cheap cialis online5mg cialis onlinekaufen cialis nachnahmepurchase cialis no rxwow buy cialis australiawe like it generic cialis usacialis ou autresforo cialis genericosventa de cialis en iquiquecialis online generic eumail order cialis from canadahow to buy cialiscialis canada buy onlinecialis kaufen in hamburgsite once daily cialis costtry it buy 5 mg cialisgenerico para 20 mg cialiscialis online italicialis with paypalexpress cialis deliverypurchase cialis prescriptioncialis levitra paypalcialis tabs 20mgvendo cialis toscanacialis dove acquistarecialis cheap overseascialis venta 2010cialis generico en mexico dfcialis 20mg tadalafil preisecialis prices comparisonlook there lowest price cialischeapest cialis for saleusefull link brand name cialiscialis 5 mg 28 stvendo cialis generico chilebipolar specialist low pricecialis for men costou acheter du cialis au canadacialis daily us pricecialis extenze togethercialis pillola costocialis e ipertensione lievdonde compro cialis 10try it cialis mail ordercialis deutschland kaufpaypal cialis descuentocanada cialis generic onlinecialis okay fur frauengeneric cialis melbournecialis commercialbuy low cost cialis soft tabcialis online offercialis 20 mg 4 tablcialis senza ricetta svizzercialis costs,try it non pescription cialiscialis en ligne du canadacialis 5mg tablettencialis pastilla oralil cialis fa dimagrirepurchase cialis canada onlinecheap cialis softonly here cialis mail ordercialis 50mg buyachat de cialis non generiquewe like it cialis to ordercialis hace efectlook there get cialis cheapcialis generic lowest pricecialis on line basso costocialis 4cpr riv 20mgcialis chennaiwe recommend soft tab cialisprix medicament cialis marocnew cialis daily dosecialis pill ukonly now cialis 2.5 mgprice cialis daily use 5mgcialis comlrar con mastercardcan you two take 10mg cialisquanto costa cialis originalemedicament cialis generiquecialis campione libero ukcialis generico 5 mg prezzgeneric cialis online 10mgbuy cialis online soft tabsbest price on cialis 20mg online order cialiswow approval cialis fdawant to purchase cialisdosaggio cialisachetez cialis profesionalcialis comprar en farmaciablack buy generic cialiscialis daily in what mgscialis frankreich rezeptfreicialis angebotcialis laboratoire lillytarif cialis andorrecheapest cialis availablecialis expirycialis drug prescriptioncompra de los cialisenter site cialis soft tabscialis liquid formcialis generika online kaufencompri cialis in farmacielevitra 2cialiscost cialiscialis daily use pricecompare prices on cialiscialis trial samples canadafree cialis sample pack in usageneric cialis salescialis-pille-kaufvendita farmaci online cialislevitra cialis professionnelbrand cialis from uksoft cialis now cheapcialis generico funziona?buy cialis fast deliverycialis effettfollow link best cialiscialis da europalaboratoire lilly cialiscialis que es yahoosuper cialis ukbuy cialis in sebokengcialis 33 annicialis uk the cheapestcialis try before buywhats best to take cialisonline cialis kaufencanada pharmacy cialis onlineonly now best quality cialiscialis price 4 tabletsback cialis guarantee moneysito cialis genericogeneric cialis united stateslook there buy generic cialison line cost of cialiscialis generico torinocialis prise en chargeamerican cialiscialis pas cher a pariscialis kaufen frankreiccialis 40 mg online australiaonly best offers mexico cialisgenerico de cialis en perucialis pillen deutschlandaffairs cialis veteransarticles on generic cialisclick here soft tab cialisonly today cialis 10 mgonly now canadain cialiscomprar cialis medicamentocialis bestellen in frankreichpills price india cialisorder safe generic cialiscialis acheter en belgiqueis cialis by prescription onlycialis edemacialis daily costuser reviews of cialishow much cialis costtadalafil cialis best usagecheap cialis from ukis cialis generic legal in uscialis pfizer achatacquisto cialis originalcialis gelenkschmerzenthe best site cialis australiacorporate finance specialistcialis impotenza o levitrventa cialis soft cubanowow buy cialis mexicowhere can i get cialisfollow link online us cialisbest price online daily cialiscialis kaufen shopbuy cialis 5mg tabletscialis switzerlandwhere to buy cheap cialiscialis overnight delivery usacialis quanto custacheap cialis online 5b mgthe best choice cialis on lineforo cialis onlinecialis for cheapwill cialis available genericcialis 5 mg au canadacialis 2 comprimescialis 7.5 mgcialis and pregnancyingredient in cialisbuy over counter cialiscialis 20 posologiadverse effects cialisdonde compra cialis en madridwe choice cialis online indiaonly here buy cialis in canadacost of 20mg cialis

[url=http://cialispqh.com/]cialis online[/url]

cheap cialis

try it cialis dosecialis como salen inglaterrawhat is generic cialis 10mgcialis vegetalbuy one day cialiscialis and trimix togetherwe choice cialis usnow cialis payment paypalcialis 5 mg salefor sale cialis tabletscanadian cialisbilliges cialis bestellenaustralia cialis buycialis 5mg preise osterreichcout du cialisil cialis generico e sicuro?buy cheapest daily cialiswow womans cialiscialis online forucialis nuchtern einnehmencialis kanada bestellen onlineosu cialis generico forum,enter site cialis tabsbuy cialis in sohofarmacia uk cialisprezzo cialis da 5 mgachat cialis 2 5 mgcialis 20 mlacheter cialis suisscialis online express200 cialiswe like it cialis low pricegeneric cialis potencycialis causes me headachecounterfeit cialis ukordering cialis onlinecialis hearing lossblog how to order cialiscialis indiegenerika cialis levitracialis miglior prezzo italiaprescription cialis canadacialis 5 mg generikacialis historicialis per duratacialis discounts and couponscialis or genericcialis free printable coupongeneric cheap cialis online5mg cialis onlinekaufen cialis nachnahmepurchase cialis no rxwow buy cialis australiawe like it generic cialis usacialis ou autresforo cialis genericosventa de cialis en iquiquecialis online generic eumail order cialis from canadahow to buy cialiscialis canada buy onlinecialis kaufen in hamburgsite once daily cialis costtry it buy 5 mg cialisgenerico para 20 mg cialiscialis online italicialis with paypalexpress cialis deliverypurchase cialis prescriptioncialis levitra paypalcialis tabs 20mgvendo cialis toscanacialis dove acquistarecialis cheap overseascialis venta 2010cialis generico en mexico dfcialis 20mg tadalafil preisecialis prices comparisonlook there lowest price cialischeapest cialis for saleusefull link brand name cialiscialis 5 mg 28 stvendo cialis generico chilebipolar specialist low pricecialis for men costou acheter du cialis au canadacialis daily us pricecialis extenze togethercialis pillola costocialis e ipertensione lievdonde compro cialis 10try it cialis mail ordercialis deutschland kaufpaypal cialis descuentocanada cialis generic onlinecialis okay fur frauengeneric cialis melbournecialis commercialbuy low cost cialis soft tabcialis online offercialis 20 mg 4 tablcialis senza ricetta svizzercialis costs,try it non pescription cialiscialis en ligne du canadacialis 5mg tablettencialis pastilla oralil cialis fa dimagrirepurchase cialis canada onlinecheap cialis softonly here cialis mail ordercialis 50mg buyachat de cialis non generiquewe like it cialis to ordercialis hace efectlook there get cialis cheapcialis generic lowest pricecialis on line basso costocialis 4cpr riv 20mgcialis chennaiwe recommend soft tab cialisprix medicament cialis marocnew cialis daily dosecialis pill ukonly now cialis 2.5 mgprice cialis daily use 5mgcialis comlrar con mastercardcan you two take 10mg cialisquanto costa cialis originalemedicament cialis generiquecialis campione libero ukcialis generico 5 mg prezzgeneric cialis online 10mgbuy cialis online soft tabsbest price on cialis 20mg online order cialiswow approval cialis fdawant to purchase cialisdosaggio cialisachetez cialis profesionalcialis comprar en farmaciablack buy generic cialiscialis daily in what mgscialis frankreich rezeptfreicialis angebotcialis laboratoire lillytarif cialis andorrecheapest cialis availablecialis expirycialis drug prescriptioncompra de los cialisenter site cialis soft tabscialis liquid formcialis generika online kaufencompri cialis in farmacielevitra 2cialiscost cialiscialis daily use pricecompare prices on cialiscialis trial samples canadafree cialis sample pack in usageneric cialis salescialis-pille-kaufvendita farmaci online cialislevitra cialis professionnelbrand cialis from uksoft cialis now cheapcialis generico funziona?buy cialis fast deliverycialis effettfollow link best cialiscialis da europalaboratoire lilly cialiscialis que es yahoosuper cialis ukbuy cialis in sebokengcialis 33 annicialis uk the cheapestcialis try before buywhats best to take cialisonline cialis kaufencanada pharmacy cialis onlineonly now best quality cialiscialis price 4 tabletsback cialis guarantee moneysito cialis genericogeneric cialis united stateslook there buy generic cialison line cost of cialiscialis generico torinocialis prise en chargeamerican cialiscialis pas cher a pariscialis kaufen frankreiccialis 40 mg online australiaonly best offers mexico cialisgenerico de cialis en perucialis pillen deutschlandaffairs cialis veteransarticles on generic cialisclick here soft tab cialisonly today cialis 10 mgonly now canadain cialiscomprar cialis medicamentocialis bestellen in frankreichpills price india cialisorder safe generic cialiscialis acheter en belgiqueis cialis by prescription onlycialis edemacialis daily costuser reviews of cialishow much cialis costtadalafil cialis best usagecheap cialis from ukis cialis generic legal in uscialis pfizer achatacquisto cialis originalcialis gelenkschmerzenthe best site cialis australiacorporate finance specialistcialis impotenza o levitrventa cialis soft cubanowow buy cialis mexicowhere can i get cialisfollow link online us cialisbest price online daily cialiscialis kaufen shopbuy cialis 5mg tabletscialis switzerlandwhere to buy cheap cialiscialis overnight delivery usacialis quanto custacheap cialis online 5b mgthe best choice cialis on lineforo cialis onlinecialis for cheapwill cialis available genericcialis 5 mg au canadacialis 2 comprimescialis 7.5 mgcialis and pregnancyingredient in cialisbuy over counter cialiscialis 20 posologiadverse effects cialisdonde compra cialis en madridwe choice cialis online indiaonly here buy cialis in canadacost of 20mg cialis

KilinRiz

16 Desember 2017 - 21:11:43

viagra 150 mg prices

[url=http://www.obuv-rostov.ru/forum/user/210625/] pay day loans[/url]

payday express

[url=http://www.gxday.com/bbs/home.php?mod=space&uid=98046] payday loans online[/url]

payday loans

[url=http://www.ifengdong.com/bbs/home.php?mod=space&uid=390294] cash advance[/url]

pay day loans

[url=http://www.anderweg.eu/profile.php?lookup=1143127] payday loans online[/url]

loans for bad credit

[url=http://www.zgtcdj.com/home.php?mod=space&uid=4034] payday express[/url]

cash advance