WordPress’te arama ve değiştirme yapmak mı istiyorsunuz? Son zamanlarda, kullanıcılarımızdan biri bize herhangi bir SQL kodu yazmadan veya phpMyAdmin kullanmadan WordPress veritabanında arama ve değiştirmeyi nasıl çalıştıracağını sordu. Yeni başlayanların çoğu kod konusunda rahat değil, bu yüzden WordPress için bir arama ve değiştirme eklentisi bulduk. Bu makalede, WordPress’te arama ve değiştirme işleminin nasıl yapılacağını göstereceğiz.
Başlarken
WordPress veritabanınızda herhangi bir değişiklik yapmadan önce eksiksiz bir WordPress yedeği oluşturmanız son derece önemlidir.
Bu en iyi uygulamayı bir alışkanlık haline getirin, WordPress veritabanında doğrudan değişiklikler yaparken işler her an ters gidebilir. Bir yedeğiniz varsa, WordPress sitenizi hiçbir şey kaybetmeden kolayca geri yükleyebilirsiniz.
WordPress için Better Search and Replace’i Yükleme ve Kullanma
Yapmanız gereken ilk şey Better Search Replace eklentisini kurmak ve etkinleştirmek. Etkinleştirmenin ardından eklentiyi kullanmak için Araçlar ” Daha İyi Arama Değiştirme sayfasını ziyaret etmeniz gerekir.
Aramak istediğiniz metin dizesini eklemeniz ve ardından değiştirme metnini eklemeniz yeterlidir.
Bundan sonra bakmak istediğiniz tabloları seçmeniz gerekir. Örneğin, gönderilerinizdeki bazı metinleri aramak ve değiştirmek istiyorsanız, gönderiler tablosunu seçmek isteyebilirsiniz. İsterseniz birden fazla tablo da seçebilirsiniz.
WordPress veritabanı yönetimi ve WordPress’te her bir tablonun ne işe yaradığı hakkında daha fazla bilgi edinin.
Eklenti büyük/küçük harfe duyarlı arama ve değiştirme yapabilir. Ayrıca, metni gerçekten değiştirmeden aramanızdan kaç hücrenin etkilendiğini görmenize olanak tanıyan bir kuru çalışma da gerçekleştirebilir.
Memnun kaldığınızda, arama/değiştirmeyi çalıştır düğmesine tıklayın. Kuru çalıştırma seçeneğini işaretlemediyseniz, eklenti şimdi WordPress veritabanınızda arama ve değiştirme işlemini çalıştıracaktır.
Sorun Giderme
Bir arama ve değiştirme işlemi gerçekleştirirken beyaz ekran görebilir veya zaman aşımına uğrayabilirsiniz. Eklenti sayfasının altındaki ayarlar sekmesine tıklamanız yeterlidir.
Maksimum sayfa boyutu seçeneğini göreceksiniz. Zaman aşımlarını ve beyaz ekranı önlemek için sayfa boyutunu azaltmayı deneyin.
Hepsi bu kadar, umarız bu makale WordPress veritabanı için daha iyi bir arama ve değiştirme eklentisi bulmanıza yardımcı olmuştur. Daha iyi performans için WordPress veritabanınızı nasıl temizleyeceğinize dair eğitimimize de göz atmak isteyebilirsiniz.
Bu makaleyi beğendiyseniz, WordPress video eğitimleri için lütfen YouTube Kanalımıza abone olun. Bizi Twitter ve Facebook‘ta da bulabilirsiniz.
Syed Balkhi says
Hey WPBeginner readers,
Did you know you can win exciting prizes by commenting on WPBeginner?
Every month, our top blog commenters will win HUGE rewards, including premium WordPress plugin licenses and cash prizes.
You can get more details about the contest from here.
Start sharing your thoughts below to stand a chance to win!
Daniel says
Does the plugin work for bbpress topics and replies too?
WPBeginner Support says
The plugin does have the ability to search what was added through other plugins, you would mainly want to make ensure you search the correct tables.
Yönetici
Paul G says
Thanks, this mostly worked for me but didn’t quite change all of the image links.
The rest I could easily change myself by editing the custom modules.
WPBeginner Support says
Glad our guide was helpful
Yönetici
Karol says
Changed a website from http to https via cpanel; green lock did not appear and “connection is not secure” warning was present. This plugin worked great for me. The only difference I did was that I left the checkmark off “Case Insensitive?”.
Every site can be different with it’s own hurdles to jump through but the dry run seemed to look okay without any errors so I ran with it. Green lock appeared right away for the site. Plugin worked for me. I hope it continues to work with other sites.
My only question now is … Do I leave the Better Search Replace plugin installed and activated or do I uninstall it now that I’m done?
WPBeginner Support says
That would be a personal preference question but you should be able to remove the plugin without worry
Yönetici
Mandy says
Hello,
My site is having issues showing images lately, and my host said that it’s because the paths are wrong. They recommended this plug in, but my problem is that I am not sure what I am searching and replacing. Here’s why:
When I insert an image in “visual” mode within a post, it shows up. They all do.
Then when I preview or publish, some images don’t show up. What I am noticing lately is that instead of the code showing them as “image.jpg”, they now have the image size you choose in the path – “image-300×188.jpg” (this happens to be the medium size for this particular image). Why is it putting the pixel dimensions? If none of the images worked, I could say yes, the paths are incorrect, but some images DO work! I am officially bamboozled. It seems so random.
Best,
Mandy
WPBeginner Support says
Hi Mandy,
Please take a look at our guide on how to fix common image issues in WordPress.
Yönetici
Ashraf Ali says
I am switching from http to https now the common problem faced is broken css, I am wondering if could use this plugin to replace https:// to just //
So that all contents are delivered over https
Cheers
Drew says
I had a program enter structured data that is all different. I want to remove everything between and including this : ———————-
How would I do that?
WPBeginner Support says
Hi Drew,
We are not sure we completely understand your issue. However, we are guessing that you had a plugin to add structured data and now you want to remove the structured data from your WordPress posts and pages? If this is the case, then you can simply uninstall the plugin.
Yönetici
Sueli says
Great plugin!
I have a question.
Can I use a wildcard?
I am trying to remove numbers added after an image file. They are different (both the numbers and their length). The stop point would be the (“).
Some examples of what I want to replace with (jpg”)
(jpg?11906004322295206140″)
(jpg?15231215847335105667″)
(jpg?82668654789154738″)
Is it possible with this plugin?
Thanks
David says
I download “Better Search & Replace. Once it found entries, it doesn’t show me unless I buy premium addon.
So instead I ditched that and downloaded “Search & Replace”. It took me only two minutes to replace 100 entries.
Ralpheal says
Wow thanks so much, this is truly a luxury. Going to save me a lot of time, as I was considering changing a phone number on 1oo’s of blog posts.
Thanks so much,
Ralpheal
Mike says
This plugin did not work for me. I backed up the database, then unchecked “Dry Run”. It messed up things all over the site and there was no way to undo the changes.
I even tried to restore the database backup I created with it before making changes and that didn’t work. Don’t use this unless you’re prepared to do an entire site restoration.
WPBeginner Support says
You should have tested with dry run first to see how many rows are affected by the plugin. Glad that you followed the instructions and made a backup first.
Yönetici
vikas kumar says
sir
help me out from pagination error i did which you show in video but i didn’t get result
i am using macbook air in this your given shortcode not work properly
Marko Tiosavljevic says
yes, but this plugin is practically useless when it comes to migrations.
When you migrate website from domain . com to another . com you need to change
you need to connect to database for changing url or you need to insert it in wp_config as url
i am working on external app wp safe mode that is solving this problems in best way.
WPBeginner Support says
It is highly useful in performing search and replace after you have connected to the WordPress database.
Yönetici
Nico says
Hi, it seems that this plugin is no longer available in WordPress Plugin Directory. Which alternative plugin do you recommend?
With kind regars,
Nico.
Syed Umair Umar says
Better Search and Replace is an alternate for me. The editorial staff of WP Beginner seems too lazy and replies to comments very few times.
WPBeginner Support says
Thanks for helping out.
Yönetici
Brian says
Does this take into account serialize data or will it break plugins that use serialized metadata? I know of a few plugins that do this for migration purposes. If it doesn’t it could cause more problems than it solves.