• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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


Well-known member
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';


XenForo developer
Staff member
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.

Brandon Sheley

Well-known member
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.


Well-known member
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.