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 the name and type of database your Joomla website is using.
How to Find Your Joomla Database Name and Type
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 Your Joomla Database Name
To find the database name of your Joomla website, login to the cPanel (Control Panel) of your Joomla hosting account. If you don’t have a hosting account, signup with A2 Hosting or InMotion Hosting to get started.
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. 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 of your Joomla website, located inside your public_html folder. It contains your Joomla 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 database type.
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.
Note 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.