Separate Database from vBulletin

fishingfool · July 12th, 2011, 12:27 PM

Is it possible to separate the PhotoPost Database from the vBulleting Forum database and into it's own?

Combined it is too large for the server requirements of SiteGround's shared hosting and we need to get it slimmed down to move over there. The database is currently 522MB combined and we are hoping if we can separate them that the vbulletin DB will be less than the 500MB limit.

How large does the PhotoPost tables add to the database when installed with it and can it be separated?

If so, how much?

Chuck S · July 12th, 2011, 02:10 PM

Your photopost database tables should be prefixed by your prefix set in the config settings. Normally pp_ that means you would copy all pp_ tables to the new database and then in our config-inc.php file put the proper new database information for photopost database there and you should be good to go.

fishingfool · July 18th, 2011, 07:15 PM

Thanks Chuck...any idea how big the Photopost DB is right?

Chuck S · July 18th, 2011, 08:24 PM

I would not be able to tell you how big your data is only you can do that.