Inserting specific data and ignoring the rest.

[JazzleBug]

I'm trying to clean up my database. Ultimately, what I'd like to do is install clean software with a clean database, resinstall only the hacks I desperately need (which happen to have quite a bit of extra data to be imported), insert the necessary data, and end up with no orphaned tables or unused data.

More specifically where the database is concerned, after all of my hacks are installed on the clean software (complete with database modifications), I need to insert only the data that will fit into the new tables and simply ignore anything left over (unused/orphaned data/tables).

Further explaination needed? FYI, I use SSH primarily due to the large community size.

Please, if anyone can offer any guidance on this, I'd be more than appreciative. I've been banging my head on my desk for the past day and a half trying to work this out.

[Andreas]

Do a vB3->vB3 import with Impex and you'll have a clean database.
Or compare the scheme off all your tables to a blank installation and drop what you don't need anymore - this should alos result in a clean database (but there might be orphaned settings/phrases/templates then which still need to be killed manually).

How large is your community?

[JazzleBug]

The database is 532 MB. I've played around with ImpEx a bit, but that leaves the added database tables out and I'll still need to insert that data. Which, actually, wouldn't be so hard except that I'm looking for the fastest, easiest way to do this, preferably with a few commands. Something that would essentially allow the data that fit to filter on in and the rest would be ignored.

If only life were so easy. Thank you for your quick response.

[Andreas]

Well as there are (and probably never will be) filters for hacks data you are left to cleaning your database manually.
522 MB isn't that much, so it sounds doable.

[JazzleBug]

Fortunately, you're right - it's not that big, so manually is probably my best bet. Thank you, Kirby.