Support Joomla!
Search: Advanced Search
Serving 4165 extensions to the community. Last updated today.

Editor Blogs






Lost Password?
No account yet? Register

Who's Online

We have 1147 guests and 71 members online

Directory Support

Rules
Using this Site

Disclaimer

The extensions and reviews listed in this area have been submitted by the community and their listing does not constitute or imply endorsement, recommendation, or favouring by Joomla!/OSM.

This content is provided as a free service to our visitors, and, as such, Joomla!/OSM cannot be held liable for the accuracy of the information. Visitors wishing to verify that the information is correct should contact the parties responsible for authoring the content and/or development of the extension.


Database Management Show All Developer's Extensions
DB Admin - Set Table Prefix Componentcomponent
Rating
15 votes
Developer:David Thomas Version:1.1 (Updated 256 days ago)
E-mail: This e-mail address is being protected from spam bots, you need JavaScript enabled to view it Compatibility:Compatible with Joomla! 1.0
Views: 27,054 License:GPLv2.0
Favoured:
16
Type:Non-Commercial
Date Added:Oct 25, 2006
DownloadHomepageDemoWrite ReviewRecommend
DB Admin - Set Table Prefix
This is a simple component to let you change your Joomla Database Table Prefix. Changing your table prefix is good for security and also allows you to run multiple Joomla installations from one database.

* Change database table prefix ( e.g jos_ to xyz_ )
* Comprehensive validation for safe and secure renaming.
* Only the table prefix is changed.
* No downtime. Change prefix easily and instantly from your Joomla Admin area.
* Updates Joomla configuration file.
* Optional read-only protection for config file.

It is simple, pure PHP code, no new tables are created. The script loops through your Joomla database and performs a search and replace on your chosen database prefix. If the search prefix doesn't exist in a table name, it is skipped and the original table name is preserved. If, by chance, the search prefix exists twice in a table name, it is only replaced once (from the left, i.e table prefix only). The changes are virtually instantaneous and the new prefix is updated in your Joomla configuration file. So basically, you just update the prefix and carry on! A piece of cake :-)

As requested, you can now also change other table prefixes for other installations from the same interface.

If this extension helps you out, please give it a rating or a review. Thanks!

Update: I have setup a new support forum at : http://joomla.daveslist.co.nz/forum

Please direct support questions there.

DT

Report this listing


Does it by sybil, December 15, 2007
Exactly as described. This is a simple security measurement to be applied even by beginners in Joomla!


You are the man! by mokusbajusz, October 25, 2007
I used this brilliant extension to rename my nuke tables in my joomla db.
I was on converting a phpbb forum which was part of a nuke-powered site. I copied all the nuke tables in my joomla db. As I am not familiar with mysql I couldn't replace the nuke_bb* "prefix" on the nuke tables in a batch process. Also I did not want to do it manually (more then 100 tables...).
This extension did the job perfectly in a mouseclick, many thanks for the developer!

Recommended


Very simpel to do by gigabit, October 19, 2007
It's very easy en simpel to do,
and in a few seconds done.


Nice by 24zap, April 23, 2007
2 of 2 people find this review helpful:
Very nice tool.

Installed and worked perfect changing the prefix in DB.

Also, auto updated config. One click ease.

Recommend-
Shawn.


A very useful component by wikimai, December 2, 2006
2 of 2 people find this review helpful:
I like this componenet because I could change the table prefix in a breeze. [Forget that trailing 'underscore' anybody?]. It also updates the config file saving you one additional step.

The only thing I can think to add to this one is to change multiple table prefix in one go. That is, if my database has more than one table prefixes, I want to change them in one go from the single interface. I know the other option is to repeat the steps multiple times. But what if I have 10s of table prefixes. This feature if added would probably be a simple extension.

WM.


Owner's reply:
The new version (1.3) supports the ability to set and change prefixes other than the default Joomla prefix.

Simple, Easy, and it just works by jmuehleisen, November 23, 2006
2 of 3 people find this review helpful:
This module works exactly as described. If you want (for whatever reason) to change your table prefixes, this little component does it simply and easily.

It changes the prefixes in the MySQL database (you can do it via MySQLAdmin, but this is much easier and quicker), and it change the prefix in the configuration of your Joomla site.

Recommended. Thanks David!


DB Admin - Set Table Prefix by wilsonpro, October 31, 2006
3 of 3 people find this review helpful:
I really wanted to be able to remove all traces of the word #ambo from my recently converted Joomla site.

This excellent componant does one hundred percent what it says - no messin! Obviously I backed up my sql database first.

It simply changed all mos_ table prefixes to jos_ and now all I have to do is ask my web host to rename the sql file name from ***_mamb1 to ***_joom1.

Thanks David.