Finding site's database name

  • Resolved nemci7v

    (@nemci7v)


    14 years, 1 month ago

    Using phpMyAdmin, I’m trying to determine which database belongs to a certain site. The problem is that have 41 WP databses. How can I tell which is for what site other than checking the data of each one?

Viewing 3 replies - 1 through 3 (of 3 total)

  • check you wp-config.php file for each of website and you will see your database information there.

    Moderator t-p

    (@t-p)

    Also,

    -do they all have the same DB table prefix? If not, that would be one way to tell.

    -one way would be to check the URL in the DB. If you have access to your database, in the wp_options table, check the ‘siteurl’ (should be record 2.

    Thread Starter nemci7v

    (@nemci7v)

    @govpatel, thanks! That’s the best solution! ??

    @t-p, that’s also good to know! Although it would take long to check the URL for each DB.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Finding site's database name’ is closed to new replies.

Tags