1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF Database Size

Discussion in 'General XenForo Discussion and Feedback' started by Joe., Mar 21, 2015.

  1. Joe.

    Joe. Active Member

    How big is your MySQL database for your forum?

    What are your forum stats?
     
  2. Joe.

    Joe. Active Member

    Would a 300mb MyBB database (Total Posts: 423,430 / Total Threads: 33,104 / Members: 1,154) translate into a much larger XenForo database?
     
  3. AndyB

    AndyB Well-Known Member

    Database size: 925MB
    Posts: 1,385,110
    Threads: 95,235
    Members: 8,535
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Possibly, as XenForo stores all of the content from the post table in the search table also - if you are using standard MySQL search.

    There are a few other tables which can become quite large (ip, bb code cache), although they can be controlled by changing or disabling options.
     
  5. Solidus

    Solidus Well-Known Member

    Yeah, my database size doubled when switching. Shouldn't even matter unless you're paying for hosting with 2gb storage, idk why you'd do that.
     
  6. teletubbi

    teletubbi Active Member

    Xenforo
    DB: 2.53 GB [​IMG]
    Post: 1,225,983
    Threads: 28,314
    Pictures: 314,763
    Attachments: 321,474
    Members: 7,881

    Imported from a VB4 DB with a size of 3.78 GB [​IMG]
     
  7. Joe.

    Joe. Active Member

    Ah, I see.

    I have plenty of space, I was just curious. I'll post how big my database is after the conversion. Right now it is 309mb's
     
  8. Joe.

    Joe. Active Member

    New database on XF is near 1100mb's but I assume its safe to empty the search index table before a backup or if I ever wanted to move to a new host?
     
  9. Brogan

    Brogan XenForo Moderator Staff Member

    Yes, that's fine.

    Naturally you would have to rebuild the index again in order to be able to search.

    For backup purposes, you can just omit that table, rather than truncate it.
     
    Joe. likes this.
  10. RoldanLT

    RoldanLT Well-Known Member

    Discussions:52,489
    Messages:603,749
    Members:122,741

    1.3GB Database.
     
  11. dethfire

    dethfire Well-Known Member

    It can hurt for backups. If your db is 5gig then you need 35gig just for a week of backups and just for the db.
     
    hellreturn likes this.
  12. Moshe1010

    Moshe1010 Well-Known Member

    DB size doesn't say much. It depends on factors regardless of posts such as bb-code cache and non-unicode characters
     
  13. hellreturn

    hellreturn Active Member

    Any kind of zipping helps. I use tar or rar and compress old back ups. Simple zip would reduce your file size by 70% min. Give it a try.

    Take back up, compress and upload to another FTP. I need to set up rsync but to lazy for it lol
     
  14. Fred.

    Fred. Well-Known Member

    This is what I use
    Code:
    mysqldump --opt -Q -u "username" -p dbname | gzip -9 > dbname`date +%Y%m%d-%H%M`.sql.gz
    Works good (y)
    replace username / dbname with your own MySQL backup user name/ database name
     
    maszd likes this.

Share This Page