DB Replacer enables you to search and replace in any table in your database.
It even supports searching with case sensitivity.
Sometimes you need to replace something in all your articles. That takes hours doing it the conventional way: open article, change, save article, open next article, etc...
With DB Replacer this takes a few seconds.
DB Replacer gives you a preview of what is going to be replaced, so you know what you are doing before actually replacing anything.
WARNING: DB Replacer replaces stuff right in your database in the places you tell it too. This can - if you replace the wrong stuff - break your site. So be careful and only use this if you know what you are doing.
How to use it: http://www.nonumber.nl/dbreplacer
NoNumber extensions require php 5.3+
See for more requirements: http://www.nonumber.nl/dbreplacer#requirements
For support use the forum: http://www.nonumber.nl/forum
Do NOT use below reviews to post support requests or issues.
Extremely powerful as you can make changes to all your articles in a matter of seconds. In my case I replaced a content plugin and had to modify the syntax in all articles. It was a single operation with DB replacer.
Now one other thing I will also mention in other reviews for NoNumber extensions:
As soon as you have more than one NoNumber extension installed I highly recommend his extension manager!
So, after migrating a site (using sp_upgrade), I then rearrange the images directory to a structure of my liking. Even if it's a simple move up in the folder tree.
db_replacer allows me to quickly change all [src="images/stories/] to [src="images/]
While I am at it, if I decide to rearrange or rename image folders, it is a simple src="images/old_folder/ replaced by src="images/new_folder_name/
If I needed it more frequently, like for changing affiliate links or branding, I would get the pro version in an instant. For my one-time use, it was still worth a donation.
Thanks for saving me hours of tedious work (or having to do the sql query myself)
I had around 30 articles on my site that all had different words in them for plugins and components that I had removed from my site. This presented me with the problem of having to manually edit each page which would have taken hours. Luckily I have other products from this author installed so I had a look to see what this script could do and WOW! it removed all my edits in about 2 seconds.
I cannot praise this component enough, 5 stars well deserved!
Apart from the obvious usefulness of the replacement function itself, i really appreciate the extension usability.
It's EASY. You really cannot fail to understand how it works. And it's QUICK.
Great job Peter.
As the directions warn, this will make global changes to your DB so once committed there is no going back. With that, make a backup first.
With DB Replacer, you can search and replace material in your Joomla database. Since everything in Joomla is in a database, this means you can search and replace anything in your site.
For example, I had to change a block of text that appeared in 200 articles. In the past, I had to open one article at a time, cut and paste the text, fix any formatting, save the changes, then open the next one and start all over again...
With DB Replacer, I did a site-wide change in one operation.
It "holds your hand" through the process. First, select the database table with the material you want to replace. Then enter the "search" material and "replacement" material. As you go along, live preview helps you confirm what you're going to do.
Click submit. DB Replacer asks you to confirm the changes, then it's done.
Beyond article text, search and replace HTML lines, code, IDs, authors... anything in the database.
I can't say enough about the greatness of this and all other NoNumber extensions.
I scrambled to the Joomla Extensions site, hoping to find a true find and replace that would make changes in the mysql database.
And I found this GEM! Works really nice with a preview of what you are replacing.
I easily replaced one YouTube video ID with the new one. In seconds!
Of course you should backup your database first because we all know what surprises can happen when we do a find and replace. I use good old Akeeba Backup to to the backup first and then I ran DB Replacer.
This gem is an example of the great open source extensions that us end users need to thank talented developers, such as NoNumber -- the author of this valuable Joomla component.
My problem: company name changed. Hundreds of articles to sort through to replace coupld of words - hours of work.
Then you find this extension:
- easy to install
- crystal clear in what it does
- easy to use
- plus extra "be careful reminders" before replacing things
Simply excellent, I do not even have anything on my wishlist - just: keep up the great work!
7pm download, 7:05 make coffee, 7:15pm back up database, 7:20 log into Joomla, 7:30 try to figure out what table I want into.
7:35 type in my find, type in my replace, 7:36 stare in awe at the before and after preview, 7:45 still staring, very cool.
7:46 click Replace and okay and okay, and HOLY CRAP 500 articles processed and it's done.
Do this four more times on different variables.
7:55pm verify joomla survived, and it did.
8:00pm slowly sip coffee with feet on the desk and type praise for NoNumber.
Excellent work sir, my hat tips to you.
Once paid for this site, I shall also paypal a tip to you as Your efforts shaved off hours off mind numbing "click highlight delete next" edits.
Thank You for the free plugin, and thank you for one that works as promised!