Support How to reduce the database size of Xenforo?

[DarKMaSK]

Hi friends!
I am using Xenforo 2.2.4. I tried to upload my site to my web server but the problem is the 'maximum database import size' is 50MB and my forum's database size is 53MB. So I am unable to upload the database to my server. How can I reduce the size of database without reducing its functionality? I searched internet and found that some people advised to disable the 'BB_code cache output', but I couldn't find it? Though some people asked to do it but some complained that it did not do anything. Please advise me how to reduce my forum's database size. Please help me. I know only you people can help me.

 

[Marks-Man]

I know. But as I have uploaded it to my live server (here is my post about it: My forum Rabibashoriyo ) and as it is a shared hosting, I cannot increase that limit and the host will not increase it in shared server. But what I did, when I was exporting the database, I choose Zip compression and it compressed to 4.9MB and the problem was solved.

Just from my own experience, most of time database compression fails, importing it in future might be a real headache and might be a corrupted database.

 

[En1gma]

In the days of PHP 5+ there was a script that coped with any size of database export & more importantly restoration called MySQLDumper.
But since PHP 7 versions it has ceased working as the author stopped updating it..
A great shame indeed as was the best out there..

 

[Marks-Man]

In the days of PHP 5+ there was a script that coped with any size of database export & more importantly restoration called MySQLDumper.
But since PHP 7 versions it has ceased working as the author stopped updating it..
A great shame indeed as was the best out there..

These days no one use shared hosting.
VPS prices are great, you can find OVZ VPS cheap ones 3$ a month. you can export and import via phpmyadmin

 

[En1gma]

These days no one use shared hosting.
VPS prices are great, you can find OVZ VPS cheap ones 3$ a month. you can export and import via phpmyadmin

I'm not disputing it.. I do have a VPS with time4vps with WHM/cPanel and very nicely priced at that...
I was simply stating that when MySQLDumper was fully functioning it was an amazing script that coped very well with very large database restores, editing directly into the database or merging backups after any serious mishap.. I certainly wish it was still functioning, saved my bacon a few times when I built and ran the original Ares Wizard forum years ago.. Thousands of members, over 3 Million hits a day with half a milleion downloads everyday from the various repository's we had.. Good times, back in the day when my brain & memory functioned as normal.. PMSL..
MySQLDumper

 

[Marks-Man]

I'm not disputing it.. I do have a VPS with time4vps with WHM/cPanel and very nicely priced at that...
I was simply stating that when MySQLDumper was fully functioning it was an amazing script that coped very well with very large database restores, editing directly into the database or merging backups after any serious mishap.. I certainly wish it was still functioning, saved my bacon a few times when I built and ran the original Ares Wizard forum years ago.. Thousands of members, over 3 Million hits a day with half a milleion downloads everyday from the various repository's we had.. Good times, back in the day when my brain & memory functioned as normal.. PMSL..
MySQLDumper

no one has a brain functioning properly these days .
Only problem with time4vps there OVZ container and storage servers doesn't handle ddos attacks no ddos protection hardware, otherwise they are great