How to determine your database prefix

From Joomla! Documentation

Revision as of 13:37, 20 January 2011 by Toretto (Talk | contribs)

There are various 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 or via the menu (Site > Global Configuration)
  3. Go to the "Server" Tab.
  4. Under "Database Settings", look for "database prefix. The value you find there is your database prefix.

Tip: Look for the yellow warning symbol

Using Configuration.php (Requires acces to site root)

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