Table Prefix not applied during install

dagroupinc · Post by **dagroupinc** » Thu Aug 08, 2024 2:24 pm

We are working on a development copy of an existing J4.4.5 website which was created from a backup copy of the live website. However, during the installation process the table prefix shown during the installation process in Joomla wasn't applied to the database for some reason so now all our tables exist without a table prefix. This is causing some issues.

Fixing this is a little out of my realm and was hoping someone here might provide instructions on how to correct this.

Can I easily add the prefix in mySQL and then modify Joomla and the config file to recognize the database with the new prefix?

Thanks in advance.

gws · Post by **gws** » Thu Aug 08, 2024 2:50 pm

You can add it in phpmyadmin.

Webdongle · Post by **Webdongle** » Fri Aug 09, 2024 12:55 am

Try https://docs.joomla.org/Copying_a_Jooml ... _Method.29 to make a copy of the site.

ceford · Post by **ceford** » Fri Aug 09, 2024 3:19 pm

In phpMyAdmin, select your database. Below the list of tables select the Check All check box. The With Selected list has items including Add Prefix. A popup prompts for the prefix to add.

dagroupinc · Post by **dagroupinc** » Mon Sep 23, 2024 4:36 pm

added the table prefix using phpMyAdmin however I'm curious to learn why it wasn't added when it was specified during the install. One of the world's great mysteries ;-)

Webdongle · Post by **Webdongle** » Mon Sep 23, 2024 4:51 pm

dagroupinc wrote: ↑Mon Sep 23, 2024 4:36 pm added the table prefix using phpMyAdmin however I'm curious to learn why it wasn't added when it was specified during the install. One of the world's great mysteries ;-)

You originally said that you "are working on a development copy of an existing J4.4.5 website which was created from a backup copy of the live website". If you did not use https://docs.joomla.org/Copying_a_Jooml ... _Method.29 to copy the site then you might have used the wrong database. Or the live database has two sets of prefixes. Without knowing how you created the copy it is difficult to accurately asses what went wrong.

dagroupinc · Post by **dagroupinc** » Mon Sep 23, 2024 5:46 pm

We used an Akeeba back up of the entire website, created a new database, and performed a clean installation including the prefix. We've done this many times without any issues — except this time. It's been resolved, just a bump we've never experienced.

gws · Post by **gws** » Mon Sep 23, 2024 5:56 pm

FYI, you don't have to create a database with akeeba as it creates it for you.

Webdongle · Post by **Webdongle** » Mon Sep 23, 2024 8:04 pm

gws wrote: ↑Mon Sep 23, 2024 5:56 pm FYI, you don't have to create a database with akeeba as it creates it for you.

On Windows OS with wamp(or similar) localhost. Not sure if it does on a pc running Linux OS or on a mac

The Joomla! Forum™

Table Prefix not applied during install

Table Prefix not applied during install

Re: Table Prefix not applied during install

Re: Table Prefix not applied during install

Re: Table Prefix not applied during install

Re: Table Prefix not applied during install

Re: Table Prefix not applied during install

Re: Table Prefix not applied during install

Re: Table Prefix not applied during install

Re: Table Prefix not applied during install