Optimize, Repair dan Analize Table MySQL menggunakan phpMyAdmin

Jaka telah dibaca : 24646 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 :

ApokoaloSub

19 Februari 2018 - 21:59:17

http://forum.polydust.com/viewtopic.php?f=5&t=297157 http://forum.lakshmi-food.ru/viewtopic.php?f=3&t=7261 https://forum.ebhn.be/index.php?topic=4443.new#new http://forum.diana-art.pl/feed.php http://forum.msfo-training.ru/viewtopic.php?f=5&t=4338&p=53143#p53143 http://www.noznos.com/cetirizine-hydrochloride-where-to-buy-cetir-387622-1-1.html http://forum.msfo-training.ru/viewtopic.php?f=5&t=4338&p=53172#p53172 https://askacommunist.org/viewtopic.php?f=4&t=1002703 http://forum.jerkoffallday.net/viewtopic.php?f=8&t=17160 http://spika-metal.ru/off/viewtopic.php?p=460313#460313 http://www.3rbvpn.com/viewtopic.php?f=9&t=9892 http://esoldiers.nl/phpBB3/viewtopic.php?f=3&t=103022 http://176.31.123.92/forum/viewtopic.php?f=7&t=12325 http://fantapetro.forumup.it/viewtopic.php?p=12193&mforum=fantapetro#12193 http://powernet.com.ua/phpBB3/viewtopic.php?f=1&t=224747&sid=aa6cd8265187b92e94e127a1319ac6be http://roleplayzone.net/others/eden/index.php?showtopic=16009 http://esoldiers.nl/phpBB3/viewtopic.php?f=9&t=103026 http://echoforums.com/index.php?topic=124247.new#new https://myriadstars.biz/TameForum/index.php?topic=213140.new#new http://uro.lv/f/index.php?/topic/462388-buy-phenergan-with-codeine-syrup-phenergan-over-the-counter-uk/ http://grauxc.free.fr/phpBB2/viewtopic.php?p=229211#229211 http://plantentellen.nl/forum http://kpzinfo.cz/forum/index.php?topic=41057.new#new http://amursignal.ru/phpBB3/viewtopic.php?f=4&t=29926 http://opensourcerecycling.org/forum/viewtopic.php?f=6&t=143851 http://www.forum.adstoro.com/index.php?topic=442357.new#new http://rees-davies.com/viewtopic.php?f=6&t=345813 http://www.millennium2.net/forum01/showthread.php?tid=422910 http://filesell.1reportaj.ir/forum/viewtopic.php?pid=293231#p293231 https://forum.unimining.net/viewtopic.php?f=11&t=5293 https://nairamoni.com/index.php/topic,156125.new.html#new https://www.excelon.biz/spowl/index.php?topic=21827.new#new https://kortax.org/smf/index.php/topic,7439.new.html#new http://csrpc.net/index.php?option=com_fireboard&Itemid=81&func=view&catid=3&id=32650#32650 http://qipai.cbt9.com/bbs/thread-4291-1-1.html https://askacommunist.org/viewtopic.php?f=4&t=1002720 http://kpzinfo.cz/forum/index.php?topic=41049.new#new http://mh370forum.com/index.php?topic=28019.new#new http://powernet.com.ua/phpBB3/viewtopic.php?f=1&t=224754&sid=887612a7a1b16e42477fa7405bde0888 http://ruangblogger.com/index.php?topic=135503.new#new http://www.thorga-larp.de/index.php?topic=99547.new#new http://steadfast.saltandlightrpchurch.org/viewtopic.php?f=10&t=156601 https://www.miportatil.org/viewtopic.php?f=4&t=822253 http://ftmboards.com/viewtopic.php?f=9&t=364041 http://wreckedified.com/phpBB3/viewtopic.php?f=10&t=30883 http://www.pronggames.com/forums/viewtopic.php?f=4&t=709981 http://panobcan.sk/forum/viewtopic.php?f=2&t=1226301 http://xiifleet.org/forums/viewtopic.php?f=9&t=26249 http://www.lavoisin.de/viewtopic.php?f=8&t=356597 http://5.135.255.224/index.php?topic=406327.new#new

ApokoaloSub

19 Februari 2018 - 21:24:36

http://servercs16.xyz/viewtopic.php?pid=4627#p4627 http://www.btggaming.es/foro/viewtopic.php?f=10&t=8708 http://wreckedified.com/phpBB3/viewtopic.php?f=7&t=30828 http://thepacepodcast.com/forums/index.php?topic=11175.new#new https://www.expertstakers.com/viewtopic.php?f=3&t=40352 http://forum.mycancerprotocol.com/showthread.php?tid=146760&pid=315294#pid315294 http://forobb.netii.net/showthread.php?tid=20510&pid=58982#pid58982 http://c21-life.com/sale/form.php https://xn--80aqfgkangfhg.xn--p1ai/ http://neutnet.rk2.at/viewtopic.php?f=5&t=8924 http://wwwforum.buyang.cz/viewtopic.php?f=5&t=37017 http://asmrpg.com.br/topico/flixotide-ventolin-buy/ http://roleplayzone.net/others/eden/index.php?showtopic=16004 http://www.noznos.com/prograf-annual-cost-cost-for-prograf-387536-1-1.html http://jambforum.com/cgi-bin/forum.pl?board=admission http://www.webmasterdunyasi.club/forum/index.php?topic=10110.new#new http://www.senna.ru/forum/viewtopic.php?f=4&t=56332 http://www.sscjqbbs.com/thread-2524-1-1.html http://www.psbgcommunity.com/showthread.php?tid=31792&pid=183042#pid183042 http://forum.polydust.com/viewtopic.php?f=4&t=297074 http://jambforum.com/cgi-bin/forum.pl?board=admission http://www.chuangfulm.cn/forum.php?mod=viewthread&tid=2253&pid=31215&page=747&extra=#pid31215 https://askacommunist.org/viewtopic.php?f=8&t=1002408 http://squadra-famiglia.com/mybb/showthread.php?tid=54405 http://www.psbgcommunity.com/showthread.php?tid=28915&pid=183044#pid183044 https://stateoflawrp.com/showthread.php?tid=56627&pid=197689#pid197689 http://forum.bsunaa.org/index.php?topic=13703.new#new http://www.millennium2.net/forum01/showthread.php?tid=409360&pid=586186#pid586186 https://myriadstars.biz/TameForum/index.php?topic=213085.new#new http://gelik.ru/includes/guest/index.php?showforum=11 http://ember.bonfirecommunity.org/viewtopic.php?f=9&t=353104&p=785132#p785132 http://forum.ogameautomizer.com/index.php/topic,343375.new.html#new http://priority-forums.com/en/forums/topic/cost-for-diovan-buy-diovan-hct-angiotensin-receptor-blocker/ http://adosinformatica.com/index.php/component/kunena/bienvenido-mat/53209-nifedipine-cost-walmart-can-you-buy-nifedipine-over-the-counter#53614 http://www.hsm-fm.de/viewtopic.php?f=7&t=37982 http://art-radost.ru/forum/index.php?topic=160463.new#new http://forum.vulkanutbrott.se/viewtopic.php?f=4&t=373414 https://devaforum.ro/index.php?topic=259150.new#new http://176.31.123.92/forum/viewtopic.php?f=2&t=12278 http://bbs.postalong.com/discuz/upload/thread-5638-1-1.html http://gtmp-forum.cc/showthread.php?tid=201071&pid=224061#pid224061 http://laksanaberita.com/threads/cost-of-glucotrol-xl-glucotrol-xl-cost.64433/ http://forum.msfo-training.ru/viewtopic.php?f=5&t=4338&p=53018#p53018 http://playercenter.de/showthread.php?tid=110546&pid=250271#pid250271 http://nashi-turizm.ru/forum/testrazdel/is-cheap-ibuprofen-the-same-as-nurofen-buy-nurofen-migraine-pain-x12 http://www.garrettwademan.com/crs/forum/index.php?topic=108886.new#new http://hatun.ru/forum/viewtopic.php?pid=711193#p711193 http://cabv.ca/phpBB3/viewtopic.php?f=8&t=370453 http://taik-ken.ru/includes/guest/index.php?showforum=1 http://radiolafamilia.net/radioforo/viewtopic.php?f=6&t=165927

Canadianlooks

19 Februari 2018 - 21:19:42

This paragraph offers clear idea in support of the new users of blogging, that actually how to do blogging.
[url=http://canadianpharmacymsn.com/]canadian pharmacy uk delivery[/url]
no 1 canadian pharcharmy online
canadian cialis

RobertRiz

19 Februari 2018 - 21:15:14

cialis usa supplier

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

buy cialis onlinesingapore viagra shop

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

generic viagra onlinebritish viagra

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

online viagra

RobertRiz

19 Februari 2018 - 20:50:14

we like it generic cialis pill

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

generic cialis onlineis there viagra generic

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

buy viagra onlinefree viagra sample

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

buy generic viagra