Which MySQL Database goes with which C5 install?

Permalink
I use Hostmonster. They said I have too many sql tables. They said most of them were installed by C5.

When I first installed C5 I didn't really know how it all worked and still don't. I installed C5 in several sub-domains. I guess I should have not had sub-domains but instead had one install and used pages/sub pages instead. So I need to correct this.

How do I tell which database goes with which C5 install?

How do I move my "sub domain installs" to my main install? Can I just move the pages using File Manager?

 
enlil replied on at Permalink Reply
enlil
If you look in /config/site.php for each site you will see which database each uses!
SheldonB replied on at Permalink Reply
SheldonB
if you have page statistics on turn it off and in the mysql *phpmyadmin for your c5 you can clear the entries for stats

also you can delete your old updates

*make sure you back up before you start deleting anything though
BoMarTuck replied on at Permalink Reply
Thank you. I used this and deleted 3 old DataBases.

Any thoughts on moving pages from one install to another?
enlil replied on at Permalink Reply
enlil
Copy and paste is probably your quickest and best bet as all page info is stored in the database. So unless you have the know how to go about it that way ?!
BoMarTuck replied on at Permalink Reply
I'll give it a try. Is there somewhere that tells about the structure of the DB such as what each entry affects or does?

Thanks for your help.

Bob
JohntheFish replied on at Permalink Reply
JohntheFish
A bit late here, but for convenience I have a free addon that adds a display of config/site into the dashboard.

http://www.concrete5.org/marketplace/addons/config-info/...
BoMarTuck replied on at Permalink Reply
Thanks John. I loaded it up and it works well.