DB Backup Scheduler

https://www.phpbb.com/ideas/
Ideas Bot
Registered User
Posts: 381
Joined: Sat Oct 13, 2012 10:06 am

DB Backup Scheduler

Post by Ideas Bot » Sun Feb 04, 2018 6:20 pm

The idea is really simple. The possibility to schedule the normal backup procedure with the help of the phpbb cron. The possible choises to make those backup maybe the follow: daily, weekly, montly, manual. Another cool option mayby the backup retention number. Another cool option is to automatic send the db compressed throw mail for having the backup in a safe place.

There is two possibility to implement: core stuff, or an official extension supported by the phpbb team to allow this feature.

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

Re: DB Backup Scheduler

Post by Lumpy Burgertushie » Sun Feb 04, 2018 6:40 pm

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

tojag
Registered User
Posts: 74
Joined: Thu Aug 07, 2014 8:00 am

Re: DB Backup Scheduler

Post by tojag » Mon Feb 05, 2018 11:02 am

This should be in core or official extension to always provide a tool compatible with the current version of phpbb.

User avatar
Sir Xiradorn
Registered User
Posts: 10
Joined: Thu Sep 17, 2009 3:51 pm
Location: MMM....i don't know.....
Contact:

Re: DB Backup Scheduler

Post by Sir Xiradorn » Sun Feb 11, 2018 8:40 pm

Lumpy Burgertushie wrote:
Sun Feb 04, 2018 6:40 pm
viewtopic.php?f=456&t=2400156

robert
Yep i know this extension, but i think is a very good enhancements to the built-in phpbb backup system and infact the smart david used a phpbb cron for doing those tasks. So the step to be an official ext is really close in my opinion
Sir Xiradorn
Image
~ Xiradorn Lab - xiradorn.it ~
~ GitHub - XiradornLab ~

Image
Stargate for phpbb 3.0.x || Stargate for phpbb 3.1.x

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

Re: DB Backup Scheduler

Post by Mick » Mon Feb 12, 2018 10:37 am

I have an issue with auto backups from a bad experience years ago. You can backup the DB as much as you like but if the back ups are flawed because of whatever it’s a waste of time. You can’t beat a phpMyAdmin back up and a quick check on your local PC. For something as important as this it’s paramount to be sure your back up is good.
"The more connected we get the more alone we become" - Kyle Broflovski

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

User avatar
david63
Jr. Extension Validator
Posts: 13499
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: DB Backup Scheduler

Post by david63 » Mon Feb 12, 2018 7:14 pm

Mick wrote:
Mon Feb 12, 2018 10:37 am
I have an issue with auto backups from a bad experience years ago. You can backup the DB as much as you like but if the back ups are flawed because of whatever it’s a waste of time. You can’t beat a phpMyAdmin back up and a quick check on your local PC. For something as important as this it’s paramount to be sure your back up is good.
I would not disagree that those comments - however if any backup routine is using the phpBB routines then there should be enough confidence in those routines to be able to accept their validity.

I too have had problems in the past (maybe 3.0) with the phpBB backup/restore but every restore that I have done recently from a phpBB backup has worked without any problems.

There is nothing wrong with a "belt and braces" approach though.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

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

Re: DB Backup Scheduler

Post by Mick » Mon Feb 12, 2018 8:03 pm

To be honest I haven’t used the phpBB backup for a long time. I’ll try it next time I have to do something in 3.2.

My paranoia will still insist I check the backups though😠
"The more connected we get the more alone we become" - Kyle Broflovski

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

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

Re: DB Backup Scheduler

Post by thecoalman » Tue Feb 13, 2018 12:59 am

There is not a whole lot of difference between phpmyadmin backups and phpBB, both serve as frontends for the database and will operate under the same php limitations. Execution time limits or others can cause a truncated file with no indication the backup did not complete unless you look at the server logs or examine the backup.

If you are working with a large database you really should be working with shell command or script that can issue them. If you have root access this script will do anything you need:

https://sourceforge.net/projects/automysqlbackup/

It will create daily, weekly and monthly backups and rotate them out as required. I never rotate the monthly backups. I have my FTP scheduled to download new backup daily.

User avatar
canonknipser
Registered User
Posts: 1308
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: DB Backup Scheduler

Post by canonknipser » Tue Feb 13, 2018 9:18 pm

I use mysqldumper via server cron script to generate my backups. The project is discontinued by the author, but still maintained by the community, see https://github.com/DSB/MySQLDumper and the tool is adapted to PHP 7.
The english documentation seems to be gone, but the english section in the support board is still active: http://forum.mysqldumper.de/index.php?c=6

There is also a extension to use mysqldumper from the acp: https://www.phpbb.de/community/viewtopi ... 9&t=236351 (only in german, I'm afraid)
Greetings
Frank
phpbb.de support team member
English is not my native language
New arrival - Extensions and scripts for phpBB
no support via PM or mail

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

Re: DB Backup Scheduler

Post by Lumpy Burgertushie » Tue Feb 13, 2018 10:26 pm

to me, the biggest problem with the acp backup is that it will not work in bigdump.
and also, the fact that it will just stop if it times out without any error message at all. as stated above, you have to check the backup file to make sure it got it all.
I have never seen phpmyadmin do that without an error message.


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

User avatar
warmweer
Registered User
Posts: 822
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: DB Backup Scheduler

Post by warmweer » Wed Feb 14, 2018 10:42 am

Lumpy Burgertushie wrote:
Tue Feb 13, 2018 10:26 pm
to me, the biggest problem with the acp backup is that it will not work in bigdump.
???
Bigdump has been an irreplaceable item for me ever since my database backups (partials even) started to exceed 100 MB (zipped).
The ACP backups work just fine with me with Bigdump (staggered), whereas phpMyAdmin times out with large SQLfiles.
The only problem with Bigdump now is that it doesn't work with php 7+ (well, I can't get it to work).
A bug is a feature that hasn't made it to the manual (yet)

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

Re: DB Backup Scheduler

Post by Lumpy Burgertushie » Wed Feb 14, 2018 5:08 pm

you are correct of course, I was thinking backwards at the time.

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

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

Re: DB Backup Scheduler

Post by Mick » Fri Feb 16, 2018 10:22 am

david63 wrote:
Mon Feb 12, 2018 7:14 pm
if any backup routine is using the phpBB routines then there should be enough confidence in those routines to be able to accept their validity
Agreed but, for me, it’s too big a deal to assume everything is good, I was brought up assuming nothing.
Mick wrote:
Mon Feb 12, 2018 8:03 pm
I’ll try it next time I have to do something in 3.2
I did try it and it worked but I’ve had 3.0 ACP backups that worked in the past but it’s the reliability that concerns me. It’s hard for me to be comfortable with doing a backup without checking it’s validity.
"The more connected we get the more alone we become" - Kyle Broflovski

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

User avatar
Ger
Registered User
Posts: 1257
Joined: Wed Jan 02, 2008 7:35 pm
Location: 192.168.1.100
Contact:

Re: DB Backup Scheduler

Post by Ger » Fri Feb 16, 2018 1:43 pm

Doesn't every descent host offer DB backups in the control panel? I can go back 7 days, that would suffice I'd say.
Checkout my extensions: Simple CMS, Feed post bot, Avatar Resize, Modbreak, Magic OGP links and Live topic update

Like my work? Buy me a coffee to keep it coming. :ugeek:

User avatar
WelshPaul
Registered User
Posts: 237
Joined: Tue Aug 19, 2014 2:09 pm

Re: DB Backup Scheduler

Post by WelshPaul » Fri Feb 16, 2018 3:37 pm

Ger wrote:
Fri Feb 16, 2018 1:43 pm
Doesn't every descent host offer DB backups in the control panel? I can go back 7 days, that would suffice I'd say.
You assume that everyone uses a host that provides such services! The services you describe are usually provided by shared hosting or managed dedicated/vps companies however i'm sure there are many out there just like myself that use both Dedicated and VPS (unmanaged) servers where there are no backups, control panel or support (other than account related) offered.

Post Reply

Return to “phpBB Ideas”

Who is online

Users browsing this forum: No registered users and 15 guests