primelens — 2012-07-21T18:17:53-04:00 — #1
Hi I'm re-visiting an old site and I noticed on the host control panel there are three mysql databases. I know for a fact that the site is only using one of them and that the other two can be deleted. Is there a way from within the wordpress dashboard, or from looking at code, or from the hosting control panel that I can tell which one to keep?
spacephoenix — 2012-07-21T20:11:04-04:00 — #2
Are you refering to two databases, one called "information_schema" and the other called "mysql"? If so don't touch them as they are used by mysql
primelens — 2012-07-21T20:21:15-04:00 — #3
When we were setting it up we created a number of subdomain testblogs. We got rid of the subdomains when the site launched but we forgot to delete each dbase that related to those tests.
pullo — 2012-07-23T07:26:09-04:00 — #4
It's relatively easy to determine which WP installation is using which DB. Just do the following:
Access your Control Panel
Go to phpMyAdmin
Click on the first DB
Select the table "wp_options"
The first entry in the table is the site URL to which this DB belongs
primelens — 2012-07-23T16:25:55-04:00 — #5
Thanks Pullo, that is a 5 star answer! If there was an up-vote button I would hit it.