SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2011
    Posts
    48
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    detect which mysql

    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?

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    4,994
    Mentioned
    100 Post(s)
    Tagged
    0 Thread(s)
    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
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  3. #3
    SitePoint Enthusiast
    Join Date
    Feb 2011
    Posts
    48
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    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.

  4. #4
    Gre aus'm Pott gold trophysilver trophybronze trophy
    Pullo's Avatar
    Join Date
    Jun 2007
    Location
    Germany
    Posts
    5,866
    Mentioned
    206 Post(s)
    Tagged
    12 Thread(s)
    Hi,

    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"
    Click "Browse"
    The first entry in the table is the site URL to which this DB belongs

    HTH

  5. #5
    SitePoint Enthusiast
    Join Date
    Feb 2011
    Posts
    48
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Thanks Pullo, that is a 5 star answer! If there was an up-vote button I would hit it.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •