1. 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

Discussion in 'XenForo Questions and Support' started by faeronsayn, Mar 21, 2013.

  1. faeronsayn

    faeronsayn 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';
  2. faeronsayn

    faeronsayn Well-Known Member

    Anyone has an idea?
  3. Brandon Sheley

    Brandon Sheley Well-Known Member

  4. Mike

    Mike 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.
    faeronsayn likes this.
  5. faeronsayn

    faeronsayn 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.
  6. Brandon Sheley

    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.
  7. borbole

    borbole Well-Known Member

    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.
  8. Brogan

    Brogan XenForo Moderator Staff Member

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

Share This Page