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

[rdn]

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 ?

 

[Paul B]

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.

 

[JulianD]

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.

 

[rdn]

So the full list will be:

xf_search
xf_search_index
xf_admin_log
xf_moderator_log
xf_ip
xf_bb_code_parse_cache

All of these are safe?

 

[Paul B]

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.

 

[rdn]

Thanks Brogan!

No, I'm transferring to a powerful plan @nimbus hosting now

 

[rdn]

What about xf_ip_match ?

 

[audiokid]

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

 

[Chris D]

Just turn off the BB Code Parse Cache feature.

 

[RobParker]

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

 

[audiokid]

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.

 

[audiokid]

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

 

[MattW]

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

Correct