Is a backup completely sufficient?

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
User avatar
AbuHossam
Registered User
Posts: 306
Joined: Sun Sep 02, 2018 7:24 am

Is a backup completely sufficient?

Post by AbuHossam »

Hello everyone!

I have a question about backups: Do they include everything? Like files, themes, and everything else?

Or are they limited to certain features?
image y.jpg
Sorry, I'm using google translate. Try to understand the meaning of my words.
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72375
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Is a backup completely sufficient?

Post by KevC »

You can resurrect a board from just the database but ultimately you need the DB and the files for a complete copy.

The database tables contain the users, posts, forums, permissions, settings etc.
The files have the functionality plus the styles, attachments, avatars, smilies, and extensions. And any custom code changes you might do.
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
User avatar
AbuHossam
Registered User
Posts: 306
Joined: Sun Sep 02, 2018 7:24 am

Re: Is a backup completely sufficient?

Post by AbuHossam »

@KevC

Oh my goodness...

So, how can I take a full and sufficient backup?

Excuse me, a hard drive on my server crashed before, and we suffered a lot, in other websites.

Since then, I have been very careful.
Sorry, I'm using google translate. Try to understand the meaning of my words.
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72375
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Is a backup completely sufficient?

Post by KevC »

It's the same process as moving your board to a new host

Transferring Your Board to a New Host or Domain
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
User avatar
AbuHossam
Registered User
Posts: 306
Joined: Sun Sep 02, 2018 7:24 am

Re: Is a backup completely sufficient?

Post by AbuHossam »

It's a long story, I think it will go to the server specialist.
thank you anyway.
Sorry, I'm using google translate. Try to understand the meaning of my words.
User avatar
Mannix_
Registered User
Posts: 1857
Joined: Sun Oct 25, 2015 2:56 pm
Name: Matt
Contact:

Re: Is a backup completely sufficient?

Post by Mannix_ »

I use software called Syncovery to backup these directories from the server:
  • ext
  • files
  • images
  • store
  • styles
all other directories can be omitted from the backup since those are unmodified files found in the phpBB package.

One copy is stored locally on my machine and another is stored in the cloud.

I also use extension to create db backup that are being saved in the store directory on the server
Did I helped You? Consider a donation.
New version of phpBB has been released? My styles aren't validated for it yet? Check my page for the latest downloads!
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26546
Joined: Fri Aug 29, 2008 9:49 am

Re: Is a backup completely sufficient?

Post by Mick »

There’s a couple of KBs on the subject as well as the one Kev linked.

Knowledge Base - Forum Backup Instructions

Knowledge Base - How to backup and restore your database with SSH
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
User avatar
SpIdErPiGgY
Registered User
Posts: 205
Joined: Sun May 02, 2021 2:11 pm
Location: Erpe-Mere, Aalst, BE
Name: Andy Dm
Contact:

Re: Is a backup completely sufficient?

Post by SpIdErPiGgY »

I use filesync to make an auto backup everynight
https://freefilesync.org/

Then I have a script to auto archive the files with winrar
phpBB NL Extension translations, also on request.
--> Click Here: Myarea51secrets.com <--
User avatar
warmweer
Jr. Extension Validator
Posts: 11270
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Is a backup completely sufficient?

Post by warmweer »

AbuHossam wrote: Tue Apr 02, 2024 12:04 pm
So, how can I take a full and sufficient backup?
1 = database backup
2 = files backup (that means all files/directories in your board root)

The other thing = the only reliable backup is a backup that has been tested and confirmed complete).

As to the database backup: there are 2 options: 1 = data only, 2 = structure and data.

Structure and data is the safest
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
User avatar
AmigoJack
Registered User
Posts: 6113
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Is a backup completely sufficient?

Post by AmigoJack »

As time moves forward you may also want to make sure you still have the installations of all the required software in the supported versions, as those version might become unavailable in the future. It wouldn't be the dumbest idea to at least save once:
  • your HTTP server (most likely Apache)
  • your DMBS software (most likely MariaDB or MySQL)
  • PHP
...each in the versions you currently use and make sure you're able to still install them. If that was done by the hoster in the past then keep in mind that in 5-10 years they might offer you only different versions of that software, or even completely different software.

Why keeping software installation packets which might be outdated in the future? Not because you want to go live with that, but because you want your website to get run at least (which can also happen without access to the internet) to then be able to migrate it to up-to-date software.
  • "The problem is probably not my English but you do not want to understand correctly. ... We will not come anybody anyway, nevertheless, it's best to shit this." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
  • "My reaction is not to everyone, especially to you." Raptiye, 2021-02-28
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 5885
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.
Contact:

Re: Is a backup completely sufficient?

Post by thecoalman »

SpIdErPiGgY wrote: Tue Apr 02, 2024 3:51 pm I use filesync to make an auto backup everynight
https://freefilesync.org/
You can use WinSCP to do this but you need to create a script and have Windows task scheduler fire it off.

One thing to be aware of is a synced file system is not really a true backup because there is no revision of files.e.g. file on the server gets corrupted and you sync it to the backup and now both files are corrupted.
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 5885
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.
Contact:

Re: Is a backup completely sufficient?

Post by thecoalman »

AmigoJack wrote: Tue Apr 02, 2024 10:26 pm Why keeping software installation packets which might be outdated in the future? Not because you want to go live with that, but because you want your website to get run at least (which can also happen without access to the internet) to then be able to migrate it to up-to-date software.
XAMPP has multiple php/MySQL versions going back to at least php 5.X. The XAMPP versions going back to 5.5.X is also the php version.

https://sourceforge.net/projects/xampp/ ... 20Windows/
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
User avatar
SpIdErPiGgY
Registered User
Posts: 205
Joined: Sun May 02, 2021 2:11 pm
Location: Erpe-Mere, Aalst, BE
Name: Andy Dm
Contact:

Re: Is a backup completely sufficient?

Post by SpIdErPiGgY »

thecoalman wrote: Wed Apr 03, 2024 12:28 amOne thing to be aware of is a synced file system is not really a true backup because there is no revision of files.e.g. file on the server gets corrupted and you sync it to the backup and now both files are corrupted.
The auto .rar takes care of that.
It also just goes one way... Server - - > home pc
So yeah... Not really syncing... 😅
phpBB NL Extension translations, also on request.
--> Click Here: Myarea51secrets.com <--
dgkulick
Registered User
Posts: 62
Joined: Tue Jan 30, 2024 9:48 pm

Re: Is a backup completely sufficient?

Post by dgkulick »

Bluehost has something called CodeGuard. The first year appears free and after that is $36 per year. This topic caused me to spend a few minutes setting it up. It backs up the database (you have to give them the username/password) and all the files, It seems that I can click on any backup and restore it. I'm not sure how long it maintains backup but it has some sort of cycle.
User avatar
warmweer
Jr. Extension Validator
Posts: 11270
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Is a backup completely sufficient?

Post by warmweer »

Relying on the host for backups usually results in complacency.

You're better of (read safer) in backing up yourself.
See Forum Backup Instructions
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
Post Reply

Return to “[3.3.x] Support Forum”