XF 1.4 Lower backup size

[NYCFC]

My backups are fairly large.
The forum has almost 130,000 posts and nearly 2,000 members. The backups are 2.2gb. Is that normal? Or is there some stuff I can do to prune old data that won't affect threads/members.

 

[Paul B]

You could omit the xf_search_index table, which can be rebuilt in the event of a restore.

Other than that, you can disable the 'Cache BB Code output' option in Options -> Performance, which is likely another large table and doesn't really make much difference in having it enabled or disabled.

 

[AndyB]

Install Enhanced Search.

 

[NYCFC]

You could omit the xf_search_index table, which can be rebuilt in the event of a restore.

Other than that, you can disable the 'Cache BB Code output' option in Options -> Performance, which is likely another large table and doesn't really make much difference in having it enabled or disabled.

That was already disabled. Omitting xf_search would be done through host database management? I'm assuming, rather than via Xenforo?

 

[Paul B]

Yes, you just omit/deselect the table when taking the backup.

 

[NYCFC]

Yes, you just omit/deselect the table when taking the backup.

Don't mean to be a pain. Don't have option to unselect anything.
I'll shoot the host an email

 

[Paul B]

You would need to contact your host then if you are using some sort of control panel backup function.

 

[viper357]

Other than that, you can disable the 'Cache BB Code output' option in Options -> Performance, which is likely another large table and doesn't really make much difference in having it enabled or disabled.

If that is disabled does it then empty the table? Or will I have to do that manually? What is the table name? Thank you.

 

[AndyB]

Or will I have to do that manually? What is the table name?

You have to empty it manually. Here's the information to do that:

https://xenforo.com/community/threads/remove-data-from-bb-code-cache-days.58600/

 

[viper357]

You have to empty it manually. Here's the information to do that:

https://xenforo.com/community/threads/remove-data-from-bb-code-cache-days.58600/

Thank you.