{"id":5711,"date":"2018-01-22T07:37:05","date_gmt":"2018-01-22T07:37:05","guid":{"rendered":"https:\/\/blog.hostinger.io\/co-id-tutorial\/?p=5711"},"modified":"2025-12-18T23:35:49","modified_gmt":"2025-12-18T16:35:49","slug":"cara-search-and-replace-database-wordpress","status":"publish","type":"post","link":"\/id\/tutorial\/cara-search-and-replace-database-wordpress\/","title":{"rendered":"Cara menggunakan search and replace di database WordPress"},"content":{"rendered":"<p>Memperbarui informasi di database WordPress bisa sangat melelahkan kalau harus dilakukan satu per satu secara manual. Untungnya, ada cara yang lebih praktis untuk tugas ini, yaitu dengan melakukan search and replace.<\/p><p>Kali ini, kami akan menjelaskan cara search and replace di database WordPress menggunakan plugin atau langsung lewat query MySQL. Tapi sebelumnya, mari pahami dulu tugas apa saja yang bisa Anda lakukan dengan fitur ini.<\/p><h2 class=\"wp-block-heading\" id=\"h-apa-kegunaan-search-and-replace-di-database-wordpress\">Apa kegunaan search and replace di database WordPress?<\/h2><p><a href=\"\/id\/tutorial\/apa-itu-database\/\">Database<\/a> adalah pusat penyimpanan semua data website WordPress Anda, mulai dari konten, pengaturan, hingga informasi pengguna. Namun, ada kalanya Anda perlu melakukan perubahan besar dalam datanya.<\/p><p>Beberapa alasan Anda perlu melakukan perubahan pada database WordPress mencakup:<\/p><ul class=\"wp-block-list\">\n<li><strong>Mengganti kata kunci<\/strong> &ndash; <a href=\"\/id\/tutorial\/cara-seo-wordpress\/\">strategi SEO WordPress<\/a> selalu berubah. Kata kunci yang dulu efektif mungkin sudah tidak relevan lagi sehingga perlu diganti di seluruh konten Anda.<\/li>\n\n\n\n<li><strong>Memperbaiki salah eja atau typo<\/strong> &ndash; kesalahan kecil bisa terjadi pada banyak entri data, dan mencarinya satu per satu tentu sangat tidak efisien.<\/li>\n\n\n\n<li><strong>Menghapus karakter atau simbol tertentu<\/strong> &ndash; terkadang, update WordPress atau plugin tertentu bisa menyebabkan munculnya karakter acak dalam database, yang akhirnya bisa mengacaukan database Anda.<\/li>\n<\/ul><p>Apa pun alasannya, proses mengupdate database biasanya mengharuskan Anda mengedit banyak tabel data. Tentu saja hal ini akan sangat merepotkan dan rawan error.<\/p><p>Untungnya, Anda bisa melakukan search and replace untuk menemukan data yang salah di seluruh tabel database, lalu menggantinya dalam waktu singkat.<\/p><p>\n\n\n<div class=\"announcement-block announcement-block--important\">\n            <span class=\"announcement-block__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path fill-rule=\"evenodd\" clip-rule=\"evenodd\"\n                          d=\"M12 22.5C17.799 22.5 22.5 17.799 22.5 12C22.5 6.20101 17.799 1.5 12 1.5C6.20101 1.5 1.5 6.20101 1.5 12C1.5 17.799 6.20101 22.5 12 22.5ZM13.637 7.65198C13.637 6.74791 12.9041 6.01501 12 6.01501C11.0959 6.01501 10.363 6.74791 10.363 7.65198C10.5335 9.53749 10.875 13.383 10.875 13.383C10.875 14.0043 11.3787 14.508 12 14.508C12.6213 14.508 13.125 14.0043 13.125 13.383V13.38L13.637 7.65198ZM11.9927 15.714C11.3714 15.714 10.8677 16.2177 10.8677 16.839C10.8677 17.4603 11.3714 17.964 11.9927 17.964H12.0073C12.6286 17.964 13.1323 17.4603 13.1323 16.839C13.1323 16.2177 12.6286 15.714 12.0073 15.714H11.9927Z\"\n                          fill=\"#FEA419\"\/>\n                <\/svg>\n                Important\n            <\/span>\n            <p class=\"announcement-block__content\">\n                <strong>Penting!<\/strong> Perubahan pada database tidak bisa dibatalkan. Sebelum melakukan search and replace, selalu <a href=\"\/id\/tutorial\/cara-backup-wordpress\/\">backup website WordPress<\/a> Anda terlebih dahulu agar terhindar dari risiko kehilangan data.\n            <\/p><\/div>\n\n\n\n<\/p><h2 class=\"wp-block-heading\" id=\"h-cara-melakukan-search-and-replace-di-database-wordpress\">Cara melakukan search and replace di database WordPress<\/h2><p>Ada dua cara utama untuk melakukan search and replace, yaitu <strong>menggunakan plugin<\/strong> (paling mudah, cocok untuk pemula) dan <strong>menggunakan query MySQL<\/strong> (lebih teknis, cocok untuk pengguna berpengalaman).<\/p><p>Kami akan membahas keduanya agar Anda bisa memilih metode yang paling sesuai.<\/p><h3 class=\"wp-block-heading\" id=\"h-menggunakan-plugin\">Menggunakan plugin<\/h3><p>Metode ini ideal kalau Anda tidak terbiasa dengan <a href=\"\/id\/tutorial\/apa-itu-coding\/\">coding<\/a>. Cukup dengan menginstal plugin, Anda bisa menjalankan operasi search and replace sebanyak yang diperlukan tanpa menulis satu baris kode pun.<\/p><p>Dalam tutorial ini, kita akan menggunakan <a href=\"https:\/\/wordpress.org\/plugins\/better-search-replace\/\" target=\"_blank\" rel=\"noopener\">Better Search Replace<\/a>, salah satu plugin WordPress paling populer untuk tugas ini.<\/p><p>Plugin ini menyediakan banyak fitur untuk manajemen database, termasuk backup dan impor database. Versi gratisnya sudah cukup kalau hanya untuk search and replace, tapi kalau membutuhkan fitur lain, Anda bisa upgrade ke versi <a href=\"https:\/\/bettersearchreplace.com\/\" target=\"_blank\" rel=\"noopener\">Pro<\/a> dengan harga mulai dari $59\/tahun (sekitar Rp970.000).<\/p><p>Berikut cara menggunakan plugin ini untuk melakukan search and replace di database WordPress:<\/p><ol class=\"wp-block-list\">\n<li>Masuk ke dashboard admin WordPress Anda, lalu buka <strong>Plugins<\/strong> (Plugin) &rarr;&nbsp; <strong>Add New<\/strong> (Tambahkan Plugin).<\/li>\n\n\n\n<li>Cari plugin<strong> Better Search Replace<\/strong>, lalu pilih <strong>Install Now<\/strong> (Instal Sekarang).<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a602157c8d98\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a602157c8d98\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"473\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/instal-plugin-better-search-replace-wp.png\/public\" alt=\"Plugin Better Search Replace di halaman WordPress dengan tombol instal yang dipilih\" class=\"wp-image-45446\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/instal-plugin-better-search-replace-wp.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/instal-plugin-better-search-replace-wp.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/instal-plugin-better-search-replace-wp.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/instal-plugin-better-search-replace-wp.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><ol start=\"3\" class=\"wp-block-list\">\n<li>Klik tombol <strong>Activate<\/strong> (Aktifkan) untuk mengaktifkan plugin.<\/li>\n\n\n\n<li>Kembali ke dashboard, buka bagian <strong>Tool<\/strong> (Peralatan) &rarr; <strong>Better Search Replace<\/strong>.<\/li>\n<\/ol><p>Pada bagian<strong> Search\/Replace<\/strong>, masukkan semua entri berikut ini:<\/p><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a602157c9836\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a602157c9836\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"835\" height=\"777\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/halaman-plugin-better-search-replace.png\/public\" alt=\"Mengisi informasi tentang apa yang akan dicari di plugin Better Search Replace\" class=\"wp-image-45447\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/halaman-plugin-better-search-replace.png\/w=835,fit=scale-down 835w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/halaman-plugin-better-search-replace.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/halaman-plugin-better-search-replace.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/halaman-plugin-better-search-replace.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 835px) 100vw, 835px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><p>Berikut penjelasannya:<\/p><ul class=\"wp-block-list\">\n<li><strong>Search for<\/strong> &ndash; masukkan kata atau frasa yang ingin dicari.<\/li>\n\n\n\n<li><strong>Replace with<\/strong> &ndash; masukkan kata atau frasa pengganti.<\/li>\n\n\n\n<li><strong>Select tables<\/strong> &ndash; pilih tabel yang ingin diubah.<\/li>\n\n\n\n<li><strong>Replace GUIDs?<\/strong> &ndash; sebaiknya tidak dicentang kalau website Anda sudah online untuk menghindari masalah identifikasi data.<\/li>\n\n\n\n<li><strong>Run as dry run?<\/strong> &ndash; centang opsi ini kalau Anda ingin meninjau hasilnya dulu sebelum benar-benar mengubah database.<\/li>\n<\/ul><p>\n\n\n        <div class=\"protip\">\n            <div class=\"protip__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path d=\"M1.49234 23.5024C1.23229 23.5024 0.972242 23.4024 0.782206 23.2123C0.562165 22.9923 0.452144 22.6822 0.502153 22.3722C0.562165 21.9221 1.14227 17.9113 3.00262 16.351C3.63274 15.8209 4.43289 15.5509 5.26305 15.5609C6.09321 15.5909 6.87335 15.9109 7.47347 16.4911C8.6937 17.6913 8.76371 19.6717 7.6435 20.9919C6.0832 22.8523 2.08245 23.4324 1.63237 23.4924C1.59236 23.4924 1.54235 23.4924 1.50234 23.4924L1.49234 23.5024ZM5.16303 17.5613C4.84297 17.5613 4.53291 17.6713 4.29287 17.8813C3.60274 18.4614 3.07264 19.9317 2.75258 21.242C4.06282 20.9219 5.5331 20.3918 6.11321 19.7017C6.55329 19.1716 6.54329 18.3814 6.0832 17.9213C5.85316 17.7013 5.5431 17.5713 5.20304 17.5613C5.19304 17.5613 5.17303 17.5613 5.16303 17.5613ZM11.7243 21.8821C11.4942 21.8821 11.2642 21.8021 11.0841 21.652C10.8541 21.462 10.7241 21.1819 10.7241 20.8819V15.9109L8.08358 13.2705H3.11264C2.81259 13.2705 2.53254 13.1404 2.3425 12.9104C2.15246 12.6803 2.07245 12.3803 2.12246 12.0902C2.19247 11.7102 2.84259 8.36953 4.70294 7.12929C6.33325 6.04909 8.96375 6.49918 10.244 6.80923C11.5442 4.96889 13.2546 3.4286 15.2349 2.33839C17.4553 1.11816 19.9858 0.518051 22.4963 0.498047C23.0464 0.498047 23.4865 0.948132 23.4865 1.49824C23.4865 5.0389 22.3763 9.97983 17.1753 13.7605C17.4853 15.0408 17.9354 17.6613 16.8552 19.2816C15.615 21.1419 12.2744 21.7921 11.8943 21.8621C11.8343 21.8721 11.7743 21.8821 11.7143 21.8821H11.7243ZM12.7245 16.181V19.6016C13.7146 19.2916 14.7948 18.7915 15.2049 18.1814C15.675 17.4812 15.605 16.091 15.385 14.9008C14.5248 15.3808 13.6346 15.8109 12.7245 16.181ZM9.66388 12.0302L11.9643 14.3307C13.1845 13.8306 14.3648 13.2204 15.485 12.5103C19.9358 9.51974 21.2361 5.60901 21.4561 2.53843C19.6157 2.67846 17.8254 3.20856 16.2051 4.09872C14.2847 5.14892 12.6544 6.68921 11.4942 8.54956C10.7841 9.65977 10.174 10.82 9.66388 12.0302ZM4.39289 11.2701H7.81353C8.1936 10.3599 8.63368 9.46974 9.11377 8.60957C7.92355 8.38953 6.51329 8.31952 5.81315 8.78961C5.19304 9.19968 4.70294 10.3099 4.39289 11.2701Z\" fill=\"#673DE6\"\/>\n                <\/svg>\n                <p class=\"protip__title\">\n                    Tips berguna                <\/p>\n            <\/div>\n            <p class=\"protip__content\">Tekan <strong>CTRL+A<\/strong> untuk memilih semua tabel sekaligus. Gunakan <strong>CTRL+klik<\/strong> untuk memilih tabel satu per satu. Centang opsi <strong>Case-Insensitive?<\/strong> agar pencarian tidak membedakan huruf besar dan kecil.<\/p>\n                    <\/div>\n        \n\n\n\n<\/p><p>Setelah selesai, pilih <strong>Run Search\/Replace<\/strong>.<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"1024\" height=\"847\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/hasil-plugin-better-search-replace.png\/public\" alt=\"Pesan konfirmasi plugin Better Search Replace setelah berhasil menjalankan search and replace di database WordPress\" class=\"wp-image-45448\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/hasil-plugin-better-search-replace.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/hasil-plugin-better-search-replace.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/hasil-plugin-better-search-replace.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/hasil-plugin-better-search-replace.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div><p>Kalau Anda tidak mencentang opsi dry run, plugin ini akan langsung menerapkan perubahan ke database.<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"\/id\/wordpress-hosting\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" width=\"1024\" height=\"300\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/06\/ID-New-WP_in-text-banner.png\/public\" alt=\"\" class=\"wp-image-37614\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/06\/ID-New-WP_in-text-banner.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/06\/ID-New-WP_in-text-banner.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/06\/ID-New-WP_in-text-banner.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/06\/ID-New-WP_in-text-banner.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/div><h3 class=\"wp-block-heading\" id=\"h-menggunakan-kueri-mysql\">Menggunakan kueri MySQL<\/h3><p>Anda juga bisa melakukan search and replace di database WordPress menggunakan query MySQL melalui phpMyAdmin.<\/p><p>Untuk melakukan langkah ini, Anda perlu mengetahui nama database WordPress Anda dulu, apalagi kalau memiliki lebih dari satu database.<\/p><p>Apabila menggunakan Hostinger, Anda bisa langsung mengakses phpMyAdmin dari <strong>hPanel<\/strong>. Berikut caranya:<\/p><ol class=\"wp-block-list\">\n<li>Dari dashboard website Anda di hPanel, buka bagian <strong>Database<\/strong> &rarr;&nbsp; <strong>Manajemen<\/strong>.<\/li>\n\n\n\n<li>Di bagian <strong>Daftar Database dan User MySQL Saat Ini<\/strong>, pilih <strong>Buka phpMyAdmin<\/strong> di samping nama website Anda.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a602157cb639\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a602157cb639\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"369\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/buka-phpmyadmin-mysql-hpanel.png\/w=1024,h=1024,fit=scale-down\" alt=\"Tampilan menu database hPanel dengan opsi Buka phpMyAdmin yang dipilih\" class=\"wp-image-45449\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/buka-phpmyadmin-mysql-hpanel.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/buka-phpmyadmin-mysql-hpanel.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/buka-phpmyadmin-mysql-hpanel.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2018\/01\/buka-phpmyadmin-mysql-hpanel.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><ol start=\"3\" class=\"wp-block-list\">\n<li>Buka tab <strong>SQL<\/strong> pada menu bagian atas phpMyAdmin.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a602157cbe90\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a602157cbe90\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"313\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/10\/phpmyadmin-mengakses-sql.png\/public\" alt=\"Tampilan phpMyAdmin dengan tab SQL yang dipilih\" class=\"wp-image-40880\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/10\/phpmyadmin-mengakses-sql.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/10\/phpmyadmin-mengakses-sql.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/10\/phpmyadmin-mengakses-sql.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/37\/2024\/10\/phpmyadmin-mengakses-sql.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" aria-label=\"Enlarge\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.imageButtonRight\" data-wp-style--top=\"state.imageButtonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><ol start=\"4\" class=\"wp-block-list\">\n<li>Tambahkan kode berikut ini di kolom yang tersedia:<\/li>\n<\/ol><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">UPDATE TABLE_NAME \nSET FIELD_NAME = REPLACE(FIELD_NAME, 'Teks_yang_dicari', 'Teks_pengganti');<\/pre><p>Pastikan untuk mengganti teks berikut ini dengan informasi Anda sebenarnya:<\/p><ul class=\"wp-block-list\">\n<li><strong>TABLE_NAME<\/strong> &ndash; nama tabel yang ingin Anda edit.<\/li>\n\n\n\n<li><strong>FIELD_NAME<\/strong> &ndash;<strong> <\/strong>nama bidang yang mencakup data yang ditargetkan.<\/li>\n\n\n\n<li><strong>&lsquo;Teks_yang_dicari&rsquo;<\/strong> &ndash; kata atau frasa yang ingin Anda ubah.<\/li>\n\n\n\n<li><strong>&lsquo;Teks_pengganti&rsquo;<\/strong> &ndash; kata atau frasa yang akan menggantikan teks sebelumnya.<\/li>\n<\/ul><p>Setelah Anda selesai menulis kueri, klik tombol <strong>Go<\/strong> untuk menjalankannya.<\/p><p>Apabila tidak menggunakan hPanel, Anda bisa menemukan nama database dengan cara berikut:<\/p><ol class=\"wp-block-list\">\n<li>Buka <strong>File Manager<\/strong> di control panel hosting Anda.<\/li>\n\n\n\n<li>Buka root directory website Anda, biasanya adalah folder <strong>\/public_html<\/strong>.<\/li>\n\n\n\n<li>Temukan file<strong> wp-config.php <\/strong>dan klik dua kali file tersebut untuk membukanya.<\/li>\n\n\n\n<li>Cari baris dengan teks seperti berikut:<\/li>\n<\/ol><pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/** The name of the database for WordPress *\/\ndefine( 'DB_NAME', 'your_database_name' );<\/pre><ol start=\"5\" class=\"wp-block-list\">\n<li>Catat nama database Anda dari bagian <strong>your_database_name<\/strong>.<\/li>\n<\/ol><p>Setelah itu, Anda bisa <a href=\"\/id\/tutorial\/cara-masuk-ke-phpmyadmin\/\">menggunakan phpMyAdmin untuk mengelola database<\/a> WordPress Anda. Lakukan langkah yang sama seperti cara sebelumnya, yaitu mengakses MySQL dan menambahkan kode yang dibutuhkan.<\/p><h2 class=\"wp-block-heading\" id=\"h-kesimpulan\">Kesimpulan<\/h2><p>Agar website WordPress Anda tetap fungsional dan up-to-date, Anda perlu melakukan maintenance database secara rutin. Dalam hal ini, Anda mungkin perlu mengganti data yang sudah tidak relevan; tapi prosesnya bisa cukup merepotkan kalau harus dilakukan secara manual. <\/p><p>Untungnya, Anda bisa melakukan search and replace di database WordPress untuk mengganti data secara massal. Ada dua metode yang bisa Anda terapkan:<\/p><ul class=\"wp-block-list\">\n<li><strong>Menggunakan plugin Better Search Replace <\/strong>&ndash; cocok untuk pengguna yang tidak memiliki pengalaman pemrograman.<\/li>\n\n\n\n<li><strong>Menggunakan kueri MySQL<\/strong> &ndash; cocok untuk pengguna dengan pengetahuan teknis tingkat lanjut.<\/li>\n<\/ul><p>Metode mana yang lebih Anda sukai? Beri tahu kami di bagian komentar di bawah ini yuk!<\/p><p>\n\n\n        <div class=\"protip\">\n            <div class=\"protip__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path d=\"M1.49234 23.5024C1.23229 23.5024 0.972242 23.4024 0.782206 23.2123C0.562165 22.9923 0.452144 22.6822 0.502153 22.3722C0.562165 21.9221 1.14227 17.9113 3.00262 16.351C3.63274 15.8209 4.43289 15.5509 5.26305 15.5609C6.09321 15.5909 6.87335 15.9109 7.47347 16.4911C8.6937 17.6913 8.76371 19.6717 7.6435 20.9919C6.0832 22.8523 2.08245 23.4324 1.63237 23.4924C1.59236 23.4924 1.54235 23.4924 1.50234 23.4924L1.49234 23.5024ZM5.16303 17.5613C4.84297 17.5613 4.53291 17.6713 4.29287 17.8813C3.60274 18.4614 3.07264 19.9317 2.75258 21.242C4.06282 20.9219 5.5331 20.3918 6.11321 19.7017C6.55329 19.1716 6.54329 18.3814 6.0832 17.9213C5.85316 17.7013 5.5431 17.5713 5.20304 17.5613C5.19304 17.5613 5.17303 17.5613 5.16303 17.5613ZM11.7243 21.8821C11.4942 21.8821 11.2642 21.8021 11.0841 21.652C10.8541 21.462 10.7241 21.1819 10.7241 20.8819V15.9109L8.08358 13.2705H3.11264C2.81259 13.2705 2.53254 13.1404 2.3425 12.9104C2.15246 12.6803 2.07245 12.3803 2.12246 12.0902C2.19247 11.7102 2.84259 8.36953 4.70294 7.12929C6.33325 6.04909 8.96375 6.49918 10.244 6.80923C11.5442 4.96889 13.2546 3.4286 15.2349 2.33839C17.4553 1.11816 19.9858 0.518051 22.4963 0.498047C23.0464 0.498047 23.4865 0.948132 23.4865 1.49824C23.4865 5.0389 22.3763 9.97983 17.1753 13.7605C17.4853 15.0408 17.9354 17.6613 16.8552 19.2816C15.615 21.1419 12.2744 21.7921 11.8943 21.8621C11.8343 21.8721 11.7743 21.8821 11.7143 21.8821H11.7243ZM12.7245 16.181V19.6016C13.7146 19.2916 14.7948 18.7915 15.2049 18.1814C15.675 17.4812 15.605 16.091 15.385 14.9008C14.5248 15.3808 13.6346 15.8109 12.7245 16.181ZM9.66388 12.0302L11.9643 14.3307C13.1845 13.8306 14.3648 13.2204 15.485 12.5103C19.9358 9.51974 21.2361 5.60901 21.4561 2.53843C19.6157 2.67846 17.8254 3.20856 16.2051 4.09872C14.2847 5.14892 12.6544 6.68921 11.4942 8.54956C10.7841 9.65977 10.174 10.82 9.66388 12.0302ZM4.39289 11.2701H7.81353C8.1936 10.3599 8.63368 9.46974 9.11377 8.60957C7.92355 8.38953 6.51329 8.31952 5.81315 8.78961C5.19304 9.19968 4.70294 10.3099 4.39289 11.2701Z\" fill=\"#673DE6\"\/>\n                <\/svg>\n                <p class=\"protip__title\">\n                    Pelajari tutorial teknis WordPress lainnya                <\/p>\n            <\/div>\n            <p class=\"protip__content\"><a href=\"\/id\/tutorial\/cara-mempercepat-wordpress\/\">Cara mempercepat WordPress<\/a><br>\n<a href=\"\/id\/tutorial\/wp_query-wordpress\/\">Cara menggunakan WordPress WP_Query<\/a><br>\n<a href=\"\/id\/tutorial\/cara-install-wordpress-di-xampp\/\">Cara menggunakan XAMPP untuk menginstal WordPress secara lokal<\/a><br>\n<a href=\"\/id\/tutorial\/custom-css-wordpress\/\">Cara menambahkan CSS kustom ke WordPress<\/a><br>\n<a href=\"\/id\/tutorial\/cara-membuat-multisite-wordpress\/\">Cara membuat multisite WordPress<\/a><\/p>\n                    <\/div>\n        \n\n\n\n<\/p><h2 class=\"wp-block-heading\" id=\"h-tanya-jawab-faq-cara-search-and-replace-database-wordpress\">Tanya jawab (FAQ) cara search and replace database WordPress<\/h2><p>Berikut beberapa pertanyaan umum tentang cara search and replace database WordPress.<\/p><div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-69442d65a1bd7\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Bagaimana cara mencari dan mengganti konten di WordPress?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Untuk mencari dan mengganti konten di WordPress, Anda bisa menggunakan plugin <strong>Search &amp; Replace<\/strong>. Dengan plugin ini, Anda bisa mencari dan mengganti teks atau kode tertentu dalam database WordPress dengan mudah. Anda juga bisa menggunakan editor teks atau fungsi search and replace bawaan editor kode WordPress.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-69442d65a1bdb\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \">Seberapa sering harus mencari dan mengganti data yang tidak update di WordPress?<\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Sebaiknya lakukan sesering mungkin sesuai kebutuhan Anda, seperti saat mengupdate desain website, mengganti nama domain, atau memindahkan website ke server baru. Selain itu, Anda bisa meninjau database website secara berkala untuk menghapus data yang tidak diperlukan.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Memperbarui informasi di database WordPress bisa sangat melelahkan kalau harus dilakukan satu per satu secara manual. Untungnya, ada cara yang lebih praktis untuk tugas ini, yaitu dengan melakukan search and replace. Kali ini, kami akan menjelaskan cara search and replace di database WordPress menggunakan plugin atau langsung lewat query MySQL. Tapi sebelumnya, mari pahami dulu [&#8230;]<\/p>\n<p><a class=\"btn btn-secondary understrap-read-more-link\" href=\"\/id\/tutorial\/cara-search-and-replace-database-wordpress\/\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":190,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_title":"Cara search and replace di database WordPress","rank_math_description":"Perlu mengupdate database WordPress secara massal? Yuk, pelajari cara melakukan search and replace di database WordPress di artikel ini!","rank_math_focus_keyword":"search and replace database wordpress","footnotes":""},"categories":[4859],"tags":[7763,7766,7765,7764,4860,7767],"class_list":["post-5711","post","type-post","status-publish","format-standard","hentry","category-wordpress","tag-better-search-repplace","tag-cara-mencari-dan-mengganti-tulisan-di-wordpress","tag-find-and-replace","tag-search-and-replace","tag-wordpress","tag-wordpress-database"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":1},{"locale":"pt-BR","link":"https:\/\/www.hostinger.com\/br\/tutoriais\/como-localizar-e-substituir-texto-em-um-banco-de-dados-wordpress\/","default":0},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/tutoriales\/como-buscar-y-reemplazar-en-base-de-datos-wordpress\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/tutorial\/cara-search-and-replace-database-wordpress\/","default":0},{"locale":"en-PH","link":"https:\/\/www.hostinger.com\/ph\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"en-MY","link":"https:\/\/www.hostinger.com\/my\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"en-GB","link":"https:\/\/www.hostinger.com\/uk\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"en-IN","link":"https:\/\/www.hostinger.com\/in\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"en-CA","link":"https:\/\/www.hostinger.com\/ca\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"en-AU","link":"https:\/\/www.hostinger.com\/au\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"en-NG","link":"https:\/\/www.hostinger.com\/ng\/tutorials\/how-to-run-wordpress-database-search-and-replace\/","default":0},{"locale":"es-AR","link":"https:\/\/www.hostinger.com\/ar\/tutoriales\/como-buscar-y-reemplazar-en-base-de-datos-wordpress\/","default":0},{"locale":"es-MX","link":"https:\/\/www.hostinger.com\/mx\/tutoriales\/como-buscar-y-reemplazar-en-base-de-datos-wordpress\/","default":0},{"locale":"es-CO","link":"https:\/\/www.hostinger.com\/co\/tutoriales\/como-buscar-y-reemplazar-en-base-de-datos-wordpress\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/pt\/tutoriais\/como-localizar-e-substituir-texto-em-um-banco-de-dados-wordpress\/","default":0}],"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/posts\/5711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/users\/190"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/comments?post=5711"}],"version-history":[{"count":6,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/posts\/5711\/revisions"}],"predecessor-version":[{"id":47255,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/posts\/5711\/revisions\/47255"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/media?parent=5711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/categories?post=5711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/tutorial\/wp-json\/wp\/v2\/tags?post=5711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}