[BETA] Automatic Database backup

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
jcpren
Registered User
Posts: 18
Joined: Mon Apr 17, 2006 3:11 pm

Re: [BETA] Automatic Database backup

Post by jcpren »

Thanks for this excellent mod - it's just what I was looking for! :)

It took me a bit of experimentation to work out that "Delay Time" is there to prevent subsequent instances of the backup script being invoked during the time it takes for the initial instance to complete, but now that I have it set correctly, everything works like magic.
alez
Registered User
Posts: 237
Joined: Tue Feb 22, 2005 11:21 pm

Re: [BETA] Automatic Database backup

Post by alez »

alez wrote:~ 57 mb without search tables...
:roll:
kkroo
Registered User
Posts: 729
Joined: Sat Dec 03, 2005 4:49 pm
Contact:

Re: [BETA] Automatic Database backup

Post by kkroo »

Sorry for the late reply.

A made a calculation and your db backup file would be ~130MB


So I would increase the memory limit to something like 200MB just to be safe
My MODs

Need a coder?

Enjoy my Mods? - Image
jcpren
Registered User
Posts: 18
Joined: Mon Apr 17, 2006 3:11 pm

Re: [BETA] Automatic Database backup

Post by jcpren »

Whenever I get the message that the board is disabled and that the backup is in progress, my board is always ready again immediately if I press Refresh, though the backup e-mail doesn't arrive until several minutes later.

Does this sound like normal behaviour, or do you think the board is being re-enabled too quickly? I have about 15000 posts in my board.

Many thanks!
kkroo
Registered User
Posts: 729
Joined: Sat Dec 03, 2005 4:49 pm
Contact:

Re: [BETA] Automatic Database backup

Post by kkroo »

That is absolutely normal.

Hope that helps
My MODs

Need a coder?

Enjoy my Mods? - Image
User avatar
p4plus2
Registered User
Posts: 140
Joined: Sat May 26, 2007 5:06 am

Re: [BETA] Automatic Database backup

Post by p4plus2 »

Seems good, ill be installing this mod on my forum later tonight!(Id do now however im in the middle of upgrading hosts\transfering filess and all that good stuff :P)
My lo-fi version of phpbb MOD

Help the Dial up users, give them a chance! :D
kavatah
Registered User
Posts: 6
Joined: Mon Mar 05, 2007 2:36 pm

Re: [BETA] Automatic Database backup

Post by kavatah »

Hello Kkroo.

I've been using your mod for the past 4-5 months and it works pretty good.

I went on vacation for a week and juste before I left, everything worked fine.
Now that I've returned, I found out that there was a problem with the backup.

Since I installed the mod, I had my backups sent by email (to a Gmail address), saved to the backup directory on my server, and uploaded on an other FTP server.
But now, I don't receive the email anymore.
In the ACP it is still set to send the email, and the email address et right, but I don't receive it anymore ...

I set the mod to backup the DB avec twelve hours, so I received until now two emails. Now... nothing.

Do you know where this could come from ?

I have also another issue:
Sometimes, after a backup, my forum stays disabled. I think that this happens when someone tries to refresh the forum while it is backing up, but is there anyway for that not to happen ?

Thank you for your reply.

Regards,

Kavatah
d4rk^
Registered User
Posts: 30
Joined: Wed Mar 31, 2004 7:15 pm

Re: [BETA] Automatic Database backup

Post by d4rk^ »

I think I have found a bug.

The Only phpBB-related tables feature can't be actually enabled. Every time you enable it, click Submit and return to the configuration, it's being disabled.

I have even re-checked it on a fresh phpBB installation and it just seems it's a bug.


You didn't include the Included Files: number in the install.txt.


Just a cosmetic fix: You could align the includes/constants.php text line with the other ones under the Files To Edit: in the install.txt file. ;)
kkroo
Registered User
Posts: 729
Joined: Sat Dec 03, 2005 4:49 pm
Contact:

Re: [BETA] Automatic Database backup

Post by kkroo »

Could you check it in phpmyadmin and see if it is being changed? There is a possibility that it is getting changed and it is not being selected in the ACP view.

I'll try to fix the install file when I got some spare time as it isn't a vital issue, thanks anyways.


Thanks
My MODs

Need a coder?

Enjoy my Mods? - Image
d4rk^
Registered User
Posts: 30
Joined: Wed Mar 31, 2004 7:15 pm

Re: [BETA] Automatic Database backup

Post by d4rk^ »

kkroo wrote:Could you check it in phpmyadmin and see if it is being changed?
Yes, it is being changed.
kkroo wrote: There is a possibility that it is getting changed and it is not being selected in the ACP view.
Yup, you're right about that, good guess. :)

But am I the only one with such problem? I mean, did you check it yourself?
anonuser
Registered User
Posts: 50
Joined: Tue May 15, 2007 6:23 pm

Re: [BETA] Automatic Database backup

Post by anonuser »

I quickly checked through all pages of the thread, but I can't figure out what's wrong.

I can see that the .php in cache/auto_backup changes the modified date, but no backups are created. I want to backup the db using "Email backups" and "Save backups to backups directory", but not even the last one seems to work.
My database is about 200mb in size though (without search tables).. I've tried to set the memory limit to 200mb by adding that line to the auto_backup.php (I can't create htaccess files, I'm pretty limited, unfortunately), but it didn't help. Increasing the delay time to 1000 didn't help, either.
How could I find out what the problem is, only having ftp access?..
Any help is greatly appreciated.
kkroo
Registered User
Posts: 729
Joined: Sat Dec 03, 2005 4:49 pm
Contact:

Re: [BETA] Automatic Database backup

Post by kkroo »

Unfortunately, this script is as limited as your php settings go. The problem you are experiencing is due to the size of your DB. When the script is backing up your large database, it is reaching the memory_limit defined in the php.ini The only work-around that I have managed to come up with is increasing the memory_limit in some way such as the ini_set function in the actual script (if enabled by your host), or .htaccess or changing the value in php.ini

Omar
My MODs

Need a coder?

Enjoy my Mods? - Image
anonuser
Registered User
Posts: 50
Joined: Tue May 15, 2007 6:23 pm

Re: [BETA] Automatic Database backup

Post by anonuser »

That's what I expected to be the problem :(
Thanks. Seems like I can't get around waiting for the root admin - ini_set("memory_limit", "200M"); didn't have any effect on the setting, and I can't try the other methods.


EDIT:
Maybe you can change your mod to work similar to this mod:
http://www.phpbb.com/community/viewtopi ... 5&t=359433

beacuse with this one, updating works fine. I haven't looked into the differences of yours and this mod, but maybe..?
moustafamin
Registered User
Posts: 230
Joined: Thu Aug 30, 2007 8:10 am

Re: [BETA] Automatic Database backup

Post by moustafamin »

is there a possibilty to make a version of this great mod for phpBB3????????
User avatar
ahmedgroup
Registered User
Posts: 111
Joined: Thu Jul 19, 2007 12:45 pm

Re: [BETA] Automatic Database backup

Post by ahmedgroup »

moustafamin wrote:is there a possibilty to make a version of this great mod for phpBB3????????
oh it will be so good
Post Reply

Return to “[2.0.x] MODs in Development”