How to determine your database prefix

From Joomla! Documentation

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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)[edit]

  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)[edit]

  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.