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

From Joomla! Documentation
(Corrected spelling, markup and spacing.)
(6 intermediate revisions by one other user 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:Database]]
−
{{stub}}
 
 
[[Category:Stubs]]
 
[[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)[edit]

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

  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.
Retrieved from "https://docs.joomla.org/index.php?title=How_to_determine_your_database_prefix&oldid=60939"