No announcement yet.

What can I remove from DB?

  • Filter
  • Time
  • Show
Clear All
new posts

  • What can I remove from DB?

    Hello all,

    I'd like to know if I could do to make my DB more "portable".
    Sometimes I need to copy the DB to a local virtual machine and keep the same data from live. However, my DB is large (20GB).

    What data could be removed? (example tables cache)
    What are the effects of "clean the cache" option on admincp?
    What (in case it is possible) tables I could truncate?

    Thanks in advance!

  • #3
    Are you storing attachments in the database? If so, you should probably move them to the File System in the AdminCP under Attachments -> Attachment Storage Type.

    After you have verified they have been moved properly and still usable, then you can optimize the attachment tables under Maintenance -> Repair Optimize.

    The session, cpsession, cache, and cachevent tables can all be truncated. If you don't need search or are willing to rebuild the search engine, you can truncate all the tables starting with the word search.

    If you upgrade to vBulletin 5.2.1, it will drop a bunch of tables from vBulletin 4.X including the post and postparsed tables which contain a lot of extra data at this time.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.