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

XF Database Size

Joe.

Active member
#2
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
#4
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
#5
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
#6
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
#7
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
#8
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
#9
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.
 
#13
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
#14
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