Change database preifix for an existing database

For Joomla! 2.5 Coding related discussions, please use:
Note: All 1.6, 1.7 and 3.5 releases have reached end of life and should be updated to 3.x.

Moderator: ooffick

Forum rules
Please use the mailing list here: rather than this forum.
Joomla! Intern
Joomla! Intern
Posts: 69
Joined: Wed Dec 23, 2009 4:27 pm

Change database preifix for an existing database

Post by tjhaas » Sun Mar 13, 2016 8:18 pm

How does one go about changing the database prefix for an existing Joomla website?

Is there a function within Joomla that will change the prefix within the database itself or do I need to edit the database manually?

User avatar
Joomla! Master
Joomla! Master
Posts: 13320
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Change database preifix for an existing database

Post by sozzled » Sun Mar 13, 2016 9:36 pm

There is no feature within the standard Joomla CMS that allows you to change the prefix of your Joomla database tables. It is, however, possible to change the table prefix of your database tables using phpMyAdmin.

To change the table prefix of a database, go to phpMyAdmin (in your cPanel):

1) Select the database and use the checkbox at the bottom of the page to select all the tables as shown in the image below:


2) With your mouse, use the With selected pull-down and click Replace table prefix

3) On the next screen that will appear (see the image below):


Enter the old table prefix in the first of the two textboxes and enter the new table prefix in the second textbox and then click the Submit button.
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?”
Walking the talk:


Return to “Joomla! 2.5 Coding”