Introduction

Replace

DB Replacer - search and replace in your Joomla! database.


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: https://www.regularlabs.com/dbreplacer

I have been using DB Replacer to correct and update data in several different fields of the database after migrating a big old 1.5 church site to 3.15.



As I backed up the database each time before using it, I felt very confident and after a good amount of use it has been successful.



I had an issue that it only works with the default Isis Admin template (not the Hathor one) and Peter the developer could not have been more helpful with this and another issue. Mind you, by the time I got his personal support I had purchased the Pro version, which was what I planned to do anyway (as it is even better) and for such a serious task as editing inside the database it was well worth the money.



Not only have I saved lots of time but I have also increased the new website quality by a good margin.



Well done Peter and thanks.

DB Replacer



Posted on 29 August 2013
Saved me countless hours amending articles. I did a novice mistake, copy and paste from a word document. It put " " in every gap on every article 50+. Causing over-spill in my modules. DB Replacer just replaced them all with a space. Can't thank you enough.
Really a top notch tool for Joomla developers!

I needed to fix the image tags in about 160 articles on a new site.

This component is very very cool.

It allowed me to specify the string for which to search, and as I typed it in and specified the target table, it highlighted the changes that it was going to make so that I could pre-approve the changes.

The free version only does 50 records at a time, but it works very well, so I just did it three times.

THANKS for this EXCELLENT Component!

Highly Recommended!

BTW - MAKE A BACKUP FIRST, you never know when yo might need it.

Ok Time is saved again



Posted on 27 June 2013
What can I say?

To handle with care. You better know what you are doing and keep track.

But seriously, So much use cases.

You won't need it everyday.

But you will sleep peacefully knowing you have this one ready.

Was of great help for an upgrade from 1.5 to 2.5, after having used an extension to import most of the site, used DBReplacer to adapt components and do minor corrections and stuff.

I guess you can drive your joomla site from there...
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!

Useful tool



Posted on 19 March 2013
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.

very useful tool



Posted on 14 February 2013
This is a very useful tool if you want to replace similar data which were scattered in many pages of your Joomla website.
I contacted Peter (developer) after updating Tabber to the new Tabs. The syntax had changed. He immediately pointed me to this awesome tool. Peter is definitely one of the top Joomla! developers out there - no question!
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 ...

Made my week



Posted on 23 November 2012
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.
Advanced Module Manager
Free

Advanced Module Manager

By Regular Labs
Modules Management
Advanced Module Manager - control your modules the way it should be. Advanced Module Manager is an extension that changes the way your Module manager works. It adds a multitude of functions, like:     ★ Many publishing conditions for your modules!         You can control publishing modules by (ALL / ANY):             ☆ Menu Item             ☆ Homepage             ...
Modules Anywhere
Free

Modules Anywhere

By Regular Labs
Coding & Scripts Integration
Modules Anywhere - place modules anywhere you can enter text. With Modules Anywhere you can include a single module or complete module positions anywhere in your site, including within articles, inside other modules, or even 3rd party components and template overrides. You can place modules literally anywhere you want, wherever you have the ability to enter text. Modules Anywhere is a lot more f...
Sourcerer
Free

Sourcerer

By Regular Labs
Coding & Scripts Integration
Sourcerer - place any code anywhere. Sourcerer enables you to place PHP and any kind of HTML style code (including CSS and JavaScript) right in to your content! Not only in your articles, but also in sections, categories, modules, components, META tags, etc. You can now just place your original codes right into your WYSIWYG editor. The only thing you have to do is surround the code with the Sour...
Modals
Free

Modals

By Regular Labs
Popups & iFrames
Modals - make links open in modal popups. Modals is a powerful plugin that allows you to easily create cool modal popups on your site. Modal popup windows are fancy popups also known as Lightboxes. You can make modals / lightboxes for whatever you want: text, articles, other internal pages, external pages, images, videos, and even full-blown Modal Image Galleries & Slideshows with thumbnail cre...
ReReplacer
Free

ReReplacer

By Regular Labs
Replace
ReReplacer - search and replace in your websites output. ReReplacer is a Joomla! component and system plugin that enables you to replace anything in your Joomla! site’s output with whatever you want. ReReplacer will search the text (html) of your pages for your search request and replace it with what you have told it to do. These replacements are on the fly. That means they are not permanent....
Articles Anywhere
Free

Articles Anywhere

By Regular Labs
News Display
Articles Anywhere - place articles anywhere you can enter text. Articles Anywhere is a powerful plugin that allows you to insert articles anywhere on your site, including within modules, 3rd party components, and even inside other articles. Not only you can place complete articles, but also only place specific data (like Title, Readmore Link, Text, Images, Custom Fields, etc). You have full cont...
Cache Cleaner
Free

Cache Cleaner

By Regular Labs
Performance
Cache Cleaner - clean cache fast with 1 click. Cache Cleaner is a Joomla! Administrator system plugin (and module), that allows you to clean your Joomla! cache fast and easily via a link in the Administrator panel - and much more. With Cache Cleaner, you can clean the Joomla cache from any page of the backend, and with just one click. And it doesn't even need to reload the page either, because i...
Content Templater
Free

Content Templater

By Regular Labs
Coding & Scripts Integration
Content Templater - make predefined content. With Content Templater you can create predefined reusable content templates for your Joomla articles, and much more. No more need to copy and paste pieces of text you want to use more than once, or to manually copy article settings. Just make a content template of it! You can very easily insert these content templates into your Joomla article (or oth...
Regular Labs Extension Manager
Free

Regular Labs Extension Manager

By Regular Labs
Installers
With the Regular Labs Extension Manager you can quickly and easily install and update Regular Labs extensions. You can:     ★ See what Regular Labs extensions you have installed     ★ See version numbers and see if yours is up-to-date     ★ Install extensions     ★ Update extensions     ★ See the changelogs     ★ Uninstall Regular Labs extensions The Regular Labs Extensio...
CDN for Joomla!
Free

CDN for Joomla!

By Regular Labs
Performance
CDN for Joomla! - speed up your Joomla! site by using a Content Delivery Network. CDN for Joomla! is an extension for Joomla! that allows for easy integration with a Content Delivery Network (CDN). Incorporating a CDN with your website gives you several benefits, including the following:     ★ Faster Page Loads - Since most of your files will be served from a much closer location to your en...
Email Protector
Free

Email Protector

By Regular Labs
Site Security
Email Protector - Safely cloak email addresses in Joomla! Email Protector cloaks email addresses in your Joomla! website, making them unreadable for spambots. Email Protector is a replacement for the Joomla! core email cloaking plugin. The core email cloaking plugin has a couple of issues and shortcomings. Email Protector solves these issues. NO MORE JAVASCRIPT ISSUES The core email cloaking p...
Snippets
Free

Snippets

By Regular Labs
Coding & Scripts Integration
Snippets - make content placeholders. With Snippets you can make reusable snippets (pieces of text/content) and include them into your content via a tag, like: {snippet my-first-snippet} If you edit the article (or module or wherever you put the tag), you will still see the tag. But on frontend view you will see the content of the snippet instead. You can use this to insert much used content...
Conditional Content
Free

Conditional Content

By Regular Labs
Site Access
With Conditional Content you can restrict or grant access to parts of the content based on a wide selection of conditions (based on device, user groups, date ranges, languages and menu items to name a few). Creating conditions is a easy as placing {show} or {hide} around your special content. For example, to show a piece of text only to guests (not logged in visitors), you can do this: {show...
Articles Field
Free

Articles Field

By Regular Labs
Custom Fields
Articles Custom Field - With the Regular Labs Articles Field you can create links between articles. Articles Field is a Joomla! custom field plugin that greatly extends the capabilities of custom fields. With the native Joomla! lists fields, the values are only treated as plain text and cannot be linked to any other content. The Regular Labs “Articles Field” (articles) is a Joomla custom fi...
What? Nothing!
Free

What? Nothing!

By Regular Labs
Miscellaneous
What? Nothing! does nothing... just nothing! Are you just like me and sometimes just want to do nothing, nothing at all? Well, that brought me to this revolutionary plugin for Joomla! All these plugins that are available do all sorts of stuff. All busy doing their thing. Adding functionality here. Manipulating html output there. Making your website better and better. Well, that's all good and n...
Quick Index
Free

Quick Index

By Regular Labs
Article Elements
Quick Index - add a table of contents quickly in Joomla! With Quick Index you can easily add an index (Table of Contents) to your content. The index will be generated based on the headings in your content. Simply place {index} where you want the index to show. You can see Quick Index in action on this website on all the Tutorial, FAQs and Videos pages (at the top of the content). Quick Index o...
Tooltips
Free

Tooltips

By Regular Labs
Article Elements
Tooltips - add tooltips in Joomla! With Tooltips you can use a simple syntax to give any piece of text or image a nice and simple tooltip. You can create these tooltips virtually anywhere in your site. So not only in articles, but also in modules and components. Syntax The syntax simply looks like: {tip title="Wow!" content="Now I can give something a cool tooltip!"}This t...
IP Login
Free

IP Login

By Regular Labs
Site Access
With IP Login you can log into you Joomla frontend and/administrator side automatically by IP address. You can simply set up your IP address and a secret URL key in your user profile in the administrator. How to use it: https://www.regularlabs.com/iplogin...
Keyboard Shortcuts
Free

Keyboard Shortcuts

By Regular Labs
Admin Navigation
Keyboard Shortcuts adds quick access to actions via hotkeys for your Joomla site. Do you find yourself pressing CTRL+S or ⌘+S every time you want to save an article in Joomla? Doesn't work, right? Your browser just wants to export the page as html instead. Well, Keyboard Shortcuts changes this for you! Now you can use your trusted keyboard shortcut to 'Save' an article - as well as many other...
Better Frontend Link
Free

Better Frontend Link

By Regular Labs
Article Preview
Better Frontend Link- link directly to the frontend page you need. Better Frontend Link changes the way the "Frontend" link in your administrator works. It will show you: The frontend equivalent of the page you're editing (article, category...). Any parent pages of the current item, such as the parent category pages of the article. The Homepage. How to use it: https://www.regularlabs.com/be...
Tabs & Accordions
Free

Tabs & Accordions

By Regular Labs
Access & Security
Tabs & Accordions - make content tabs and accordions. With Tabs & Accordions you can make content tabs and accordions anywhere in Joomla! The syntax simply looks like: {tab Tab title="Title 1"} Your text... {tab Tab title="Title 2"} Your text... {/tabs} or: {accordion Tab title="Title 1"} Your text... {accordion Tab title="Title 2"} Your text... {/acco...
Users Anywhere
Free

Users Anywhere

By Regular Labs
User Management
Users Anywhere - place user data anywhere you can enter text. Users Anywhere is a powerful plugin that allows you to insert user data anywhere on your site, including within articles, modules and 3rd party components. Not only you can place the name of the user, but also place other specific user data (like username, email, ontact details, Custom Fields, etc). You have full control over how you...

DB Replacer

Version:
8.1.0
Developer:
Regular Labs
Last updated:
Jun 13 2025
2 months ago
Date added:
Nov 18 2014
License:
GPLv2 or later
Type:
Free download
Includes:
c
Compatibility:
J3 J4 J5
Download

Uses Joomla! Update System

Score:


Write a review