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

XF 1.2 What are the list of XenForo Database table that are safe to truncate?

Discussion in 'XenForo Questions and Support' started by RoldanLT, Aug 5, 2013.

  1. RoldanLT

    RoldanLT Well-Known Member

    When importing it to different server, I want to minimze my database size.
    So, What I did is truncate "search_index", "search".

    What other table are also safe to truncate?
    xf_ip? xf_bb_code_parse_cache ?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    xf_admin_log can be truncated, as can xf_moderator_log but they probably won't be that large.
    The search index, ip and bb code parse cache table are the largest ones.

    If you zip the export it should be significantly smaller.

    Don't forget to rebuild the search index if you do truncate it.
    maszd and RoldanLT like this.
  3. JulianD

    JulianD Well-Known Member

    I think that it would take more time to truncate and rebuild caches than to transfer the whole database. If anything, just compress it before transferring it.
    0ptima and RoldanLT like this.
  4. RoldanLT

    RoldanLT Well-Known Member

    So the full list will be:

    All of these are safe?
  5. Brogan

    Brogan XenForo Moderator Staff Member

    Yes but I doubt you're going to save that much time really.
    Unless you are trying to import via phpMyAdmin and your host has implemented some sort of limit.
  6. RoldanLT

    RoldanLT Well-Known Member

    Thanks Brogan!
    No, I'm transferring to a powerful plan @nimbus hosting now :)
  7. RoldanLT

    RoldanLT Well-Known Member

    What about xf_ip_match ?
  8. audiokid

    audiokid Active Member

    I'm experiencing an issue with bbcode where urls need to be refreshed so they embed to the new code. When you say truncate, is this the same thing as empty? I need to empty this table in hope that this fixes my problem.

    Thanks for your advice.

    xf_bb_code_parse_cache" table
  9. Chris D

    Chris D XenForo Developer Staff Member

    Just turn off the BB Code Parse Cache feature.
  10. RobParker

    RobParker Well-Known Member

    If using ES, the search table can be truncated and then not used can't it?
  11. audiokid

    audiokid Active Member

    Is that something I can do globally. This is to do with a soundcloud bbcode .

    Thanks again for the much needed advice right now. :)
  12. audiokid

    audiokid Active Member

    No worries, I truncated it and it didn't help.
  13. MattW

    MattW Well-Known Member


Share This Page