Optimize, Repair dan Analize Table MySQL menggunakan phpMyAdmin

Jaka telah dibaca : 24647 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 - 22:56:59

http://www.hsm-fm.de/viewtopic.php?f=7&t=38022 https://oneforum.ro/index.php?topic=7534.new#new http://www.marcolino.net/bb/newreply.php?tid=1 http://www.elementsofnocturne.info/forum/viewtopic.php?f=4&t=13794 http://forumoyun.tk/index.php?topic=63365.new#new http://cr.discjockeyhammer.com/viewtopic.php?f=3&t=217757 https://forum.unimining.net/viewtopic.php?f=3&t=5299 http://www.domvsokolnikah.ru/forum/viewtopic.php?f=1&t=332578 http://wuaizb.com/forum.php?mod=viewthread&tid=278144&extra= http://karurusu.com/onsen/guest/index.php?showforum=11 http://www.senna.ru/forum/viewtopic.php?f=3&t=56645 http://spika-metal.ru/off/viewtopic.php?p=460706#460706 http://adosinformatica.com/index.php/component/kunena/bienvenido-mat/53216-cost-of-toprol-xl-at-walmart-metoprolol-succinate-cost-toprol-xl-50-mg#53621 http://forumoyun.tk/index.php?topic=63364.new#new http://176.31.123.92/forum/viewtopic.php?f=7&t=12406&p=13902#p13902 http://forumoyun.tk/index.php?topic=63417.new#new http://ktvzndg.com/forum.php?mod=viewthread&tid=4601&extra= http://www.garrettwademan.com/crs/forum/index.php?topic=108984.new#new http://karurusu.com/onsen/guest/index.php?showforum=2 http://rsosh7.ru/includes/guest/index.php?showforum=21 http://forumoyun.tk/index.php?topic=63368.new#new http://panobcan.sk/forum/viewtopic.php?f=2&t=1226536 https://onionbit.com/forum/viewtopic.php?f=5&t=751920 http://panobcan.sk/forum/viewtopic.php?f=2&t=1226541 http://176.31.123.92/forum/viewtopic.php?f=7&t=12404 http://www.lampangmarket.com/index.php?topic=44734.new#new http://176.31.123.92/forum/viewtopic.php?f=7&t=12406 http://5.135.255.224/index.php?topic=406547.new#new http://test.street-ball.info/thread-566974.html http://kadrowka.org/forum/viewtopic.php?f=3&t=31904 http://sexualdysfunction.ru/css/guest/index.php?showforum=35 http://forum.vulkanutbrott.se/viewtopic.php?f=3&t=373553 http://attraction.forenworld.com/viewtopic.php?f=1&t=2904 http://forumoyun.tk/index.php?topic=63396.new#new http://www.btggaming.es/foro/viewtopic.php?f=6&t=8787 https://onionbit.com/forum/viewtopic.php?f=10&t=751933 http://foxysale.ru/forum/??????-?????-???????????-?????-???????-?-???????-??????-??-?????????-????????-???????-5?page=78#comment-181169 http://forum.lineage.zone/thread-219708.html http://lika-clipart.ru/6/ http://forum.vulkanutbrott.se/viewtopic.php?f=4&t=373543 http://p-i-k.zp.ua/topic/cost-of-luvox-cr-how-much-does-luvox-cr-cost/#post-99655 http://www.zombiegrinder.com/forum/index.php?topic=143124.new#new http://forum.liebestaktiken.de/viewtopic.php?f=3&t=2128323 http://cushionz.ru/forum/viewtopic.php?pid=940083#p940083 http://forumoyun.tk/index.php?topic=63426.new#new http://www.senna.ru/forum/viewtopic.php?f=4&t=56632 http://esoldiers.nl/phpBB3/viewtopic.php?f=9&t=103224 http://www.900114.com.cn/forum.php?mod=viewthread&tid=3716&extra= http://forumoyun.tk/index.php?topic=63384.new#new http://esoldiers.nl/phpBB3/viewtopic.php?f=3&t=103227

Canadianlooks

19 Februari 2018 - 22:42:32

Does your site have a contact page? I'm having a tough time locating it but, I'd like to shoot you an email. I've got some ideas for your blog you might be interested in hearing. Either way, great blog and I look forward to seeing it improve over time.
[url=http://canadianpharmacymsn.com/]canadian pharmacies shipping to usa[/url]
canadian drugstore
pharmacy canada

ApokoaloSub

19 Februari 2018 - 22:28:09

http://www.rf-joker.com/forum/viewtopic.php?f=10&t=27323 http://watchmta.egaming.hu/forum/index.php/topic,97377.new.html#new http://bbs.hear.99.com/showthread.php?p=4328372#post4328372 http://pyes.gm/nmj/index.php/forum/sub-test-category-2/147769-buy-extendaquin#148327 http://www.selpo58.ru/includes/guest/index.php?showforum=4 http://moes-throwdown.com/forums/viewtopic.php?f=5&t=2555256 http://test.xwab.mobi/viewtopic.php?f=49&t=329852 http://kookforum.be/forum/viewtopic.php?f=35&t=189799 http://www.almongezen.com/showthread.php?p=248696#post248696 http://www.hsm-fm.de/viewtopic.php?f=6&t=38002 http://bulliesinneed.fivepixelmedia.com/forum/viewtopic.php?f=16&t=291351 http://watchmta.egaming.hu/forum/index.php/topic,97381.new.html#new http://www.jrxkz8.com/forum.php?mod=viewthread&tid=2029078&extra= http://support.cetrus.com/viewtopic.php?f=11&t=70386 http://www.masterakter.ru/forum/index.php?/topic/13967-inderal-la-60-buy-buy-cheap-inderal/ http://www.cardiacs.org/forum/viewtopic.php?f=12&t=27238 http://www.forumado.infopro.kz/viewtopic.php?pid=948807#p948807 https://www.miportatil.org/viewtopic.php?f=4&t=822281 http://infiintari-firme-bucuresti-ilfov.ro/forum/viewtopic.php?f=2&t=465333 http://fmga.ca/forums/index.php?topic=3036520.new#new http://didacsoft.com/index.php/blog/with-small-image/item/105-making-this-the-first-true-generator-on-the-internet http://kookforum.be/forum/viewtopic.php?f=25&t=189868 http://chinevaganti.forumup.it/viewtopic.php?p=3986&mforum=chinevaganti#3986 http://youngisraelaventura.com/wp-includes/guest/index.php?showforum=3 http://infiintari-firme-bucuresti-ilfov.ro/forum/viewtopic.php?f=8&t=465324 http://craniokids.ru/forum/index.php?topic=29867.new#new http://echoforums.com/index.php?topic=124245.new#new http://bbs.postalong.com/discuz/upload/thread-5657-1-1.html http://renault-club.com.ua/index.php?showtopic=561353 http://forum.woodworking.ro/viewtopic.php?f=2&t=8840&p=12512#p12512 https://sp-23.ru/forum/viewtopic.php?f=23&t=10785 http://panobcan.sk/forum/viewtopic.php?f=2&t=1226315 https://askacommunist.org/viewtopic.php?f=7&t=1002731 http://socialtour.forumup.it/viewtopic.php?p=56486&mforum=socialtour#56486 https://onionbit.com/forum/viewtopic.php?f=5&t=751565 http://www.renault-russia.ru/index.php?showtopic=178860 http://adosinformatica.com/index.php/component/kunena/bienvenido-mat/53213-buy-prochlorperazine-uk-prochlorperazine-codeine-buy#53618 http://clancanaglie.forumup.it/viewtopic.php?p=81456&mforum=clancanaglie#81456 http://discutons.toile-libre.org/viewtopic.php?f=18&t=136598 http://nolimitsnetwork.forumup.it/viewtopic.php?p=8974&mforum=nolimitsnetwork#8974 http://aov-go.de/viewtopic.php?f=7&t=203984 http://roleplayzone.net/others/eden/index.php?showtopic=16007 http://art-radost.ru/forum/index.php?topic=160497.new#new http://renault-agriculture.co.uk/forums/viewtopic.php?f=2&t=138117 http://wreckedified.com/phpBB3/viewtopic.php?f=7&t=30891 http://mbtibase.com/forum/index.php?topic=398533.new#new http://8dimensional.com/forum/viewtopic.php?f=9&t=41996 http://vault69.site.nfoservers.com/phpbb/viewtopic.php?f=11&t=395757 http://kenshonetwork.com/forum/viewtopic.php?f=12&t=1230376 http://8dimensional.com/forum/viewtopic.php?f=11&t=42055

RobertRiz

19 Februari 2018 - 22:17:17

cialis generico fiable

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

buy cialis onlineviagra 100 mg 30

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

cheap viagrabargain viagra

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

generic viagra

Canadaunren

19 Februari 2018 - 22:13:29

I am actually thankful to the owner of this site who has shared this enormous piece of writing at at this place.
[url=http://canadianpharmacyntx.com/]canadian drugstore[/url]
canadian pharmacies that ship to the us
canadian pharmacy online