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

From Joomla! Documentation

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 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) ==
 +
 
 +
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) ==
 +
 
 +
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. 
 +
 
  
 
[[Category:Database]]
 
[[Category:Database]]
 
{{stub}}
 
{{stub}}
 
[[Category:Stubs]]
 
[[Category:Stubs]]

Revision as of 14:30, 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.