Global search and replace

Permalink
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.

waterfeller
View Replies:
maar replied on at Permalink Reply
maar
Hi,

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
waterfeller replied on at Permalink Reply
waterfeller
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.
maar replied on at Permalink Reply
maar
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