Page 1 of 19

[3.2][3.3][RC] Auto db Backup

Posted: Sun Jan 08, 2017 10:14 am
by david63
Extension Name: Auto db Backup for 3.2
Author: david63

Extension Description: An extension for phpBB 3.2.x that will automatically backup your database using the phpBB 3.2 Cron.

Image Image

Extension Version: [RC] 2.1.0-RC9

Requirements: 3.2.0

Notes:
  • This is an updated version of Pico88's Auto Database Backup extension - updated for 3.2
  • If you are using the original version then it must be Disabled /Delete data and the original files deleted before installing this version - this will not delete any stored backup files.
Features:
  • Enable/disable auto database backup
  • Auto db backup frequency - now set as hours
  • Database optimization
  • The quantity of stored backups can be set
  • The backup time
  • The backup file type - gzip, bzip2 or text
  • The ability, via an event, to export the backup files
New:
  • Timezone fix (RC2)
Installation:
  • Download the latest release and unzip it.
  • Upload the unzipped files to root/ext/david63/autodbbackup and enable it in the ACP

GitHub Repository: https://github.com/david63/autodbbackup
Extension Download: https://github.com/david63/autodbbackup/archive/3.2.zip

Re: [3.2][RC] Auto db Backup

Posted: Sun Jan 08, 2017 10:15 am
by david63
Reserved

Re: [3.2][RC] Auto db Backup

Posted: Sun Jan 08, 2017 2:07 pm
by HiFiKabin
Setting the hours on 'Next Backup Time' is an hour slow

ie set 14 as the hour but it saves as 13

Re: [3.2][RC] Auto db Backup

Posted: Sun Jan 08, 2017 2:10 pm
by david63
I must admit that I have had that happen, but never went back to. Once set it looks after itself anyway.

If you want 14 then set it to 15 :lol: :lol: :roll:

Re: [3.2][RC] Auto db Backup

Posted: Sun Jan 08, 2017 3:50 pm
by david63
HiFiKabin wrote:
Sun Jan 08, 2017 2:07 pm
Setting the hours on 'Next Backup Time' is an hour slow
Can you check what the timezone is set as in your php.ini file - there are two settings. Strangely in one place mine was set as Europe/Berlin - this was with Xampp and was the cause of the problem.

Re: [3.2][RC] Auto db Backup

Posted: Sun Jan 08, 2017 4:49 pm
by HiFiKabin
Image


Strange as I am (supposedly) on a UK server

Re: [3.2][RC] Auto db Backup

Posted: Sun Jan 08, 2017 5:32 pm
by david63
I don't understand that at all.

I am fairly confident that the problem is timezone related

Re: [3.2][RC] Auto db Backup

Posted: Sun Jan 08, 2017 5:59 pm
by HiFiKabin
I have set it to backup at 1730 today, and it didn't. Changing the times, frequency and method seem to make no difference.

No backups in store. No errors in error log.

phpBB 3.2.0 updated from RC2 which in turn was updated from RC1

PHP Version 7.0.14

Re: [3.2][RC] Auto db Backup

Posted: Sun Jan 08, 2017 7:01 pm
by david63
Might be a "silly" question - but have you enabled it?

Works just fine on my clean install of 3.2 gold.

Re: [3.2][RC] Auto db Backup

Posted: Sun Jan 08, 2017 8:16 pm
by HiFiKabin
Yup, all enabled and set 'correctly' (well maybe) and nothing seems to be working. I have set the frequency to 1 hour and there is no difference.

I'll do some more testing and tweaking tomorrow

Re: [3.2][RC] Auto db Backup

Posted: Sun Jan 08, 2017 8:59 pm
by alex75
+1 ;)

Re: [3.2][RC] Auto db Backup

Posted: Tue Jan 10, 2017 9:43 am
by HiFiKabin
OK, I have been hitting testing it all yesterday and it is working, but it is not backing up as often as it is set to. I suspect the time issue is the, erm, issue.

If I set the 'next backup' time to (say) 12 hours, then save it refreshes as 11 hours.

If I just hit save again, it refreshes to 10 hours.

... and so on.

I am getting backups when the times 'meet in passing' as it were.

Re: [3.2][RC] Auto db Backup

Posted: Tue Jan 10, 2017 10:20 am
by david63
James - can you download it again - I have put a minor tweak in that should fix the "hour" problem (I hope)

Re: [3.2][RC] Auto db Backup

Posted: Tue Jan 10, 2017 10:49 am
by HiFiKabin
Downloaded and installed fresh copy. No difference

Purged Cache (just in case) No Difference

Hitting submit without changing any data rolls the hour back by one

Re: [3.2][RC] Auto db Backup

Posted: Sat Jan 14, 2017 3:04 pm
by supanet
Subscribed 8-)