Page 1 of 1

Change database preifix for an existing database

Posted: Sun Mar 13, 2016 8:18 pm
by tjhaas
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?

Re: Change database preifix for an existing database

Posted: Sun Mar 13, 2016 9:36 pm
by sozzled
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:

Image

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):

Image

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.