Actions

Difference between revisions of "How to determine your database prefix"

From Joomla! Documentation

(New page: The database prefix can be found in the file configuration.php or in the admin panel under the menu "Site - Configuration File - Global Configuration - Server")
 
(Corrected spelling, markup and spacing.)
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
The database prefix can be found in the file configuration.php or in the admin panel under the menu "Site - Configuration File - Global Configuration - Server"
+
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) ==
 +
# Log in to the Joomla! backend.
 +
# Go to ''Global Configuration'' by clicking the button in the control panel or via the menu (''Site > Global Configuration'').
 +
# Go to the ''Server'' Tab.
 +
# 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) ==
 +
# Go to the document root and find the ''configuration.php'' file.
 +
# Open the file in a text editor.
 +
# Search for the word ''dbprefix''.
 +
# You'll see the line var $dbprefix = 'value'. The value you see here (for example, ''jos_'') is your database prefix.
 +
 
 +
[[Category:Database]]
 +
[[Category:Stubs]]

Revision as of 17:54, 19 July 2011

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.