You’d want to find out the name or type of database your Joomla website is using, either to backup/export your Joomla database tables or for any other reason. The most important thing is for you to know the name and type of your Joomla database.
Since Joomla supports different type of databases, it’s totally impossible to guess the type of database your Joomla website is using.
What if you didn’t take note of the database name and type you picked while installing Joomla? This Joomla tutorial is for you!
In this JovialGuide, you’ll learn how to find out the name and type of database your Joomla website is using.
Table of Contents
How to Find Database Name and Type in Joomla
The first sub-section will show you how to find the database name your Joomla website is using while the second sub-section will show you how to find out the type of database your Joomla website is using.
Finding Database Name in Joomla
To find the database name in Joomla, login to the cPanel (Control Panel) of your Joomla hosting account.
Under files , click on file manager.
You’ll see folders like public_html, public_ftp, etc. Click on public_html . This is the folder where all of your Joomla website files and folders are stored.
Find and open the configuration.php file (inside public_html). It’s located inside the public_html folder. The path is like this: public_html » configuration.php.
The configuration.php file is a very sensitive file in your public_html folder. It contains your database prefix, database username, database password, etc.
The configuration.php file should be protected!
When the configuration.php file opens, find
public $db = "database_name"
It’s located below public $password = “your_database_password” and located above public $dbprefix = “your_database_prefix”.
The name of the database your Joomla website is using is the value of public $db. your_database_name is an example in this tutorial.
Now that you’ve known the name of the database your Joomla website is using, let’s learn how to find out the type of database our Joomla website is using.
Finding the Database Type Your Joomla Website is Using
Joomla supports different type of databases, like;
To find the database type in Joomla, (still on the configuration.php tab you opened earlier). Find
public $dbtype ="your_database_type"
It’s located right above public $host = “your_host_name” and below public $debug_lang_const = “1”.
The type of database your Joomla website is using is the value of public $dbtype.
your_database_type is an example in this Joomla tutorial. Your database type will be where you have your_database_type.
Can I Still Access my Website Files Using FTP?
Yes, you can!
To begin, login to your FTP (File Transfer Protocol) client and click on public_html. On the public_html page, find and open configuration.php file. Inside the configuration.php file, you’ll find the database name and database type of your Joomla website.
You’ll also like;
Notice that in the configuration.php file, other of your details (usernames, passwords, table prefix, etc.) are present in there. So, the configuration.php file is a very important/sensitive file that make up your Joomla website and it should be kept safe since it contains your secret codes.
We also covered other Joomla tutorials in the Joomla section of JovialGuide.