How to determine your database prefix

From Joomla! Documentation

Revision as of 16:54, 19 July 2011 by Cmb (Talk | contribs)

There are two ways to determine your database prefix. One requires access to the root of your Joomla! site while the other requires access to the Joomla! back-end.

Using the Joomla! Back-end (Super administrators only)

  1. Log in to the Joomla! backend.
  2. Go to Global Configuration by clicking the button in the control panel or via the menu (Site > Global Configuration).
  3. Go to the Server Tab.
  4. Under Database Settings, look for Database Prefix field. The value you find there is your database prefix.

Tip: Look for the yellow warning symbol

Using Configuration.php (Requires Access to the Site Root)

  1. Go to the document root and find the configuration.php file.
  2. Open the file in a text editor.
  3. Search for the word dbprefix.
  4. You'll see the line var $dbprefix = 'value'. The value you see here (for example, jos_) is your database prefix.