DB Replacer
Version
3.0.7 (last update on May 3, 2013)
Rating
Compatibility
Reviews
33
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.
Could not be more pleased. This extension is so easy to use. It can replace any content, (even keywords for SEO) with one click. This saved me literally three weeks of time, and my employer could not more happy. For $40 USD (DB Replacer Pro allows for the WHERE clause), it's a NO-BRAINER. Get it, you won't be disappointed, and the support is SPOT ON!
This tool is very useful to power administrators. With it you can easily replace something with something almost system wide. In example, you can fix broken static links on domain change.
That i dont like about it, is that as far this extension evolves, its actually becomes less and less feature complete - features previously available for free in 2.1 ("Where" option and regexp) was removed in later free version, moved to paid version. I appreciate developers hard working but i doubt this is right way.
That i dont like about it, is that as far this extension evolves, its actually becomes less and less feature complete - features previously available for free in 2.1 ("Where" option and regexp) was removed in later free version, moved to paid version. I appreciate developers hard working but i doubt this is right way.
This is a very useful tool if you want to replace similar data which were scattered in many pages of your Joomla website.
initially i downloaded the free version just to check it out. Almost immediately i paid for the PRO version. This is an awesome product and has already saved me HOURS of manual fixing - been able to search and replace Categories on Articles - work done in 2 mins... BRAVO NoNumbers ...
I needed to change the background color and border color of some 500 tables. It would have taken me a week to finish the job. Utterly boring and disgusting work. Using DB Replacer, I finished the job in 2 minutes. Now for the rest of the week, I will just do nothing, and enjoy life.
Thank you for this extremely powerful and time saving tool.
Thank you for this extremely powerful and time saving tool.
Amazing for sure!!
Saves me a looot of job
Some clicks and done.
And when I need help the support was instantly
Well done
Saves me a looot of job
Some clicks and done.
And when I need help the support was instantly
Well done
Very simple: probably this is not the kind of extension you'll be using everyday, but when you need it is extremely useful to have it installed.
I had several posts where I needed to make a change. Using the built-in search and replace functionality I could change several lines of code in more than 70 articles in less than 5 minutes.
What else can I say. It works beautifully, and it's extremely easy to use.
Wonderful extension!
I had several posts where I needed to make a change. Using the built-in search and replace functionality I could change several lines of code in more than 70 articles in less than 5 minutes.
What else can I say. It works beautifully, and it's extremely easy to use.
Wonderful extension!
I have used Joomla for years now and have built a huge number of sites with it and I have to say that this extension is, by far, the most useful and most powerful Joomla extension that exists.
Great tool! You have to know what you are doing, as you are directly modifying the database. The extension will show you exactly what it is going to do, so if you have your wits together nothing should go wrong.
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!
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!
Finally, with Joomla 1.7 we do not have to deal with the silly /images/stories/ folder for all of our images. It was so annoying that everything has 'stories' for an image URL.
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)
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)
Definitely for power-users only, this tool is invaluable if you know SQL and aren't afraid to get your hands dirty in the code "behind the scenes" of Joomla. The ability to directly update/modify multiple records in the database tables is an incredible time saver. It's free, but, like all of Peter's excellent extensions, well worth paying for; it pays for itself fairly quickly in hours of saved labor.
It's rare that I come across a component for Joomla that does everything you want from it and does it extremely well. There are good extensions, but most appear to have the odd fall down or annoyance. This extension however has none, it's perfect!!
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!
Thanks
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!
Thanks
Like all the other extensions from NoNumber, this is a great time saver.
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.
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.
I had a client make a mess of their content pasting directly from Word. UGH - I was able to find the few offending bits of syntax/css, paste it into the ajax form and click away my problems. AWESOME.
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.
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.
Page 1 of 2
