Do you have many domains with shared hosting and several WordPress databases installed? Having trouble finding which database belongs to which domain? Here is your answer.
You can find which database belongs to each domain as shown below. It is recommended to make a note of each Domain’s database (Domain name + Database name) for future reference.
How to identify each domain’s database
Access your Control Panel, go to phpMyAdmin. You will see a list of databases wrdp1, wrdp2, etc.
Select the first database wrdp1, by clicking on it.
A list of database tables will appear as shown below. Click the first icon that appears next to table wp_options to browse.
The first 2 entries shown in this table are:
You have identified the domain which this database belongs to. Do the same for each database and you will have identified the databases of all your domains.
Reward yourself with a beverage of choice.
Note: This article was written in response to a question in the comment
on the article Restore WordPress Database