• 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?

RoldanLT

Well-known member
#1
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 ?
 

Brogan

XenForo moderator
Staff member
#2
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.
 

Brogan

XenForo moderator
Staff member
#5
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.
 

audiokid

Active member
#8
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
 

audiokid

Active member
#11
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
Is that something I can do globally. This is to do with a soundcloud bbcode .

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