By emsbrooklyn on

Need to do a find and replace of text through the entire site. Is there a module that can do this or do I need to go into MySQL? phpmyadmin looks promising, but all I could find was a tutorial on changing one table at a time. Need to search and replace entire database.

Newbie to databases, so the simpler the better. Exported a Filemaker database and imported it into Drupal with Node Import module. Had a bunch of problems with special characters, so I did a find and replace in Filemaker (very easy) to removed the offending text. Now I need to replace the text...

Thanks!

⋅ Categories: Drupal 5.x

Comments

superjacent’s picture

superjacent commented

If you don't mind using a desktop application you could try this http://prime357.org/node/76. This page explains the Search and Replace feature of the Wordpress to Drupal converter. You don't need to import Wordpress in order to use this component.

___________________________

Steven Taylor
http://prime357.org

superjacent’s picture

superjacent commented

I've just gone through the process of moving my personal blogging site from http://superjacent.net/cms (non clean url's) to the root of the domain and enabled clean url's.

Long story short, quite a few posts had internal links like so, '...../cms/?q=node/.....' I was able to use the Search and Replace feature to replace /cms/?q=node/ with /node/. I was also able to replace image references ./files/ with /files/ (removing the dot slash with a slash).

Further info here http://prime357.org/node/88
___________________________

Steven Taylor
http://prime357.org

jaesperanza’s picture

jaesperanza commented

For Drupal: ^9 | ^10 - https://www.drupal.org/project/scanner

I am updating this thread as this comes up easily on search and should be useful.