XF Database Size

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?
 

Brogan

XenForo moderator
Staff member
Would a 300mb MyBB database (Total Posts: 423,430 / Total Threads: 33,104 / Members: 1,154) translate into a much larger XenForo database?
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.
 

Solidus

Well-known member
Would a 300mb MyBB database (Total Posts: 423,430 / Total Threads: 33,104 / Members: 1,154) translate into a much larger XenForo database?
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.
 

teletubbi

Well-known member
Xenforo
DB: 2.53 GB

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
 

Joe.

Active 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.
Ah, I see.

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

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?
 

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.
 

dethfire

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

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
 

hellreturn

Active 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.
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
 

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
 
Top