How to Find out the Name and Type of Database your Joomla Website is Using

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.

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.

cPanel 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.

 Web Hosting

See

And Finally

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.

JovialGuide

We provide comprehensive tutorials. Reach us on Facebook via JovialGuide.

Leave a Reply

Your email address will not be published. Required fields are marked *

 

Shares