You’d want to find out the name and type of database your Joomla website is using, either to backup export your Joomla database tables or for anything. The most important thing is you should know the name and type of database your website is using.
Since Joomla supports different types of databases and the name of your database could be anything. It’s totally impossible to guess the name and 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 JovialGuide is for you.
In this JovialGuide, you’ll learn how to find out the name and type of database your Joomla website is using.
WordPress users looking for the best WordPress web hosting provider in 2019, see top 10 best WordPress web hosting service providers in 2019
If you are looking for the best Joomla web hosting provider in 2019, we wrote a JovialGuide that shows you the top 10 best web hosting companies that offer Joomla hosting in 2019. These top 10 best Joomla web hosting service providers in 2019 offer quality Joomla website hosting services.
Magento users aren’t left behind! We also wrote a JovialGuide that lists out the top 10 best Magento web hosting companies in 2019.
Table of Contents
Finding Out the Name of the Database your Joomla Website is Using
Login to the cPanel (Control Panel) of your web 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 since 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.
You are done, but don’t close this tab, you’ll need it to find out the type of database your website is using.
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 Out the Type of Database Your Joomla Website is Using
Since Joomla supports different types of databases like PDO, PostgreSQL, MYSQL, etc.
To find out the type of database your website is using, (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 tutorial. Your database type will be where you have your_database_type.
Can I Still Access my Website Files Using FTP?
Absolutely yes, you can!
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 type of your Joomla website.
- how to setup, install and run Joomla locally on android (step by step tutorial with pictures)
- the beginners guide: the overview of the control/administrative panel of Joomla (step by step tutorial with pictures)
- how to perfectly learn/practice Joomla very fast for free (step by step tutorial)
This JovialGuide has shown you how to know the name and type of database your Joomla website is using.
Notice that in the configuration.php, other of your details (usernames, passwords, table prefix, etc) are present in there. So, the configuration.php is a very important file of your Joomla website, it should be kept safe since it contains your secret codes.
We welcome comments, so, do well to leave one.