Global search and replace
Permalink 1 user found helpful
Is there a function or add-on for a global search and replace?
I need to make a global change to several terms and one hyperlink that appear frequently in my 200+ page site.
I need to make a global change to several terms and one hyperlink that appear frequently in my 200+ page site.
Stacks work well for entire blocks, but I don't see how this could have helped for scattered terms or links. For example, I need to change all occurrences of "hiking trail" to "footpath" and one of the sites we link to frequently has changed their domain name.
Which table in the database would you look for page content?
Maybe an idea for an add-on...
Thanks for the response.
Which table in the database would you look for page content?
Maybe an idea for an add-on...
Thanks for the response.
I see 2 ways doing this:
1. the dirty way. Dump a copy of the database to a file on your computer and search and replace that file. After that upload the file as a new database for your site.
2. Use "Search" inside PhpMyAdmin. If it's inside content blocks you probably would find it in the table "btContentLocal".
But still I can't give any guaranties so - BACKUP YOUR DATABASE!
/Michael
1. the dirty way. Dump a copy of the database to a file on your computer and search and replace that file. After that upload the file as a new database for your site.
2. Use "Search" inside PhpMyAdmin. If it's inside content blocks you probably would find it in the table "btContentLocal".
But still I can't give any guaranties so - BACKUP YOUR DATABASE!
/Michael
I realise this is an old thread, but just in case someone stumbles across it, I have a new add-on that does a great job of finding & replacing content across the entire website - all blocks and all page attributes. Here's a link:https://www.concrete5.org/marketplace/addons/find-and-replace/...
Normally when having same content on a lot of pages it's a good idea to have this in a stack. Then you would be able to change all these instances in the stacks in the dashboard.
In your situation (as I expect that you do not use stacks), I only see one possible solution. Simply seek and replace directly in the database. BUT BE CAREFUL, IT COULD BREAK YOUR SITE. Remember to have a backup of the database!
/Michael