[CDB] Auto Database 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!
Anti-Spam Guide
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
Walther
Registered User
Posts: 303
Joined: Fri Jul 09, 2004 5:21 pm
Location: The Netherlands

Re: [RC] Auto Database Backup

Post by Walther »

okay, none of the backups are working, not the autobackup made, not the handmade, the restorefunction just don't seem to work

Am trying manually with ssh now , maybe the database is too big
User avatar
Pico88
Registered User
Posts: 878
Joined: Sat Mar 07, 2009 10:24 pm
Location: Poland
Name: Lukasz

Re: [RC] Auto Database Backup

Post by Pico88 »

That can be a problem. ;)
Please do not PM me for support.
User avatar
Walther
Registered User
Posts: 303
Joined: Fri Jul 09, 2004 5:21 pm
Location: The Netherlands

Re: [RC] Auto Database Backup

Post by Walther »

Thanks for this extension, it saved the forum :)
Maybe half a day worth of postings might be gone, but 11 years of postings could be restored !

mysqldump did the trick with restoring after a lot of 'huh? password? i allready gave a username/password' issues in ssh with gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname] constructions.

Note: big databases (60MB compressed) can *NOT* be restored on every platform from within ACP :ugeek:
Even phpMyAdmin goofed up due to too much time-out's.

Maybe, just maybe, you can make a better *improved* restore extension for phpBB 3.1.x ?
So people won't have to go through installing mysqldump and so on.
Holger
Registered User
Posts: 1904
Joined: Tue Mar 12, 2002 3:54 pm
Location: Hannover

Re: [RC] Auto Database Backup

Post by Holger »

Maybe integrate mysqldumper?
Funkycowie
Registered User
Posts: 17
Joined: Tue Mar 24, 2009 9:02 pm

Re: [RC] Auto Database Backup

Post by Funkycowie »

I use this to import mine when I have needed it in the past.

http://www.ozerov.de/bigdump/
User avatar
dmzx
Registered User
Posts: 866
Joined: Fri Sep 05, 2014 6:48 am
Location: The Netherlands

Re: [RC] Auto Database Backup

Post by dmzx »

I set the Backup frequency to one day.
when looking into the admin log, the backup will be add to a user or anonymous user?

Image

Image
Contact me on dmzx-web.net
User avatar
Pico88
Registered User
Posts: 878
Joined: Sat Mar 07, 2009 10:24 pm
Location: Poland
Name: Lukasz

Re: [RC] Auto Database Backup

Post by Pico88 »

It's normal.
https://www.phpbb.com/customise/db/mod/ ... 81#p339081
and more in support for Auto Backup
Please do not PM me for support.
User avatar
dmzx
Registered User
Posts: 866
Joined: Fri Sep 05, 2014 6:48 am
Location: The Netherlands

Re: [RC] Auto Database Backup

Post by dmzx »

Pico88 wrote:It's normal.
https://www.phpbb.com/customise/db/mod/ ... 81#p339081
and more in support for Auto Backup
Thanks
Contact me on dmzx-web.net
..777..
Registered User
Posts: 150
Joined: Tue Oct 28, 2014 5:43 pm

Re: [RC] Auto Database Backup

Post by ..777.. »

Hi, will it be an option to set it up for multiple backups a day in the future? I find that limiting backups to 1 a day might not be optimal for some users.

Thank you so much for you time and effort on this extension.
User avatar
Lumpy Burgertushie
Registered User
Posts: 69228
Joined: Mon May 02, 2005 3:11 am

Re: [RC] Auto Database Backup

Post by Lumpy Burgertushie »

if you have a need for multiple backups a day I would suggest you use a database backup software that you have much more control over. something like mysqldumper. I believe you can set that to make however many backups you wish, whenever you wish and to wherever you wish.


robert
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.

Return to “Extensions in Development”