[3.2][RC] Auto db Backup

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Scam Warning
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
Post Reply
User avatar
david63
Jr. Extension Validator
Posts: 13144
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

[3.2][RC] Auto db Backup

Post by david63 » Sun Jan 08, 2017 10:14 am

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.

Extension Version: [RC] 2.1.0-rc2

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/david63-autodbbackup
Extension Download: https://github.com/david63/david63-auto ... ve/3.2.zip
Last edited by david63 on Fri Feb 10, 2017 1:22 pm, edited 3 times in total.
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
david63
Jr. Extension Validator
Posts: 13144
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: [3.2][RC] Auto db Backup

Post by david63 » Sun Jan 08, 2017 10:15 am

Reserved
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
HiFiKabin
Community Team Member
Community Team Member
Posts: 2303
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact:

Re: [3.2][RC] Auto db Backup

Post by HiFiKabin » Sun Jan 08, 2017 2:07 pm

Setting the hours on 'Next Backup Time' is an hour slow

ie set 14 as the hour but it saves as 13

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

Re: [3.2][RC] Auto db Backup

Post by david63 » Sun Jan 08, 2017 2:10 pm

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:
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
david63
Jr. Extension Validator
Posts: 13144
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: [3.2][RC] Auto db Backup

Post by david63 » Sun Jan 08, 2017 3:50 pm

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.
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
HiFiKabin
Community Team Member
Community Team Member
Posts: 2303
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact:

Re: [3.2][RC] Auto db Backup

Post by HiFiKabin » Sun Jan 08, 2017 4:49 pm

Image


Strange as I am (supposedly) on a UK server

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

Re: [3.2][RC] Auto db Backup

Post by david63 » Sun Jan 08, 2017 5:32 pm

I don't understand that at all.

I am fairly confident that the problem is timezone related
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
HiFiKabin
Community Team Member
Community Team Member
Posts: 2303
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact:

Re: [3.2][RC] Auto db Backup

Post by HiFiKabin » Sun Jan 08, 2017 5:59 pm

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

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

Re: [3.2][RC] Auto db Backup

Post by david63 » Sun Jan 08, 2017 7:01 pm

Might be a "silly" question - but have you enabled it?

Works just fine on my clean install of 3.2 gold.
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
HiFiKabin
Community Team Member
Community Team Member
Posts: 2303
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact:

Re: [3.2][RC] Auto db Backup

Post by HiFiKabin » Sun Jan 08, 2017 8:16 pm

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

User avatar
alex75
Registered User
Posts: 280
Joined: Sun Jun 10, 2012 9:09 am
Location: Italy
Name: Alessandro
Contact:

Re: [3.2][RC] Auto db Backup

Post by alex75 » Sun Jan 08, 2017 8:59 pm

+1 ;)

User avatar
HiFiKabin
Community Team Member
Community Team Member
Posts: 2303
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact:

Re: [3.2][RC] Auto db Backup

Post by HiFiKabin » Tue Jan 10, 2017 9:43 am

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.

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

Re: [3.2][RC] Auto db Backup

Post by david63 » Tue Jan 10, 2017 10:20 am

James - can you download it again - I have put a minor tweak in that should fix the "hour" problem (I hope)
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
HiFiKabin
Community Team Member
Community Team Member
Posts: 2303
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact:

Re: [3.2][RC] Auto db Backup

Post by HiFiKabin » Tue Jan 10, 2017 10:49 am

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

User avatar
supanet
Registered User
Posts: 227
Joined: Sat Dec 15, 2012 4:20 pm
Location: UK
Contact:

Re: [3.2][RC] Auto db Backup

Post by supanet » Sat Jan 14, 2017 3:04 pm

Subscribed 8-)

Post Reply

Return to “Extensions in Development”

Who is online

Users browsing this forum: deanmoke, nou nou, RomaamoR and 19 guests

cron