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

by 3 replies
5
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
#programming #database #find #installation #sql
  • 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.
    • [ 1 ] Thanks
  • 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
    • [ 2 ] Thanks
    • [1] reply
    • Thanks very much, Tony and pj - your help's much appreciated.


      Lynn

Next Topics on Trending Feed