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

From Joomla! Documentation

Line 4: Line 4:
 
== Using the Joomla! back-end (Super administrators only) ==
 
== Using the Joomla! back-end (Super administrators only) ==
  
1. Log in to the Joomla! backend
+
# Log in to the Joomla! backend
2. Go to "Global Configuration" by clicking the button or via the menu (Site > Global Configuration)
+
# Go to "Global Configuration" by clicking the button or via the menu (Site > Global Configuration)
3. Go to the "Server" Tab.
+
# Go to the "Server" Tab.
4. Under "Database Settings", look for "database prefix.  The value you find there is your database prefix.
+
# 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 acces to site root) ==

Revision as of 14:36, 20 January 2011

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.