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!

  • #2
    Just backup the database using mysqldump and compress it.

    GIPHY for vB5 AutoLinker Auto-Create Flag Report INITIALS AVATAR (Better) Name Card Quote Selected Text Likes Summary Disable AJAX Pagination Stop Links in Posts...& MORE!


    • #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.