Actions

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

From Joomla! Documentation

(Using Configuration.php (Requires acces to site root))
(Corrected spelling, markup and spacing.)
(One intermediate revision by one user not shown)
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.