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

rdn

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 ?
 
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.
 
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.
 
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
 
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. :)
 
Back
Top Bottom