DB Replacer
Version
3.0.7 (last update on May 3, 2013)
Rating
Compatibility
Reviews
32
License
GPLv2 or later
Non-Commercial
Type
Date Added
29 June 2010
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.
Like all NoNumber extensions, DB Replacer is amazing, powerful, and yet so simple to use.
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.
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 just added some YouTube code to a 30 pages of a website, and then got a call from the client who decided he wanted a different video.
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.
...Rowby
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.
...Rowby
Amazing! Simply amazing!
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!
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!
very helpfull. updated 840 articles about one minute after downloading the extension. Wow!
Watch out: You have to change the number of datasets in the settings menu if you want to update more than 100 articles.
I donated 10 Euro for this great tool.
Watch out: You have to change the number of datasets in the settings menu if you want to update more than 100 articles.
I donated 10 Euro for this great tool.
This plug in rocks... and dangerously easy to use.
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!
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!
This is great because it lets you select the file and column / field you want to change. It also gives you a list of the records to be changed showing the original text to be deleted and the replacement text to be inserted in each record, BEFORE you commit the changes to the database. This means you can get a good idea whether or not it will result in the change you intended - very valuable because when doing a scan-and-replace people have a tendency to not think about how it might have unintended consequences. This is still in beta, with some quirks, but I've given it five stars because of it's usefulness, safety features, and very prompt response by the developer.
Owner's reply
Yeah, still in beta, so indeed some bugs to iron out.
Please let me know what you find...
Also usability issues... let me know.
We could not agree more with the previous post! Yes, as usual NoNumber! gives us top-of-the-line extensions to make our lives easier...and this ultra-handy little tool is no exception. Try it...you'll like it!
NoNumber! support and general customer service is probably the best - prompt and *friendly* - that we have encountered online. Be sure to check out the NoNumber! "What? Nothing!" plugin...
NoNumber! support and general customer service is probably the best - prompt and *friendly* - that we have encountered online. Be sure to check out the NoNumber! "What? Nothing!" plugin...
Page 2 of 2
