[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!
Suggested Hosts
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)
User avatar
david63
Jr. Extension Validator
Posts: 15046
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 Dec 17, 2017 10:49 am

accs-p wrote:
Sat Dec 16, 2017 11:16 pm
Is that change in GitHub?
Not yet
draky wrote:
Sun Dec 17, 2017 10:45 am
In OP, you tell about "sending files using event", is it doable in admin panel ?
No - it is something that another extension can use such as my Dropbox upload
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
draky
Registered User
Posts: 247
Joined: Tue Dec 10, 2002 2:04 pm
Location: France
Name: Gilles W.
Contact:

Re: [3.2][RC] Auto db Backup

Post by draky » Sun Dec 17, 2017 10:56 am

Thanks a lot :)

Elmarc
Registered User
Posts: 8
Joined: Wed May 25, 2016 9:15 am

Re: [3.2][RC] Auto db Backup

Post by Elmarc » Thu Dec 28, 2017 8:15 pm

I tried uploading 3 ways, just in case, and none showed up in the Extensions Manager.
The current board version in use is 3.2.1.
I installed the Image Upload extension without any issues, so I am at a loss.

Here's what I tried:

/ext/david63/autodbbackup/david63-autodbbackup-3.2/[unzipped files]
/ext/david63/david63-autodbbackup-3.2/[unzipped files]
/ext/david63-autodbbackup-3.2/[unzipped files]

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

Re: [3.2][RC] Auto db Backup

Post by canonknipser » Thu Dec 28, 2017 8:43 pm

Try
/ext/david63/autodbbackup/[unzipped files]
in [unzipped files], there is a file called composer.json, open it with a good text editor and you'll find the "name" tag giving you the path for extensions

Edit: the complete path is also given in the very first post:
david63 wrote:
Sun Jan 08, 2017 10:14 am
Upload the unzipped files to root/ext/david63/autodbbackup a
where root means the phpBB-root folder (where config.php is)
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB

Elmarc
Registered User
Posts: 8
Joined: Wed May 25, 2016 9:15 am

Re: [3.2][RC] Auto db Backup

Post by Elmarc » Fri Dec 29, 2017 12:07 am

/phpBB3.2/BulletinBoard/ext/david63/autodbbackup/david63-autodbbackup-3.2/
is where the files were first placed.

By referring to the file you listed, it should have been /phpBB3.2/BulletinBoard/ext/david63/autodbbackup/[unzipped files]

I misunderstood your convention, expecting the last to be a folder, the way that Image Upload was described.

It came up in the Extensions Manager and enabled now.

lichang422
Registered User
Posts: 20
Joined: Mon Oct 31, 2016 3:57 am

Re: [3.2][RC] Auto db Backup

Post by lichang422 » Fri Jan 19, 2018 3:22 am

I used at 3.2.2
When I setting "Next backup time"
Why does it show "Year need smaller than 1971"

And when I set to 1971, submit
It will show "Need to set in the future time"

So how do i set it??

User avatar
david63
Jr. Extension Validator
Posts: 15046
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 » Fri Jan 19, 2018 3:25 am

I cannot answer that as I have not tested it on 3.2.2 and will not be in a position to do so for at least another six weeks.
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
WelshPaul
Registered User
Posts: 252
Joined: Tue Aug 19, 2014 2:09 pm

Re: [3.2][RC] Auto db Backup

Post by WelshPaul » Tue Jan 23, 2018 7:34 pm

lichang422 wrote:
Fri Jan 19, 2018 3:22 am
I used at 3.2.2
When I setting "Next backup time"
Why does it show "Year need smaller than 1971"

And when I set to 1971, submit
It will show "Need to set in the future time"

So how do i set it??
Works fine with 3.2.2, just tested it.

Waltons72
Registered User
Posts: 36
Joined: Sat Jan 14, 2017 1:39 pm

Re: [3.2][RC] Auto db Backup

Post by Waltons72 » Sun May 20, 2018 2:18 am

Never mind i got it working now i disable it then delete the data on it then re enable it then it started working.

arnyeinstein
Registered User
Posts: 14
Joined: Mon Oct 03, 2016 1:17 pm

Re: [3.2][RC] Auto db Backup

Post by arnyeinstein » Thu May 24, 2018 7:30 am

Hi
What data did you delete? I have the same problem: I only can set the year to 1970 or 1971.
Cheers
Renger

Waltons72
Registered User
Posts: 36
Joined: Sat Jan 14, 2017 1:39 pm

Re: [3.2][RC] Auto db Backup

Post by Waltons72 » Thu May 24, 2018 11:07 am

Renger,

Disable it then click delete data on it then re enable it then it should start working if it still shows 1971 disabled it again then click delete data again then re enable it

arnyeinstein
Registered User
Posts: 14
Joined: Mon Oct 03, 2016 1:17 pm

Re: [3.2][RC] Auto db Backup

Post by arnyeinstein » Mon Jun 04, 2018 2:38 pm

Thanks! Is now as it should be.
Renger

Waltons72
Registered User
Posts: 36
Joined: Sat Jan 14, 2017 1:39 pm

Re: [3.2][RC] Auto db Backup

Post by Waltons72 » Mon Jun 04, 2018 3:54 pm

You're welcome.

User avatar
KYPREO
Registered User
Posts: 80
Joined: Fri Feb 02, 2018 9:56 am
Contact:

Re: [3.2][RC] Auto db Backup

Post by KYPREO » Wed Jun 06, 2018 2:05 am

I looked for an answer in this thread but couldn't it. Apologies in advance if I missed it.

What are people's experiences with this extension with very large databases? I have a 6GB database uncompressed, which I could backup as a smaller package if I opted not to backup the search index database (maybe 3GB by itself?).

Since it runs using phpBB's inbuilt cron it only runs when the board is accessed, so I'm concerned that the user will then experience hangs while the database is being backed up, without knowing what was going on. Is the quality or reliability of the backup affected by running it on a live board?

Many years ago, one of my board's former admins wrote a batch script that backed up the database daily using the mySQL CLI. This was scheduled using Windows Task Scheduler (our server is a self managed VPS running on IIS). The script also redirected the domain name to a maintenance page explaining that the website was offline for backups. This helped speed up the process and ensured data wasn't being read/written from the database during the backup.

My plan is to still make periodic manual backups of the physical website code and importantly the attachments /files folder, given they are less likely to be corrupted.

I could setup the custom script again. However, I like the idea of being able to configure this all directly from the ACP and upload copies to a dropbox for remote access. Do I need to worry with a large database or will all be fine?

Thanks in advance and thanks david63 for authoring this extension. 8-)
phpBB user since 2002
www.AusRotary.com

accs-p
Registered User
Posts: 2
Joined: Thu Feb 08, 2018 7:38 pm

Re: [3.2][RC] Auto db Backup

Post by accs-p » Fri Jun 08, 2018 5:52 am

KYPREO wrote:
Wed Jun 06, 2018 2:05 am
Since it runs using phpBB's inbuilt cron it only runs when the board is accessed, so I'm concerned that the user will then experience hangs while the database is being backed up, without knowing what was going on. Is the quality or reliability of the backup affected by running it on a live board?

Many years ago, one of my board's former admins wrote a batch script that backed up the database daily using the mySQL CLI. This was scheduled using Windows Task Scheduler (our server is a self managed VPS running on IIS). The script also redirected the domain name to a maintenance page explaining that the website was offline for backups. This helped speed up the process and ensured data wasn't being read/written from the database during the backup.
I'm running this on a Linux-based Hosting service, and I have the same problem (inadequate usage during "off-hours"). To resolve this, I created a cron job

Code: Select all

# Run the phpBB crontab command
*/5 * * * * /usr/local/bin/php /home/user/forum-directory/bin/phpbbcli.php cron:run
This runs the phpBB cron check every 5 minutes.

I expect that Windows can do something similar.

It should be noted that the backup will slowly shift to a later time. This issue has been addressed previously in this topic.

Post Reply

Return to “Extensions in Development”

Who is online

Users browsing this forum: MarkDHamill, mrgoldy and 20 guests