Which tables does vBa use specifically ?

[AJ4]

Hi,

I've added a load of pages to my site on my dev machine at home, and I want to add them to my real website without having to manually set them all up. I don't really want to export the whole database as it huge, just the tables with the page and module info. Both my installations and databases are identical, the only difference being the one at home has the extra pages and modules installed. Vba is installed on both sites, so the tables are all setup.

What tables do I need to export and then import ? I tried exporting all the tables with an adv_ prefix, ie

adv_modules
adv_pages
adv_setting
adv_setting group

But it didn't work for some reason, my index page looks exactly the same, although in the admincp the modules and pages are there...

Am I missing a table somewhere ?

Any help or info would be much appreciated, useful for anyone else who wants to backup their cmps only files without backing up the whole forum database.

Cheers

[Brian]

That would be all of the tables. Though you probably need to save one of your modules and pages to update the cache for those.

[AJ4]

Thanks Brian, I tried that and it didn't work unfortunately :( In particular, I have added a 'welcome message' type bb module that displays on the index.php page, it works on my home PC but not my website. I can still see the module and edit it using the vbacmps on the website, but it mysteriously wont show on the front page :(

Does anyone else have this problem when they develop at home and then install onto a website ? I can't be the only person in the world that does this :D:D:D

P.s, the pages work fine now, its the modules that won't show.

[Brian]

Admin CP => vBa CMPS => Edit Pages => Default / Homepage => Modules Enabled

Have you made sure that the module is active on that page?

[AJ4]

yep, I checked that. I also did a line by line comparison of the adv_ tables and they were identical.

When the index is displayed, what table does it look up to see which modules are displayed ? I assume it adv_modules ?

[Brian]

The modules are stored in the datastore table to help cut down on the number of queries. As long as you've saved a module through the admin cp though that should update the cache for them.

[AJ4]

I had a look at the datastore previously and tried exporting / importing it whole but it crashed the database ( it was worth a try :D ). I think thats where the problem lies anyway. I'll have another look at the datastore and see if I've messed it up in some way, as the cache isn't updating.

Cheers !