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:
siteurl
blogname
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
http://gnetwork.com.au/wordpress/restore-wordpress-database/comment-page-1#comment-3112
on the article Restore WordPress Database
wow, thank you so much for your reply, im subscribing to your rss feed now, great looking blog by the way, thanks, alan
Great, my main feed shows articles from all my categories – Lotto, Racing, Gaming, Money, Technology and WordPress. If you are interested mainly in WordPress, subscribe to my WordPress feed at:
http://feeds2.feedburner.com/GNetworkWordpress
On a security note, I certainly hope that the database you just publicly displayed was a demo setup rather than the actual database you have running WordPress on your site…
Because if that information is the correct info for your WordPress install, then you just gave a hacker a huge jump at hacking your site. If that information IS correct, then I would highly suggest that you go change your database name and your table prefixes very quickly before someone less honest comes along and happens to see it.
Thanks for your concern Josh. I feel secure enough mate, btw like the look of your site, sweet.
OHH I like this. Thanks. ^_^
I was wondering also how to identify it. Thanks I stumbled upon to this blog. Thank you.