I am in the process of migrating two wordpress sites to a hew hosting platform. Sounds simple enough right? Well, these two sites are both add-on domains and whomever installed them apparently had trouble and tried installing them in multiple directories. There are several copies floating around as well as databases with very similar names.
I am asking for suggestions as to how i can find the right database for both active sites so I can export the right databases.
Thanks in advance for your help. Any other tips having to do with migrating to a new host would be greatly appreciated.