How to determine your database prefix: Difference between revisions

From Joomla! Documentation

Batch1211 (talk | contribs)
No edit summary
Toretto (talk | contribs)
No edit summary
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 19: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)

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.