Optimize, Repair dan Analize Table MySQL menggunakan phpMyAdmin

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

20 Februari 2018 - 00:22:46

http://strichachtclub.ru/forum/viewtopic.php?f=4&t=13150 http://www.canadiandiscussion.com/index.php/topic,16982.new.html#new http://meteo-evolution-france.com/forum/viewtopic.php?f=4&t=258476 http://forum.liebestaktiken.de/viewtopic.php?f=10&t=2128554 http://forum.liebestaktiken.de/viewtopic.php?f=3&t=2128557 https://myriadstars.biz/TameForum/index.php?topic=213327.new#new http://nauc.info/forums/viewtopic.php?f=4&t=7635760 http://team-mnu.co.za/forum/viewtopic.php?f=21&t=175852 http://www.pronggames.com/forums/viewtopic.php?f=4&t=710355 http://steadfast.saltandlightrpchurch.org/viewtopic.php?f=7&t=156824 http://gokucoin.com/index.php?topic=834858.new#new https://myriadstars.biz/TameForum/index.php?topic=213336.new#new http://team-mnu.co.za/forum/viewtopic.php?f=4&t=175823 http://forum.avengers.ro/viewtopic.php?f=38&t=7238 http://www.kmsat.info/forum/viewtopic.php?f=11&t=182959 http://marcobarberini.forumup.it/viewtopic.php?p=70528&mforum=marcobarberini#70528 http://kenshonetwork.com/forum/viewtopic.php?f=6&t=1230834 http://www.hsm-fm.de/viewtopic.php?f=7&t=38053 http://midmissouri-airsoft.net/forum/viewtopic.php?f=1&t=723680&p=1195378#p1195378 http://northwestcarpforum.co.uk/viewtopic.php?f=38&t=24505 http://kookgek.be/forum/viewtopic.php?f=3&t=134782 http://metacharttools.com/index.php?topic=13519.new#new https://myriadstars.biz/TameForum/index.php?topic=213328.new#new http://ftmboards.com/viewtopic.php?f=9&t=364634 http://ilaxtown.forumup.it/viewtopic.php?p=87280&mforum=ilaxtown#87280 http://www.elementsofnocturne.info/forum/viewtopic.php?f=4&t=13802 http://forums.ugclan.com.au/viewtopic.php?f=11&t=265210 http://www.masterakter.ru/forum/index.php?/topic/14023-buy-amoxicillin-and-clavulanate-clavamox-drops-without-prescription-amoxicillin-and-clavulanate-potassium/ http://eusei.com/forum/viewtopic.php?f=9&t=190488 http://vakitas-ro.com/foro/viewtopic.php?f=12&t=4870 http://esoldiers.nl/phpBB3/viewtopic.php?f=3&t=103452 http://forum.cacaoweb.org/index.php/topic,3329736.new.html#new http://marcobarberini.forumup.it/viewtopic.php?p=70531&mforum=marcobarberini#70531 http://www.bwikorea.com/bulletin/index.php?action=vthread&forum=5&topic=3&page=2504#msg37783 http://www.renault-russia.ru/index.php?showtopic=178965 http://www.thetunnel-art.co.uk/forum/viewtopic.php?f=2&t=2756570 http://www.zumpa.euweb.cz/index.php?option=com_fireboard&Itemid=109&func=view&catid=4&id=9189#9189 http://esoldiers.nl/phpBB3/viewtopic.php?f=9&t=103449 http://touchstone-imagery.com/forum/viewtopic.php?f=46&t=121560&p=144867#p144867 http://northwestcarpforum.co.uk/viewtopic.php?f=5&t=24455 https://onionbit.com/forum/viewtopic.php?f=8&t=752344 http://www.ashonecraft.co.uk/forums/showthread.php?tid=138412 http://www.forumado.infopro.kz/viewtopic.php?pid=949166#p949166 http://www.renault-russia.ru/index.php?showtopic=178964 http://www.masterakter.ru/forum/index.php?/topic/14029-cost-amoxicillin-clavulanate-buying-amoxicillin-and-clavulanate/ http://lbac.neotemplarios.com/mybb/showthread.php?tid=375653 http://touchstone-imagery.com/forum/viewtopic.php?f=43&t=121552 http://www.masterakter.ru/forum/index.php?/topic/14031-amoxicillin-clavulanate-purchase-buying-amoxicillin-and-clavulanate/ http://delca.promoving.be/viewtopic.php?f=67&t=234565 http://www.damyko.info/ForumA/posting.php?mode=newtopic&f=8

Canadianlooks

20 Februari 2018 - 00:06:11

Hello to every body, it's my first pay a quick visit of this blog; this website carries remarkable and really good information for visitors.
[url=http://canadianpharmacymsn.com/]canadian pharmacies[/url]
northwestpharmacy
canadian drugs

ApokoaloSub

19 Februari 2018 - 23:54:16

http://cpp-nnov.nalog.ru/fm/viewtopic.php?f=6&t=39008 https://forum.unimining.net/viewtopic.php?f=9&t=5303 http://176.31.123.92/forum/viewtopic.php?f=7&t=12483&p=13979#p13979 http://176.31.123.92/forum/viewtopic.php?f=3&t=12475 http://forum.lineage.zone/thread-219841.html http://baofengradio.us/forum/viewtopic.php?f=4&t=136248 http://jasamarga.client.virtuco.co.id/discuz/forum.php?mod=viewthread&tid=1215&extra= http://forum.vulkanutbrott.se/viewtopic.php?f=4&t=373647 https://forum.unimining.net/viewtopic.php?f=12&t=5308 http://www.laznenanetu.cekuj.net/login.php?error=1&redirect=/news.php https://askacommunist.org/viewtopic.php?f=7&t=1003831 http://csrpc.net/index.php?option=com_fireboard&Itemid=81&func=view&catid=3&id=32659#32659 http://esoldiers.nl/phpBB3/viewtopic.php?f=9&t=103445 http://forum.shoutout.ie/viewtopic.php?f=3&t=1427651 http://car-gold-2018.co.uk/showthread.php?p=356543#post356543 http://www.radis-shake.fr/phpbb3/viewtopic.php?f=7&t=4628 http://www.lampangmarket.com/index.php?topic=44766.new#new http://foxysale.ru/forum/??????-?????-???????????-?????-???????-?-???????-??????-??-?????????-????????-???????-5?page=78#comment-181173 http://sexualdysfunction.ru/css/guest/index.php?showforum=47 https://www.kakirman.com/smf/index.php?topic=35795.new#new http://www.radis-shake.fr/phpbb3/viewtopic.php?f=10&t=4631 http://wncash.com/forum/viewtopic.php?p=1110285#1110285 http://www.lotoblack.com/forum/threads/apcalis-shop-cheap-generic-buy-apcalis-ajanta-pharma.2313/ http://foxysale.ru/forum/??????-?????-???????????-?????-???????-?-???????-??????-??-?????????-????????-???????-5?page=78#comment-181171 http://foxysale.ru/forum/??????-?????-???????????-?????-???????-?-???????-??????-??-?????????-????????-???????-5?page=78#comment-181172 http://176.31.123.92/forum/viewtopic.php?f=2&t=12473 http://grainedeboheme.fr/index.php/component/kunena/bienvenue/222435-sarafem-wiki-buy-cheap-buy-sarafem#222450 http://radiolafamilia.net/radioforo/viewtopic.php?f=7&t=166034 http://forum.letruc.it/viewtopic.php?f=3&t=28526 http://www.btggaming.es/foro/viewtopic.php?f=10&t=8844 http://asmrpg.com.br/topico/purchase-tofranil-buy-tofranil-online/ http://priority-forums.com/en/forums/topic/buy-nolvadex-genox-tamoxifen-20mg-brand-buy-genox-tamoxifen-2/#post-133946 http://www.tylersmen.com/viewtopic.php?f=2&t=58573 https://forum.unimining.net/viewtopic.php?f=2&t=5305 http://forum.vulkanutbrott.se/viewtopic.php?f=3&t=373645 http://www.garrettwademan.com/crs/forum/index.php?topic=109066.msg120145#msg120145 http://csrpc.net/index.php?option=com_fireboard&Itemid=81&func=view&catid=3&id=32658#32658 http://clansvk.wz.cz/news.php http://p-i-k.zp.ua/topic/metronidazole-and-microgynon-30-cheapest-2/ http://diablo3.forumup.it/viewtopic.php?p=4946&mforum=diablo3#4946 http://www.radis-shake.fr/phpbb3/viewtopic.php?f=25&t=4627 http://gflyashouny.258club.com/viewthread.php?tid=44592&extra= http://plantentellen.nl/forum http://pas.edu.vn/index.php/forum/3-h-p-thu-gop-y/255031-levonorgestrel-where-to-buy-levonorgestrel-cost-cvs#255031 http://p-i-k.zp.ua/topic/metronidazole-and-microgynon-30-cheapest/ http://www.miracmescidi.com/articles.php?article_id=114&c_start=104300 http://jambforum.com/cgi-bin/forum.pl?board=admission http://gsf.freeforums.xxx/viewtopic.php?f=9&t=218646 https://forum.unimining.net/viewtopic.php?f=12&t=5309 http://forumhack.forumup.it/viewtopic.php?p=15064&mforum=forumhack#15064

Canadaunren

19 Februari 2018 - 23:40:39

obviously like your website but you have to test the spelling on several of your posts. Several of them are rife with spelling problems and I find it very troublesome to inform the reality however I will certainly come back again.
[url=http://canadianpharmacyntx.com/]canada drugs[/url]
canadian pharmacies online
approved canadian online pharmacies

ApokoaloSub

19 Februari 2018 - 23:24:55

http://difmuhendislik.com/difforum/index.php?topic=670479.new#new http://craniokids.ru/forum/index.php?topic=30077.new#new http://www.thorga-larp.de/index.php?topic=99613.new#new http://diablo3.forumup.it/viewtopic.php?p=4945&mforum=diablo3#4945 http://www.pronggames.com/forums/viewtopic.php?f=4&t=710186 http://vault69.site.nfoservers.com/phpbb/viewtopic.php?f=15&t=395923 http://milbrujas.com/anuncios/viewtopic.php?f=20&t=404033 http://moes-throwdown.com/forums/viewtopic.php?f=7&t=2556193 http://uzhnport.ru/forum/viewtopic.php?f=13&t=1244912 https://onionbit.com/forum/viewtopic.php?f=10&t=752056 http://infiintari-firme-bucuresti-ilfov.ro/forum/viewtopic.php?f=15&t=465494 http://forum.cacaoweb.org/index.php/topic,3329231.new.html#new http://moes-throwdown.com/forums/viewtopic.php?f=7&t=2556008 http://sacekimisikayet.com/index.php?topic=218083.new#new http://www.cardiacs.org/forum/viewtopic.php?f=6&t=27329 https://kortax.org/smf/index.php/topic,7463.new.html#new http://extrem-bodybuilding.net/EBB/viewtopic.php?f=2&t=207084 http://vault69.site.nfoservers.com/phpbb/viewtopic.php?f=18&t=395969 http://forumoyun.tk/index.php?topic=63444.new#new http://forumoyun.tk/index.php?topic=63375.new#new https://sp-23.ru/forum/viewtopic.php?f=23&t=10814 http://team-mnu.co.za/forum/viewtopic.php?f=21&t=175679 http://moes-throwdown.com/forums/viewtopic.php?f=7&t=2556102 http://sprayfoam.community/viewtopic.php?f=31&t=384800 http://www.orienteering.org.ua/forum/viewtopic.php?f=9&t=37020 http://asmrpg.com.br/topico/benadryl-alzheimers-over-the-counter-sleep-where-to-buy-benadryl-gel/ http://www.cardiacs.org/forum/viewtopic.php?f=10&t=27332 http://cushionz.ru/forum/viewtopic.php?pid=940093#p940093 http://www.forum.pkmkembangjanggut.com/showthread.php?tid=29228&pid=143274#pid143274 http://www.underground.mojkgb.com/index.php?topic=68059.new#new http://xiongmaowanke.com/forum.php?mod=viewthread&tid=640&extra= http://forum.virtuallh.com/index.php?topic=9976.new#new http://craniokids.ru/forum/index.php?topic=30071.new#new http://f.secondgun.ru/showthread.php?tid=7887&pid=38512#pid38512 http://www.underground.mojkgb.com/index.php?topic=68058.new#new https://kortax.org/smf/index.php/topic,7475.new.html#new http://steadfast.saltandlightrpchurch.org/viewtopic.php?f=7&t=156705 http://infiintari-firme-bucuresti-ilfov.ro/forum/viewtopic.php?f=3&t=465435 https://myriadstars.biz/TameForum/index.php?topic=213218.new#new http://www.zombiemasterreborn.com/forum/viewtopic.php?f=8&t=233848 http://www.renault-russia.ru/index.php?showtopic=178895 https://askacommunist.org/viewtopic.php?f=7&t=1003278 https://www.miportatil.org/viewtopic.php?f=5&t=822497 http://sprayfoam.community/viewtopic.php?f=27&t=384767 http://craniokids.ru/forum/index.php?topic=30070.new#new http://steadfast.saltandlightrpchurch.org/viewtopic.php?f=9&t=156749 http://forum.avengers.ro/viewtopic.php?f=17&t=7208 http://extrem-bodybuilding.net/EBB/viewtopic.php?f=7&t=207101 http://8dimensional.com/forum/viewtopic.php?f=13&t=42207 https://kortax.org/smf/index.php/topic,7478.new.html#new