XF2 [8WR] Database Backup

XF2 [8WR] Database Backup [Paid] 2.3.0.1

No permission to buy ($10.00)
Hi
I have been trying to find info on how to back up my xenforo forum from my webhost to my local hard drive. No one offered me any help until yesterday.
Just now I found this, which looks to be what I want.

But as a non forum expert (I have been running my forum for 5 years) why are forums so complicated? why are there so many files to back up?

My webhost say they make a back up every day, (and I can do manual backups)
I used to be able to make an archive and then down this to my hard drive, but now I am using up a lot of my ssd space so I can no longer do this.
Do you have WHM or cPanel? There are backup functions built in.
 
Do you have WHM or cPanel? There are backup functions built in.
I'm sorry I don't understand your reply!
Yes my Siteground webhost has its own version of cPanel

Everyone has access to cPanel
Then why did XF2 write this add on with hundreds of technical questions and good feedback if we could all use C panel
 
I'm sorry I don't understand your reply!
Yes my Siteground webhost has its own version of cPanel

Everyone has access to cPanel
Then why did XF2 write this add on with hundreds of technical questions and good feedback if we could all use C panel
This addon is by @Jaxel I use this addon since it only backs up XF. I also use WHM to do full server backup to an off-site FTP.
Just trying to help get a handle on a good helpful solution.
 
This addon is by @Jaxel I use this addon since it only backs up XF. I also use WHM to do full server backup to an off-site FTP.
Just trying to help get a handle on a good helpful solution.
Basically I have been trying to work out the file structure of my XF forum, so that I can do a manual backup from my webhost to my local hard drive.
It seems very hard to find it out.
I have lots of medium sized images in 150 image folders on my forum and it took hours to try to download them, so I gave up
I wish I could find a simple way to do this
 
Basically I have been trying to work out the file structure of my XF forum, so that I can do a manual backup from my webhost to my local hard drive.
It seems very hard to find it out.
I have lots of medium sized images in 150 image folders on my forum and it took hours to try to download them, so I gave up
I wish I could find a simple way to do this
All XF files are contained in your root XF directory and sub directories.
This addon only automatically uploads backups to Amazon S3, BackBlaze or Dropbox or a FTP server.
bu2.webp


The simplest answer to store the backup files this addon creates locally is to manually transfer it (very large compressed files) or install a local FTP server.
 
Last edited:
The simplest answer to store the backup files this addon creates locally is to manually transfer it (very large compressed files) or install a local FTP server.
Hi
I use it too, but I can't get a configuration that works.
I need an example? How do I configure it for FTP?
;)
 
But as a non forum expert (I have been running my forum for 5 years) why are forums so complicated? why are there so many files to back up?
It is neither more nor less complicated to backup than any other website. Being a forum you will typically have more pictures in most cases and obviously more changes of the data between backup runs than a normal website.
My webhost say they make a back up every day, (and I can do manual backups)
They typically do but most hosts charge you when you want to access the backup plus they only store it for a very limited time and often it is a all or nothing approach with reinstalling the backup. So it is a good last option in case of massive trouble but in many cases not the preferred one.
I used to be able to make an archive and then down this to my hard drive, but now I am using up a lot of my ssd space so I can no longer do this.
Did you miss out on the data base? If you only download the files they are worth not too much w/o also having the database backed up.
Then why did XF2 write this add on with hundreds of technical questions and good feedback if we could all use C panel
XF itself has no built in backup-option, which is a bummer. Not everyone has C-panel (i.e. I don't) or does want to use it. So this is a 3rd party add on and it is brilliant. In comparison to a full blown professional backup software it is really easy to use with only the absolute necessary minimum of questions. The alternative would be writing a set of scripts yourself to do the backups and that would clearly be way more demanding.
I have lots of medium sized images in 150 image folders on my forum and it took hours to try to download them, so I gave up
If you had no pictures on your forum the amount of data would probably be no issue. You may want to read about backup concepts, especially about incremental backups - this saves loads of time and disc space.
 
Thanks @smallwheels

Yes my forum has lots of images - i have about 150 image folders in my Xenforo

Did you miss out on the data base? If you only download the files they are worth not too much w/o also having the database backed up.

Yes of course I'd like to backup the database

I just need to know which folders I need to back up
 
Hello. I purchased your plugin and I'm trying to create a backup of the database and files to FTP. I run the Cron task, it seems to upload to FTP, but the archive appears to be incomplete. I get the following error during the backup creation.

Code:
An exception occurred: [XF\Db\Exception] MySQL statement prepare error [2006]: MySQL server has gone away in src/XF/Db/AbstractStatement.php on line 230

XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 207
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 43
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 61
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1417
XF\Mvc\Entity\Finder->fetchOne() in src/XF/Repository/UpgradeCheckRepository.php at line 34
XF\Repository\UpgradeCheckRepository->getLatestUpgradeCheck() in src/XF/Admin/App.php at line 272
XF\Admin\App->renderPageHtml() in src/XF/App.php at line 2573
XF\App->renderPage() in src/XF/Admin/App.php at line 156
XF\Admin\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
XF\App->run() in src/XF.php at line 806
XF::runApp() in admin.php at line 15

This is how the files were uploaded to FTP.

Screenshot_1.webp

Please help me with a solution.
 
Hello. I purchased your plugin and I'm trying to create a backup of the database and files to FTP. I run the Cron task, it seems to upload to FTP, but the archive appears to be incomplete. I get the following error during the backup creation.

Code:
An exception occurred: [XF\Db\Exception] MySQL statement prepare error [2006]: MySQL server has gone away in src/XF/Db/AbstractStatement.php on line 230

XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 207
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 43
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 61
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1417
XF\Mvc\Entity\Finder->fetchOne() in src/XF/Repository/UpgradeCheckRepository.php at line 34
XF\Repository\UpgradeCheckRepository->getLatestUpgradeCheck() in src/XF/Admin/App.php at line 272
XF\Admin\App->renderPageHtml() in src/XF/App.php at line 2573
XF\App->renderPage() in src/XF/Admin/App.php at line 156
XF\Admin\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
XF\App->run() in src/XF.php at line 806
XF::runApp() in admin.php at line 15

This is how the files were uploaded to FTP.

View attachment 319376

Please help me with a solution.
Unfortunately I couldn't find a solution to the problem. I hope @Jaxel can help 😔
 
Hello. I purchased your plugin and I'm trying to create a backup of the database and files to FTP. I run the Cron task, it seems to upload to FTP, but the archive appears to be incomplete.
How would you know that? What is missing?
I get the following error during the backup creation.
This error obviously hints that the SQL dump may not be complete. As you told nothing about you environment (dedicated or shared, db on the same host or a different one) not much one can hint at other that that a max execution time or such may have been hit.
For diagnosing I would play with the options:

• backup the files only
• backup the database only

and see what the outcomes may be. Basically it is about isolating the failure.

Other than that: Nobody wants backup, everyone wants restore, so once the backup has hopefully run sucessfully make sure to try a restore from the backup as well and see if it is successfull.
 
yes, that is what I want.
To be able to back up my forum to my local hard drive
And then restore it to a local copy of Xenfor just to make sure that it works

There is no point of doing backup if you cant restore them occasionally to test them.

But like everything with xenforo - it just looks so complicated, and the developers don't help by making it easy
They just want to sell you their services.
 
But like everything with xenforo - it just looks so complicated, and the developers don't help by making it easy
They just want to sell you their services.
Sorry, I agree that a backup solution should be part of XF core. But other than that: Developers live from getting paid for their work. Not from giving it away for free. Do you work for free? If not: What do you complain about? If you decide to run a forum and do the technical admistration yourself you should not be surprised that this requires some skills. If you don't have them or don't wont to bother you can go for XF cloud or pay someone to deal with the technical stuff. Very much the same as when you buy a car you can maintain and repair it yourself (and this way safe money) - still most people pay a garage or mechanic to deal with that as they don't have the skills or don't want to bother.

If you decide to offer a service on the internet it is your responsibility to deal with operating it. If you are unable to do it and don't want to pay for someone competent doing it you can't run a forum. It is that easy.
 
Back
Top Bottom