XF 1.1 How to remove all tables/columns that are not XF Default

[faeronsayn]

I've imported a database that was filled with plugins. But I don't have the plugin files, hence I can't manually remove them.

I was wondering how I can simply run a query that preserves all the xf default tables and removes all the plugin additions.

Any idea on how to go about this?

Edit: This is the query I ran to disable all the addons since it wouldn't let me without the addon files.

UPDATE xf_addon
SET active = '0'
WHERE active = '1';

 

[faeronsayn]

Anyone has an idea?

 

[Brandon Sheley]

DROP TABLE table_name

http://www.w3schools.com/sql/sql_drop.asp

 

[Mike]

You'd need to compare the schemas (and some data) between a stock install and your modified install. There's no other method to do it.

 

[faeronsayn]

DROP TABLE table_name

http://www.w3schools.com/sql/sql_drop.asp

I know that much lol. I was wondering, how I could say something like, drop all tables except the xenForo default ones.

Also, some addons add columns to xenForo default tables.

 

[Brandon Sheley]

oh, I don't see how that would be possible.
You can try something like DB compare to see what changes are in place outside of the default setup, but you'll need a default DB setup to compare it to.

 

[borbole]

I know that much lol. I was wondering, how I could say something like, drop all tables except the xenForo default ones.

Also, some addons add columns to xenForo default tables.

Short of writing a script that can do that in one fell swoop you will have to do it manually. As mentioned above, remove the custom tables added by third party mods. The same thing with the custom fields as well that may have been added in xenforo tables.

 

[Paul B]

Send me your schema and version and I'll provide a diff.