Actions

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

From Joomla! Documentation

(Using the Joomla! back-end (Super administrators only))
(Corrected spelling, markup and spacing.)
Line 1: Line 1:
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.
+
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.
== Using the Joomla! back-end (Super administrators only) ==
+
# Go to ''Global Configuration'' by clicking the button in the control panel or via the menu (''Site > Global Configuration'').
 
+
# Go to the ''Server'' Tab.
# Log in to the Joomla! backend
+
# Under ''Database Settings'', look for ''Database Prefix'' field. The value you find there is your database prefix.
# Go to "Global Configuration" by clicking the button or via the menu (Site > Global Configuration)
+
# Go to the "Server" Tab.
+
# Under "Database Settings", look for "database" prefix. The value you find there is your database prefix.
+
 
''Tip: Look for the yellow warning symbol''
 
''Tip: Look for the yellow warning symbol''
  
== Using Configuration.php (Requires acces to site root) ==
+
== Using Configuration.php (Requires Access to the Site Root) ==
 
+
# Go to the document root and find the ''configuration.php'' file.
# Go to the document root, and find "configuration.php"
+
# Open the file in a text editor.
# Open the file in a text editor.
+
# Search for the word ''dbprefix''.
# Search for "dbprefix".
+
# You'll see the line var $dbprefix = 'value'. The value you see here (for example, ''jos_'') is your database prefix.
# You'll see the line var $dbprefix = '''value'''. The value you see here (e.g jos_) is your database prefix.
+
 
+
  
 
[[Category:Database]]
 
[[Category:Database]]
{{review}}
 
 
[[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)

  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.