XF Database Size

[Nebulous]

How big is your MySQL database for your forum?

What are your forum stats?

 

[Nebulous]

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

 

[AndyB]

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

 

[Paul B]

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.

 

[m1ne]

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]

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

 

[Nebulous]

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

 

[Nebulous]

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?

 

[Paul B]

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.

 

[rdn]

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

1.3GB Database.

 

[dethfire]

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]

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

 

[hellreturn]

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

This is what I use

mysqldump --opt -Q -u "username" -p dbname | gzip -9 > dbname`date +%Y%m%d-%H%M`.sql.gz

Works good
replace username / dbname with your own MySQL backup user name/ database name