By Craig-Fifield on

I inherited a drupal site that has articles, books, news, etc...with all kinds of spelling/grammar errors throughout, is there any way I can search and replace across all the data in the DBs?

TIA!

Comments

Ira’s picture

Ira commented

Have you tried exporting the MySql database?
Most everything you should want to replace is the node table.

So you do a global replace on the node table as text and reimport with a drop then insert.

I moved a site and I did this to globally fix links because of directory structure diffs between the two sites. HTH.

Craig-Fifield’s picture

Craig-Fifield commented

but I was looking for something with a web ui for this since it may need to be done repetitively due to the nature of the site by non-technical people.

q0rban’s picture

q0rban commented

I believe TinyMCE has a spell-checking plugin... Click here...Not exactly what you want, but it might help..

cheers

budda’s picture

budda
Primary language English
Location Cheshire
commented

If you're not using a WYSIWYG module, get the Ajax spelling checker module installed - it's great.

--
Custom Drupal templates | More Drupal modules

--
Ixis (UK): Drupal support, Drupal hosting.

Roadskater.net’s picture

Roadskater.net commented

did you find a solution? i will post a new thread on this when i have time to make it specific and clear. thanks, blake

halfer’s picture

halfer commented

Hi all,

I have just solved this issue with a simple PHP solution. Perhaps it might be useful to some of you in your various search-and-replace requirements. Have a look!