I'm working on a migration for a forum from VBulletin 4.2 to Xenforo 1.5. I have a test site running and tweaked and have done a migration of the VBulletin data with reasonable success (see here for the one problem I've encountered).
I'd like to save just the site settings at this point, dump everything, start again from scratch with the migration and then restore the site settings (group permissions, template, phrase customizations, overall site search setup, etc.).
I know I can save the entire database to backup the whole site, but if I just wanted the "settings" stuff, what tables would I want to capture? I basically want to exclude:
- Specific user account information
- Nodes and posts
- Tweaks to group permissions
- Phrase tweaks
- Node-specific settings
- Group-specific settings
Though, as I'm typing this out I'm beginning to think even without excluding the posts and user accounts and what not this might be the best way to do things. The import of the data should be deterministic from migration run to migration run, right? User A will be User A every time I do a migration? And Post 123 will be Post 123 every time I do a migration?
If that's the case I could save the whole database, reset, migrate, then restore the save and I think what I'd have is the latest VB content plus all my tweaks reapplied, right?
In any case, I'd certainly appreciate any general advice here. I'm logging tweaks but at this point it'd kind of suck to have to go and reapply them manually again. Especially considering I'm probably in for at least one or two more test migrations before we do our final migration and turn off the VB-based site.