Question about backup

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
new.new
Registered User
Posts: 37
Joined: Sun Aug 12, 2018 9:53 am

Question about backup

Post by new.new » Thu Aug 16, 2018 6:23 pm

Let's suppose i do a backup of my board (ACP -> maintenance -> backup), selecting "Full" in "backup type", and selecting all tables in the list.
What data are saved exactly? I supposed all posts and user infos (usernames, hashed passwords etc.) are saved. But what about extensions? are they also saved in the backup file? What about files like user's avatars, emoticon etc? Are they also saved?

Basically the question is: if i restore that backup on another server, will the board look exactly like before? Or do i need to manually save something other?

Also i noticed a strange thing, if i go in ACP->general, i find this data: "Database size: 4.7 MiB". Then i tried to do a backup, and it downloaded an archive that contains a single .sql file that has a size of about 1.1 Mb (uncompressed size). Is it normal this difference in the two values?

User avatar
Lumpy Burgertushie
Registered User
Posts: 64868
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Question about backup

Post by Lumpy Burgertushie » Thu Aug 16, 2018 7:29 pm

no, that backup in the admin panel is just for the database.

the extensions, images, etc. are all in the files which are in a completely different place on the server.

to back them up, you do a backup of all the files using ftp.

then, in order to completely recover back to the beginning, you would have to import your database backup ( sql file ) to the database on the server and also, upload all of the files that you downloaded using ftp, back to the server using ftp.

then you should have a completely recovered board.

this type of backup is only needed just to be safe. when doing an update/upgrade etc. you do that backup first, just in case the aliens come in and zap your server or something while you are doing the update/upgrade.

robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

cleverwise
Registered User
Posts: 37
Joined: Fri Feb 28, 2014 10:55 pm
Location: Atlanta, GA
Name: Jeremy

Re: Question about backup

Post by cleverwise » Thu Aug 16, 2018 7:41 pm

The database size difference is probably normal. MySQL should be configured to use InnoDB as the storage engine.

InnoDB has many reasons for the larger size than when your data is dumped. For starters as data grows InnoDB will grow the space required which makes sense. However if some of that data is deleted the engine will not release that space back to the filesystem. So if InnoDB requires 5MBs and data is removed so it fits in 1MB well 5MB is still "used".

Also InnoDB stores data and keys differently from say MyISAM. This results in larger tables. If you want read up on all the technical reasons behind InnoDB's B-Tree index storage.

I haven't seen the file so can't say 100% but what you describe is normal. For example I have one data set that is 56MB dumped but like 210MB according to InnoDB. That is normal. I generally see 3 to 4 times the size, however your mileage may vary.
Respectfully,
Jeremy

DevOPs - Linux Admin, PHP Developer, Oracle DBA OCP Training
Display phpBB statistics on WordPress (Read more...)

User avatar
Lumpy Burgertushie
Registered User
Posts: 64868
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Question about backup

Post by Lumpy Burgertushie » Thu Aug 16, 2018 8:42 pm

and/or it is just a difference in how the database backup is constructed. in other words, is is data only or data and structure etc.

does it have only inserts or does it contain both values and inserts etc. etc.

bottom line is, when you make a backup it is always a good idea to check it to see if all the tables are there.

once you get the backup file on your computer, unzip it and then open the sql file in a good text editor.

scroll down to the bottom, make sure it has the zebra table since that is the last one.


robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

new.new
Registered User
Posts: 37
Joined: Sun Aug 12, 2018 9:53 am

Re: Question about backup

Post by new.new » Thu Aug 16, 2018 9:44 pm

Thanks for your answer
So, it's there some documentation on how to do a complete backup/restore (ex. what folders are to be saved etc.) ?
Last edited by Mick on Fri Aug 17, 2018 9:45 am, edited 1 time in total.
Reason: Removed unnecessary quoting.

User avatar
Lumpy Burgertushie
Registered User
Posts: 64868
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Question about backup

Post by Lumpy Burgertushie » Thu Aug 16, 2018 10:56 pm

pretty simple.

complete backup:
1. using phpmyadmin or whatever your host provides for database management, export the complete database that you are using for your board.
2. using ftp, backup your complete phpbb folder/files. if you have your board in a folder named phpBB3 then just download that folder to your computer and you are done.
if it is named something else like "forum" etc. download whatever folder it is in.
if your board is in the root of your domain then most likely it will be in the directory named "public_html" or "htdocs" or whatever your home directory is on your server.
on your computer, make a folder called backup or whatever you want. then download all of the files/folders that belong to phpbb to that folder on your computer.

done.

rob ert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

new.new
Registered User
Posts: 37
Joined: Sun Aug 12, 2018 9:53 am

Re: Question about backup

Post by new.new » Fri Aug 17, 2018 8:35 am

If I understand well, i've simply to download the entire phpbb folder from my server, and export the SQL database
And the backup feature in the ACP it's only a fast backup of the most important data, but if i donwload the entire folder i don't have to do also this backup, right?

And what about the restore?
Do I have just to copy the phpbb folder on the new server? Or do I have to do other operations?
Last edited by Mick on Fri Aug 17, 2018 9:46 am, edited 1 time in total.
Reason: Removed unnecessary quoting.

User avatar
Mick
Support Team Member
Support Team Member
Posts: 19986
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Question about backup

Post by Mick » Fri Aug 17, 2018 9:41 am

The easiest way is to follow the relevant sections (backup/restore) of Transferring Your Board to a New Host or Domain.
"The more connected we get the more alone we become" - Kyle Broflovski

There are no ‘threads’ in phpBB, they are topics.

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51317
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Question about backup

Post by Brf » Fri Aug 17, 2018 11:59 am

new.new wrote:
Fri Aug 17, 2018 8:35 am
And the backup feature in the ACP it's only a fast backup of the most important data, but if i donwload the entire folder i don't have to do also this backup, right?
The ACP backup is backing up your database. The database is not in your folder.

User avatar
Lumpy Burgertushie
Registered User
Posts: 64868
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Question about backup

Post by Lumpy Burgertushie » Fri Aug 17, 2018 5:01 pm

the reason we suggest to use phpmyadmin to export/backup your database instead of using the phpbb backup is because the phpbb backup will sometimes time out before it is finished. it also gives you no warning that it has done so.

I believe this is due to some server setups but I am not sure why it happens, it just does some times.

doing it as an export from phpmyadmin eleminates this problem.


robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

new.new
Registered User
Posts: 37
Joined: Sun Aug 12, 2018 9:53 am

Re: Question about backup

Post by new.new » Fri Aug 17, 2018 9:35 pm

Lumpy Burgertushie wrote:
Fri Aug 17, 2018 5:01 pm
the reason we suggest to use phpmyadmin to export/backup your database instead of using the phpbb backup is because the phpbb backup will sometimes time out before it is finished. it also gives you no warning that it has done so.

I believe this is due to some server setups but I am not sure why it happens, it just does some times.

doing it as an export from phpmyadmin eleminates this problem.


robert
can i use phpmyadmin also to restore the backup?

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49472
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Question about backup

Post by stevemaury » Fri Aug 17, 2018 11:56 pm

Yes.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

User avatar
John connor
Registered User
Posts: 1722
Joined: Fri Nov 14, 2014 5:14 pm
Location: U S Of A
Contact:

Re: Question about backup

Post by John connor » Sat Aug 18, 2018 2:54 am

If you intend on using Filezilla, read this. https://www.phpbb.com/support/docs/en/3 ... filezilla/

jonhcarter
Registered User
Posts: 17
Joined: Fri Aug 10, 2018 4:04 am

Re: Question about backup

Post by jonhcarter » Sat Aug 18, 2018 12:06 pm

here is the simple method:

Login in to cPanel > backup > create full backup & download backup.

this will backup your entire data & any host can restore it for you, just provide them full backup file.

User avatar
Lumpy Burgertushie
Registered User
Posts: 64868
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Question about backup

Post by Lumpy Burgertushie » Sat Aug 18, 2018 2:16 pm

that is not entirely true.

as with the post above. cpanel is only used by some (most) hosting companies. other hosting management software will be completely different.

also, in cpanel when you do that backup, it backs up the whole server not just the board. that may or may not be what you need to do.

following the instructions given in this post and the documentation is the best way to backup and restore phpbb for most people.



robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: invenio, Paul, Restless Rancor and 14 guests