How can you backup your SQL file

[narc0s]

So if i do the dump in my vps i get only like 20MB sql file but one of my friend was able to backup the entire forum meaning the board the user everything in one sql file and it was around 500+ MB but when i dump it's only 20MB so how can i dump the entire forum which will have everything like icons that i changed and text or post that i made etc

 

[sucre13]

Using chatgpt and generating a script that backs up the database and root files of xenforo is easy to do

 

[Splicho]

So if i do the dump in my vps i get only like 20MB sql file but one of my friend was able to backup the entire forum meaning the board the user everything in one sql file and it was around 500+ MB but when i dump it's only 20MB so how can i dump the entire forum which will have everything like icons that i changed and text or post that i made etc

narc0shttps://enxf.cc/threads/xf2-8wr-database-backup.381/

 

[narc0s]

https://enxf.cc/threads/xf2-8wr-database-backup.381/

Splichothis will backup all the addon and all the posts and threads etc?

 

[Splicho]

this will backup all the addon and all the posts and threads etc?

narc0sOnly database.

 

[aab985030]

You need to backup the whole sql database, easy done.

https://www.databasemart.com/kb/backup-and-restore-mysql-database

 

[void]

@aab985030 This approach is fine for small databases, but it really doesn’t scale well.
Full backups, especially with mysqldump, become pretty inefficient as data grows. They put noticeable load on the system, take a long time to run, and restores can be painfully slow. In a production environment with larger datasets, that’s just not a great place to be.
A more modern setup usually relies on physical backups combined with incremental backups. That way you reduce resource usage and get much faster recovery times when something actually goes wrong.
Using something like Borgmatic can still make sense, but more as an additional layer for offsite or archival storage. It should not be treated as a standalone solution for consistent database backups.
So overall, the method shown is okay as a starting point, but it is not really suitable for larger or more demanding production setups.

 

[aab985030]

@aab985030 This approach is fine for small databases, but it really doesn’t scale well.
Full backups, especially with mysqldump, become pretty inefficient as data grows. They put noticeable load on the system, take a long time to run, and restores can be painfully slow. In a production environment with larger datasets, that’s just not a great place to be.
A more modern setup usually relies on physical backups combined with incremental backups. That way you reduce resource usage and get much faster recovery times when something actually goes wrong.
Using something like Borgmatic can still make sense, but more as an additional layer for offsite or archival storage. It should not be treated as a standalone solution for consistent database backups.
So overall, the method shown is okay as a starting point, but it is not really suitable for larger or more demanding production setups.

voidOP hasn't told us how big their database is, if they told us it would have changed my answer to what you put.

 

[sucre13]

You just need to see how much the database and root files of Xenforo weigh. As I said, if you need help, what better way than to program an AI script that makes your life easier?