5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

How to find out which sql database goes with which WP installation?

by LynnM
3 replies
Hi guys,
I'm trying to transfer a WP site to a different host, but I have 12 sql databases (numbered of course wrdp1, wrdpr2, etc.). I have no idea which database goes with which wordpress installation - is there an easy way to figure this out?

Thanks,

Lynn
#database #find #installation #sql
  • Profile picture of the author warfore
    I had this problem when trying to determine which database is which. I ended up going to "php admin" on the cpanel, opening up the list of mysql databases and clicking on the database. When the database opened I clicked on "wp_posts" and clicked the edit button. The table would have information from the different posts in that blog. If I recognized the posts as being part of that blog then I knew the identity of the website. There is probably a better way but this way worked for me.
    Signature

    Regards,

    Tony

    {{ DiscussionBoard.errors[1471142].message }}
  • Profile picture of the author pjCheviot
    Banned
    Hi Lynn

    One of the drawbacks of using Fantastico etc to auto install without giving a relevant name.

    My quick method is to look at "wp-config.php" (in the blog root directory) - details in there. Alternatively go into your cpanel and look in phpMyAdmin - but this takes much longer (I think anyway)

    Hope that helps
    {{ DiscussionBoard.errors[1471146].message }}
    • Profile picture of the author LynnM
      Thanks very much, Tony and pj - your help's much appreciated.


      Lynn
      {{ DiscussionBoard.errors[1471151].message }}

Trending Topics